Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    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 #-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 matt

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    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'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •