Friday, February 24, 2012

Help with what should be a simple delete?

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'

No comments:

Post a Comment