Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > RS causing strange error

Thread Tools

RS causing strange error

Posts: n/a
For some reason,, the following recordset rs("w2itd1") will run fine
when I'm looping it out on a page, but when I have it inside a sql
statement, I get errors.

for example:

sql = " Insert into table (title) values ('"& rs("w2itd1") &"') "

This will give me an error. The contents of this rs is a book title.
Oddly enough, however, if I enter any other of the rs("fieldnames")
that I have, in exactly the same fashion, I have no problem. There
just seems to be an issue with the text coming thorugh. Can someone
indicate what the problem could be?


Reply With Quote
Posts: n/a
1. what error exactly?
2. Response.Write strSQL

Atrax. MVP, IIS

newsflash : Atrax.Richedit 1.0 now released.

*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
onclick on <a> causing strange behavior, please help? Erland Javascript 6 09-06-2007 08:40 AM
REE: Error in ASP internal code causing sessions to be dropped D A H ASP .Net 1 01-28-2005 04:30 PM
ASP.NET names forms inside user controls with an invalid name causing script error William D. Sossamon ASP .Net 0 05-04-2004 03:04 PM
SmartNavigation and Panels causing debug error Chris Ruegsegger ASP .Net 4 08-08-2003 02:24 AM
AssemblyVersionAttribute is causing compile error! Siew Fai ASP .Net 0 07-04-2003 07:34 AM