what is wrong here ??

[David Laplante]

can someone tell me what is wrong here?? (this is connected to a ms sql database throught ODBC


rstCheckupCheques.Open "SELECT * FROM Cheque " & _
"WHERE Cheque_Recipient = '" & Recipient & _
"' AND Cheque_Date = #" & CDate(GetCgiValue("Cheque_Date")) & _
"# AND Cheque_Address = '" & Address & _
"' AND Cheque_Amount = " & Amount & _
" AND Cheque_Description = '" & Description & _
"' AND Cheque_FileNo = '" & FileNo & _
"' AND Cheque_Branch = '" & ChequeBranch & "'", DBConnection, adOpenStatic


I get the folowing error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '#'. Error Number = -2147217900

I checked and GetCgiValue("Cheque_date") is not null or empty... it is a valid date

thanks

[kovan]

try a DATE instead of a variable
like type 02/02/02 there and see if its a sql problem or if its the variable..

[Stevie]

Give this a go ...


rstCheckupCheques.Open "SELECT * FROM Cheque " & _
"WHERE Cheque_Recipient = '" & Recipient & _
"' AND Cheque_Date = #" & Format(CDate(GetCgiValue("Cheque_Date")), "mm/dd/yyyy") & _
"# AND Cheque_Address = '" & Address & _
"' AND Cheque_Amount = " & Amount & _
" AND Cheque_Description = '" & Description & _
"' AND Cheque_FileNo = '" & FileNo & _
"' AND Cheque_Branch = '" & ChequeBranch & "'", DBConnection, adOpenStatic