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 |
|
Jeff McConville
Starting Member
1 Post |
 Posted - 2003-03-27 : 09:47:47
|
| I'm having a strange problem with my ASP application and I hope someone can help me out. A client's server is running Windows XP with SQL Server 2000 and my recordsets are acting funny. The first time I "access" the value of a field with a text data type, I can read the value fine, but subsequent attempts don't see the value. Here's some example code to demonstrate the problem:dim rsTestmySQL = "SELECT * FROM MyTable"Set rsTest = myDSN.Execute(mySQL)Response.Write(rsTest("MyField") & "<br>")Response.Write(rsTest("MyField") & "<br>")Response.Write(rsTest("MyField") & "<br>")In this case, only the first Response.Write writes out the value in the field. The other two just write out the <br>'s. This problem only seems to happen with text data types, not varchar fields, but if I access a text field first, other fields get affected as well. It's a really bizarre problem. The connection made to the database is through a DSN. I figure it's a setting or problem with either IIS, SQL Server, or the DSN, since my pages and scripts all work fine on other machines. If anyone can help me with this, I'd really appreciate it.Thanks. |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2003-03-27 : 09:52:26
|
| Replied on the other forum you posted this...... |
 |
|
|
|
|
|
Disappearing field values