Too Few Parameters

Results 1 to 3 of 3

Thread: Too Few Parameters

  1. #1
    Jean Withers Guest

    Default Too Few Parameters

    Trying to delete with following lines - it&#039s passing the ID OK, so it has one parameter - how many does it want???!!!<BR><BR>&#060;%SQLstmt = "DELETE * from Nodes where ID=" & ID<BR>Set RS = conn.execute(SQLstmt)<BR><BR>Error message as follows:<BR>Database Errors Occurred<BR>DELETE * from Nodes where ID=63<BR><BR>Error #-2147217904<BR><BR>Error desc. -&#062; [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.<BR><BR>Thanks, Jean Withers<BR>

  2. #2
    KUMAR S Guest

    Default RE: Too Few Parameters

    Hi<BR> Check the syntax of SQL Statement<BR>"DELETE * from Nodes where ID=" & ID<BR>It should be "DELETE from Nodes where ID=" & ID<BR>It will delete the entire row for the corresponding ID from the<BR>Nodes table.<BR><BR>Try It out. If u get still any other problems you can post or reply to this one<BR><BR>KUMAR<BR>

  3. #3
    Jean Withers Guest

    Default RE: Too Few Parameters

    Thanks Kumar, but I still get the same message. The DELETE * has worked OK before.<BR><BR>Jean

Posting Permissions

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