Recent content by jasonsalas

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