var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 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 desc. -> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
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.
Re: Help with what should be a simple delete?
Strings have to be enclosed in single quotes in SQL:
DELETE * from Customer where Cust_ID = 'MATWAR61849'