Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-09 : 09:32:54
|
| Dave writes "I use ntext fields a lot. In ASP when I return a record set, often after retrieving a value from one of these fields i can't seem to get any other data example ...SQLQuery="Select bigfield, littlefield from bigtable"Set rs=conn.execute(SQLQuery)bigstuff=rs("bigfield")littlestuff=rs("littlefield")'littlestuff' has no field data. I REM the 'bigstuff=' line and 'littlestuff' contains the field data. Its like I need to set some sort of query buffer or something?SQL2000 and Windows2000 (not sure what service paks)DC" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-04-09 : 09:32:54
|
You have to put the ntext fields last in your select statement and then you have to retrieve them from the recordset in the order they are selected.
So retrive littlefield and then bigfield and change the order in the SELECT statement.
At least, that's what I had to do. |
 |
|
|
|
|
|
NTEXT Fields in ASP