Search results for query: *

hi all, i'm trying to export a DB table i've got to CSV, part of which requires me to have to wrap a field of type TEXT in quotations ("). concatenation doesn't work because SQL Server thinks i'm doing an addition operation: SELECT id,title,'"'+body+'"' as [body] FROM table i tried CAST'ing...

Hi everyone, I'm hoping someone can help me out with a problem. I'm trying to run a SPROC that needs to return data only if a column of type VARCHAR(200) can be converted to type INT. Basically, I've got varying types of data within the column from URLs, including record IDs, and I need to...

I'm trying to reference a Flash animation in a WebPartZone for a dynamic time widget, but it won't render. The file can be accessed either through SCRIPT or EMBED tags within the page's body. So, it's not contained within a regular ASP.NET control that can be wrapped into a...

I'With the AJAX craze of late I'm doing a lot more OOP-style JavaScript. I'd like to know how to create/call Java/C#-style static methods (shared methods for the VB'ers) in JavaScript. I know how to use prototypes to create methods within defined classes, like so: // constructor function...

Is there a way to change the 'Content-Type' header for web services with ASP.NET 1.x? I need to have my API return 'text/javascript' instead of the normal 'text/xml'.

Hi everyone, I'm building a news ticker element contained within a DIV on a page I've got, using JavaScript to manage the left-to-right animation. However, I'd like to include a separate DIV below the main container, which lets people jump ahead to a certain category within te content...

Hi everyone, I'm building a news ticker element contained within a DIV on a page I've got, using JavaScript to manage the left-to-right animation. However, I'd like to include a separate DIV below the main container, which lets people jump ahead to a certain category within te content...

I'm having an interesting problem using ADO.NET with XML in .NET 1.x. I'm trying to use multiple recordsets in the same SPROC, calling them via SqlCommand.ExecuteXmlReader(). Is there a way to emulate SqlDataReader.NextResult() to move through each recordset? I know that method isn't...

This is about XML in .NET 1.x. I'm trying to use multiple recordsets in the same SPROC, calling them via SqlCommand.ExecuteXmlReader(). Is there a way to emulate SqlDataReader.NextResult() to move through each recordset? I know that method isn't available in XmlReader. I figure if this...

I've got a rather interesting problem...I've got the a single table with EMAIL and MOBILE fields both of type VARCHAR used in an alert registration system. Users can register their e-mail address and/or a mobile number, either at the same time or coming back and registering the other one later...

What’s the name of the function in SQL Server that lets you truncate the amount of data that’s pulled down in a field? I’m querying a DB table and need to only return at most 15 characters of a large VARCHAR field. Thanks!

I've got two tables, TABLE1 and TABLE2. TABLE2 has the exact same columns and data types as TABLE1, with an additional INT column as a foreign key to TABLE1's primary key. I'm trying to create a homegrown rollback operation wherein when a record is updated in a webpage, the contents of TABLE1...

Hi everyone, I'm trying to run an UPDATE sproc en masse to tally the results of a voting app I built for the upcoming NCAA March Madness tournament. I'm trying to update a master table with the value of a computed column. If two fields match (SELECTEDWINNERS and REALLIFEWINNERS), then the...

Hi everyone, I've got a SPROC that generates a recordset of user vote tallies (they're calculated in a separated SPROC). The user submissions are grouped by a GUID value so as to remain unique for a user's submission (each user can have multiple submissions. The problem is that the recordset...

Hi everyone, I'm trying to see if this would work in JavaScript...I'd like to read the entire contents of a directory and then print out the contents as XML, or optimally, generate an XML file and write it to disk. The server upon which I'm going to use this script doesn't have any ral...

Does SQL Server have a built-in function like SUM() or COALESCE() that can accept a delimited string of some sort whwrein I can pass multiple values? For instance, if I have 60 form elements on a webpage, can I set the form elements to a single comma-delimited string (or other delimiting...

I'm building an app to manage the upcoming NCAA March Madness tournament. I'm going to use a third-party control from www.tourneylogic.com to manage the actual brackets, but I've got a problem in determining the winner for a public pool I'm running. Basically, I want to select the winner of...

I've been trying to grab all records from the current month, but I've run into trouble. This is what I'm using: SELECT ColumnID,ColumnDate FROM TableName WHERE ColumnDate = MONTH(GETDATE()) Got any pointers on how to evaluate a column of type SMALLDATETIME, only looking within the current...

Hi everyone, I'm a web dev with no WinForms experience, and I've got an interesting query. I’d like some advice on developing a toolbar for IE, which will hotlink to some URLs I provide, and call a web service to do searches against my company’s news article database. An example of what I'm...

Hi, I'm trying to call a helper method that takes as an argument a Bitmap object, which needs to be converted to a byte array for posting into a database field of type IMAGE. Nothing fancy, the logic's just stumped me. This is in in business tier, so it's not exactly using a file upload form...