Whats wrong this this query?

Discussion in 'Databases' started by TopSite, Apr 6, 2008.

  1. #1
    Hello,

    I am getting this error:-
    Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 
    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. 
    
    Code (markup):
    Whats wrong in this query:-
    ObjRs2.Open"Select * From ShoppingCart_tbl where sid='"&inID&"' And Flage='O' and cID="&cID,ObjCnn,3,1
    Code (markup):
    Url is :-
    hxxp://xxxx.com/xx.asp[B]?inID=1035042100&cID=1035042100[/B]
    Code (markup):
    Thanks :)
     
    TopSite, Apr 6, 2008 IP
  2. Rory M

    Rory M Peon

    Messages:
    1,020
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Last variable is not closed with "
     
    Rory M, Apr 6, 2008 IP