Search results for query: *

hi ryan, i've found that i can't do VARCHAR(MAX) because i'm running SQL 2000. my host is nice enough to migrate just that table to SQL 2005. :)

thanks george! yeah, i'm learning this is quite the challenge!

hi simi, that didn't take either. the issue is the '+' concatenation operator...TEXT fields see it as trying to do addition, which causes it to error.

i'm running SQL Server 2000. thanks!

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...

Thanks! It worked out. I really appreciate the help.

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...

Thanks! I got it to work as I suspected...using a custom server control and writing the necessary tags referencing the Flash code in the page. Thanks for your help!

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've also seen people define multiple methods for the same JavaScript class within a JSON array: // constructor function Person() { this.fname = 'foo'; this.lname = 'bar'; } Person.prototype = { method1: function() {}, method2: function() {}, method3: function() {} } ...OOP in...

Thanks tsuji! A lot of the constructs I've seen with Prototype and script.aculo.us use something like: var Person = { doSomething: function() { alert('Feigning a static method'); } } Person.doSomething(); ...I've tried replicating those examples in my own samples, but they never...

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...

Hi werd420, Yeah, I thought about this, but I'm trying to avoid using a DataSet for purposes of performance and the fact that I'm publishing a public XML feed for others to access. I'm actually progrmamatically applying an XSLT process to the XML and working with the UI this way.

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!