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 - 2000-08-31 : 16:17:59
|
George writes "the sql statement
SELECT ENGLISHDESCRIPTIONS FROM PRODUCTS WHERE PRODUCT='F4193'
returns perfectly when the product is
Brown Cow
but is the product is
Brown Cow with "Glowing" nose
the asp script coughs up
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
Although a C++ statement will return
Brown Cow with "Glowing" nose
as will a straight sql statement in iSql.exe Query Analyser. Asp seems to interpret this as part of the ASP/HTML script....
Can't even get to the variable to strip out the " marks, because the error occurs the minute that the variable is used for anything.... If I use a SQL server UDF to strip out the quotes, the asp won't see the variable itself.
Interesting and frustrating...
Any ideas.
Environment...
Win2000 (sp1) or NT4.0 (sp6a)
Sql Server 6.5"
|
|
|
|
|
|
Quotation marks in the returned variable cause ADODB.Field error '800a0bcd'