|
-
This is really dumb
What's the syntax error in this insert statement?
String sql = "INSERT INTO Feedback ( Name, Email, Extn, Date, Description, Alternate, Type) VALUES(" +rname+ ", " +email+ ", " +extn+ ", #" +date+ "#, " +description+ ", " +alternate+ ", " +type+ ")" ;
rname, email etc are all variables I've defined already.
date is a Date
extn is a Number
the rest are all text
the DB I'm using is MS Access.
I'm really rusty on this right now.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|