OK...weird problem here

[japes89]

I have a simple recordset being pulled from a SQL DB.

set rsth = CreateObject("ADODB.Recordset&quot
strSQLh = "select * from Exhibits where ID=1"
rsth.Open strSQLh, conn


when I do a response.write of the first value ID, everything is OK, meaning it writes to the page.
--->response.write rsth("ID&quot
when I do a response.write for second value name, eveything is still OK.
--->response.write rsth("name&quot

yet when I do a response.write of rsth("notes&quot, notes do not show up and the value for name is gone now!

--->response.write rsth("notes&quot

I have even dim-ed variables and assign the recordset value to each variable, but same issue pops up.

Anyone have this problem? More importantly, anyone have a solution.

FYI .....
ID is int
Name is varchar(200)
Notes is text

JP
_______________________________________________
OutsideIntranets.com
Stop wasting time, get to work

http://www.outsideintranets.com

 

[japes89]

Just found out something.....the error maybe due to 1 or more text type variants in the database. Whenever I try to pull a value from the database with a variant of text, then the rest of the variables get screwed.

any ideas why? _______________________________________________
OutsideIntranets.com
Stop wasting time, get to work

http://www.outsideintranets.com

 

[JamesLean]

Have a look at this info, specifically the last technique about using the correct cursor location/type:

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=80

--James