Syntax error in INSERT INTO statement

SteamTank · Apr 28, 2012

I'm having a problem that I'm sure is being caused by a rookie error. I've written some code that is supposed to take a user registration form and insert it into a dbase. The page loads fine and when I hit "submit" I get a "Syntax error in INSERT INTO statement" error. Here's the code: sub Button1_Click(obj as object, e as EventArgs) if Page.IsValid then dim ds as new Dataset ("ds_users") dim objcmd2 as new OleDbDataAdapter ("select * from gd_user", myconn) dim objAutoGen as new OleDbCommandBuilder(objcmd2) objcmd2.Fill(ds, "gd_user") dim dr as datarow = ds.tables("gd_user").newrow() dr(0) = user.text dr(1) = password.text dr(2) = company.text dr(3) = first_name.text dr(4) = last_name.text dr(5) = email.text dr(6) = bill_address1.text dr(7) = bill_address2.text dr(8) = bill_city.text dr(9) = bill_state.selecteditem.text dr(10) = bill_province.text dr(11) = bill_zip.text dr(12) = bill_country.selecteditem.text dr(13) = bill_areacode.text dr(14) = bill_phone1.text dr(15) = bill_phone2.text dr(16) = bill_address1.text dr(17) = bill_address2.text dr(18) = bill_city.text dr(19) = bill_state.selecteditem.text dr(20) = bill_province.text dr(21) = bill_zip.text dr(22) = bill_country.selecteditem.text dr(23) = bill_areacode.text dr(24) = bill_phone1.text dr(25) = bill_phone2.text dr(26) = cc_name.text dr(27) = cc_type.selecteditem.text dr(28) = cc_number.text dr(29) = cc_ccv.text dr(30) = cc_month.selecteditem.text dr(31) = cc_year.selecteditem.text ds.tables("gd_user").rows.add(dr) objcmd2.update(ds,"gd_user") label1.Text= user.text end if end sub I establish the connection outside of this sub and the connection appears to be fine because I was able to write some manual inserts. Let me know. Thnaks you very much.Forget the first question - I figured it out. Which leads to a second question. The issue was with the "Password" field. Every time I include that field in the insert it breaks. I made sure the data types match. Cold the validation controls effect the insert statement?There are a number of "reserved" words in .Net and it gets very sensitive when you try to use them for something else. I have gottne the syntax error in insert statement several times and always track it down to the use of a reserved word as a field name. For example a data field named "Date" causes an error as does "Password". With so many reserved words, I finally just went to a convention where I name all my fields with a one-character prefix (ie. rDate, rPassword). It's a quick way to avoid the reserved word issue altogether. Good Luck Tom TI'm not sure if you're using Access, but it doesn't let you have a field called 'Password' John

Syntax error in INSERT INTO statement

SteamTank

New Member