RS causing strange error

Discussion in 'ASP General' started by Bill, Jul 29, 2003.

  1. Bill

    Bill Guest

    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?

    Thanks,

    Bill
    Bill, Jul 29, 2003
    #1
    1. Advertising

  2. Bill

    Atrax Guest

    Atrax, Jul 29, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Siew Fai
    Replies:
    0
    Views:
    528
    Siew Fai
    Jul 4, 2003
  2. Chris Ruegsegger

    SmartNavigation and Panels causing debug error

    Chris Ruegsegger, Aug 6, 2003, in forum: ASP .Net
    Replies:
    4
    Views:
    452
    Yan-Hong Huang[MSFT]
    Aug 8, 2003
  3. D A H
    Replies:
    1
    Views:
    1,574
    LenM22
    Jan 28, 2005
  4. William D. Sossamon
    Replies:
    0
    Views:
    401
    William D. Sossamon
    May 4, 2004
  5. Erland
    Replies:
    6
    Views:
    117
    Thomas 'PointedEars' Lahn
    Sep 6, 2007
Loading...

Share This Page