1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

why doesn't this ASP string work?

Discussion in 'C#' started by xorcst@yahoo.com, Feb 17, 2008.

0
  1. #1
    Set rsBooks = Server.CreateObject("ADODB.RecordSet")
    rsBooks.ActiveConnection = strConn
    rsBooks = Connection.Execute("Call sp_getBooks(""King James"");")
    rsBooks.Open "Call sp_getBooks(""King James"")"
    response.write (" TEST ")
    rsBooks.Close


    ----
    i get a "can not return result in current context" error.
    PLEASE HELP
     
    xorcst@yahoo.com, Feb 17, 2008 IP
  2. fabriciogr

    fabriciogr Active Member

    Messages:
    958
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    73
    #2
    i'm no asp expert as i haven't coded in that in over 5 to 6 years.. now i'm more a opensource language coder... PHP/Python and hopefully Ruby soon...

    anyhow those quotes seems a bit odd to me...

    rsBooks = Connection.Execute("Call sp_getBooks(""King James"");")

    Why not try something like:

    rsBooks = Connection.Execute("Call sp_getBooks('King James');")

    OR

    rsBooks = Connection.Execute("Call sp_getBooks(\"King James\");")

    but as I mentioned I no longer remeber anything about asp and its syntaxes
     
    fabriciogr, Feb 17, 2008 IP