vj
|
| Posted: 04/29/2002, 9:41 PM |
|
Hi,
I created one ASP CC project very successfully, but when I created another project, even a very simple one, I get this fault message. Can anyone help?
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (Microsoft OLE DB Provider for ODBC Drivers)
Thanks in advance.
VJ
|
|
|
 |
Nicole
|
| Posted: 04/30/2002, 4:56 AM |
|
Refer to:
http://www.gotocode.com/art.asp?art_id=22&#_Toc517639976
|
|
|
|
Rico
|
| Posted: 05/10/2002, 6:22 PM |
|
did that solve your problem. If not, I solved it in a different way. Had the same issue.
|
|
|
|
Castor
|
| Posted: 05/12/2002, 12:24 PM |
|
the FAQ on http://www.gotocode.com/art.asp?art_id=22&#_Toc517639976 did not help, the problem is the same ...
|
|
|
|
Natalie
|
| Posted: 10/03/2002, 4:38 PM |
|
I am having the same problem. I have re-created the database, and CCS page numerous times, checked that all fields we the same as the database and also the field type was the same too..... Here is what I am getting:
Source: Record Users / Insert Operation
Command Text: INSERT INTO Users(Membershipid, FirstName, LastName, Address, City, StateProvince, Country, zip, Email, Terms, OfAge, receiveOffers, BillingStatement, Username, Password, regDate, status) VALUES (2, '3r3r', '3r23r', '3r23r', '23r2', '3r3r', '23r3r', '55565', 'nbd@nbdesign.com', '1', '1', '1', '1', 'fdbdsf', 'dfbdb', '10/3/2002', 3)
Error description: Syntax error in INSERT INTO statement. (Microsoft JET Database Engine)
INSERT INTO Users(Membershipid, FirstName, LastName, Address, City, StateProvince, Country, zip, Email, Terms, OfAge, receiveOffers, BillingStatement, Username, Password, regDate, status) VALUES (2, '3r3r', '3r23r', '3r23r', '23r2', '3r3r', '23r3r', '55565', 'nbd@nbdesign.com', '1', '1', '1', '1', 'fdbdsf', 'dfbdb', '10/3/2002', 3)
Can anyone help me?
Thanks Natalie
|
|
|
|
angie k
|
| Posted: 10/03/2002, 9:32 PM |
|
Is "password" a field name and also a reserved word in VB/asp??
|
|
|
|
Tony Swaby
|
| Posted: 10/04/2002, 8:38 AM |
|
Exact same form created in CC works, but done in CCS = Syntax error in INSERT INTO statement.
I wish I could make the jump from CC to CCS, everytime I try I fail is it just me?
Tony...reluctantly Sticking with CC
|
|
|
|
Natalie
|
| Posted: 10/04/2002, 9:50 AM |
|
I hear you Tony. The transition is tricky, especially if you are new to coding. Everything workred fine in CC but for CCS I just do not understand why this is such a problem. I have recreated the table using a different name, different fields and everything. Sill I get the Syntax error in INSERT INTO statement.
I have checked with MSDN and have written to support here. I am still waiting on an answer from CC on this. I will post anything they tell me for you all.
If anyone can think of a fix in the meantime, PLEASE help! 
Natalie
|
|
|
|
Tony swaby
|
| Posted: 10/04/2002, 10:46 AM |
|
Hi Natalie - it works now - wrong DB type  ~
tony
|
|
|
|
Natalie
|
| Posted: 10/04/2002, 11:01 AM |
|
I tried that, I changed the ANSI SQL-92 to Access, but that did not help. I am still getting this:
Source: Record memb / Insert Operation
Command Text: INSERT INTO memb(Membershipid, fname, lname, address, city, state, zip, country, email, username, password, age, billing, mailings, regDate, status) VALUES (1, 'rturtu', 'rturtu', 'rturtu', 'rturtu', 'rturtu', '55985', 'ndb', 'nbd@nbdesign.com', 'dfh', 'dfh', 1, 1, 1, '10/4/2002', 3)
Error description: Syntax error in INSERT INTO statement. (Microsoft JET Database Engine)
INSERT INTO memb(Membershipid, fname, lname, address, city, state, zip, country, email, username, password, age, billing, mailings, regDate, status) VALUES (1, 'rturtu', 'rturtu', 'rturtu', 'rturtu', 'rturtu', '55985', 'ndb', 'nbd@nbdesign.com', 'dfh', 'dfh', 1, 1, 1, '10/4/2002', 3)
I have done everything I know to do including creating another table, new fields, new page etc.... Nothing works.
This is a bugger
I am happy you got your working.
|
|
|
|
Tony Swaby
|
| Posted: 10/04/2002, 1:42 PM |
|
Hi Natalie
Yeah I know, just check that the DB type has changed in the properties window of the connection.
Next "what should be a simple thing", a list of values in is dropdown.
I've done all this and more in CC, is this progression?
Don't let it beat ya.......
|
|
|
|
Natalie
|
| Posted: 10/04/2002, 2:26 PM |
|
Boy did I mess up. I erased ALL my files by accident. I have started from scratch AGAIN, and I am still having the same darn trouble. I am only having this trouble on the one form. I have tried textboxes for every field and the same darn thing. Every other form works perfect except for the register form. I just do not understand
Oh well, it will work itself out sooner or later
Thanks Tony.
|
|
|
|
CDS
|
| Posted: 10/04/2002, 4:00 PM |
|
Did you check to make sure all your fields in CCS are of the same datatype as in your database?
|
|
|
|
Natalie
|
| Posted: 10/04/2002, 4:02 PM |
|
Yes, and.... I have deleted the page and started all over several times using the page wizards and everything.
|
|
|
|
Natalie
|
| Posted: 10/04/2002, 9:28 PM |
|
Thanks everyone for trying to help..... I finally got this thing figured out. For some reason, the code did not like the field name password. I changed it to passwd and it is taking the entered data with no problem.
Thanks for your help everyone.
|
|
|
|
|
