Query Problems

Discussion in 'C#' started by ghadacr, Oct 3, 2007.

0
  1. #1
    Hi all,

    I have a problem with a query it keeps on coming with the following error..

    Here is the code for the query:

    SQLBABYSITTING = "SELECT * FROM BookedActivities WHERE  ((BookedActivities.BookingID)='Babysitting requested')) AND ((BookedActivities.BookingID)=" & Session("BookingID") & "));"
    PHP:
    A bit baffled, all the help will be apperciated, thanks
     
    ghadacr, Oct 3, 2007 IP
  2. ashrafweb

    ashrafweb Member

    Messages:
    67
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    its a strange error
    its the first time i see it!!
     
    ashrafweb, Oct 3, 2007 IP
  3. kadesmith

    kadesmith Peon

    Messages:
    479
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Fix your SQL Statement Try this instead:

    SQLBABYSITTING = "SELECT * FROM BookedActivities WHERE ((BookedActivities.BookingID)='Babysitting requested') AND ((BookedActivities.BookingID)=" & Session("BookingID") & ");"

    Your statement has too many closing )
     
    kadesmith, Oct 8, 2007 IP