Calling two text columns in one rs

[travisbrown]

Is there a known problem with calling two text columns in one rs or command, either from a sp or page sql?

I've got a table in SS 2000 with two text columns. I can't call them both in one select statement. To get it to work, I split them into two tables and created two seperate recordsets. It failed even when doing a cross join.

 

[snowboardr]

strSQL = "Select column_one, column_two FROM table_name"

www.vzio.com
ASP WEB DEVELOPMENT

 

[travisbrown]

Yeah, I've kind of got a select statement figured out. I'm having a problem displaying data from a table that has two columns of "text" datatype (SQL Server 2000)

Thanks.

 

[snowboardr]

That shouldn't be a problem, do you get an error? www.vzio.com
ASP WEB DEVELOPMENT

 

[travisbrown]

Not an error, but it fails. It will only display one of the rs items. The other just acts lik it is empty. If I write a conditional on the item, I can only trigger a response if rs.field("item&quot = "", even if I verify that there is data in the field.
I've heard that sometimes text colums have to be the last item in the sql statement. I think it has to do with not being able to determine length or something. This, I guess, coud be a problem if I have two text columns in one statement.