I can’t get an INSERT SQL statement to work using a form text box to set the criteria when using text as the WHERE criteria It works with primary key and figures, and text when written into the code, but won't accept text entere
by 
Anonymous
ANSWERS: 3
-
What language are you running? PHP / ASP /???
-
Network ninja thanks for your relply I am using Acceess 2003 VB This works "INSERT INTO tblTwo SELECT * FROM tblOne WHERE PrimaryKeyInvoice = " & txtInput This works "INSERT INTO tblTwo SELECT * FROM tblOne WHERE Country = ‘England’ " This doesn’t work "INSERT INTO tblTwo SELECT * FROM tblOne WHERE Country = " & txtInput It gets an error message…'No value given for one or more parameters'.
-
You're trying to pass it a string that's not wrapped in single quotes, try this: "INSERT INTO tblTwo SELECT * FROM tblOne WHERE Country = " & "'" & txtInput & "'"
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC