I have the following code that will not work... It produces ths message:
DELETE * from Customer where Cust_ID = MATWAR61849
Error #-2147217904
Error desc. -> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Cust_ID=request.querystring("ID")
SQLstmt = "DELETE * from Customer where Cust_ID = " & Cust_ID
Set RS = conn.execute(SQLstmt)
I think the problem is that the variable is not being interpreted as a string, but rather a number.
In the database, Cust_ID is defined as a text entry.
What do I need to do to fix this? Yes, I know I am a newbie.
Thanks mattStrings have to be enclosed in single quotes in SQL:
DELETE * from Customer where Cust_ID = 'MATWAR61849'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment