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.

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