Can't pull data from ntext field into recordset.

rstelma · August 26th, 2003, 03:49 PM

Hi All,

Glad to see your smiling faces again.

Imported data from an ntext field. The source and destination fields are both ntext.

After getting the data imported, I can't pull any data from that field into the recordset, into the variable.

Features = oRS("Features")
Response.Write Features

This returns nothing, but I can go into QA and see data.

If I change the data type to varchar, I can pull the data into the recordset but because of the length of that datatype, the data is truncated.

Does anyone know why this is happening and how I can resolve it?

Really appreciate your responses.

Thank you,
Richard Stelma

Imar · August 26th, 2003, 04:07 PM

Hi Richard,

In what order do you retrieve the Ntext / Blob from the database? There used to be (maybe still are) some problems with ADO when you requested the BLOB before other fields in the code.

So this would fail:

Code:

(SELECT Blob, AnInt FROM MyTable)
Response.Write(Recordset("Blob"))
Response.Write(Recordset("AnInt"))

while this would work:

Code:

(SELECT AnInt, Blob FROM MyTable)
Response.Write(Recordset("AnInt"))
Response.Write(Recordset("Blob"))

Hope this helps,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

rstelma · August 26th, 2003, 04:50 PM

Hi Imar,

It worked! I've had this ordering problem before and never new it was directly related with pulling ntext/blob datatypes.

Although, I didn't pull the BLOB last. I did assign the variable value in the same order that the fields were pulled in the SQL statement. And that did work.

SQL = "Select this, that, BLOB, theother from Table1;"
Set oRS = oConn.Execute(SQL)

this = oRS("this")
that = oRS("that")
theBlob = oRS("BLOB")
theother = oRS("theother")

Thank you so much for your reply. You've saved me so much time and trouble.

Thank you,
Richard