ASP.NET

12-Sep-06 1:28

Hi all

I am trying to insert data in .mdb file

I have 20 fields

If i insert 6 fileds it is working

But it is not working when i try to inserting 20 fileds

It is giving this error

"Syntax error in INSERT INTO statement."

Can any one help me

asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf

Colin Angus Mackay12-Sep-06 1:51

Colin Angus Mackay

12-Sep-06 1:51

What is the code?!

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Sathesh Sakthivel12-Sep-06 2:02

Sathesh Sakthivel

12-Sep-06 2:02

Pls check the Names of the Column in the DB and Also in ur code.

With Regards

Satips

Colin Angus Mackay13-Sep-06 7:01

Colin Angus Mackay

13-Sep-06 7:01

Satips wrote:
Pls check the Names of the Column in the DB and Also in ur code.

I think you replied to the wrong person. I did not ask the original question.

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Guffa12-Sep-06 3:21

12-Sep-06 3:21

It has nothing to do with the number of fields. You have just made an error when adding the other fourteen fields.

That is about as much as anyone can say without seeing the actual code.

---
b { font-weight: normal; }

kirthikirthi12-Sep-06 19:56

12-Sep-06 19:56

Hi

Sorry all of u

Actiually i didnt post my second error

Some times It is giving "Unspicified Error" in connection.open()

Or it is giving "Syntax error in INSERT INTO statement"
And i chk the insert statement also no errors in that
Plz chk my code
MYCODE
----------

Dim sConnectionString
Dim objCmd As New System.Data.OleDb.OleDbCommand
sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Some.mdb") & ";")
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objCmd.Connection = objConn
objCmd.CommandText = "INSERT INTO Info(1,2,3,4,5,6,----------------20) values('" & 1.Text & "','" & 2.Text & "','" &

3.Text & "','" & 4.Text & "','" & 5.SelectedItem.Text & "','" & 6.SelectedItem.Text & "',--------------------- up to 20

fields)"
objCmd.Connection = objConn
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()

THX

asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf

Guffa12-Sep-06 23:00

12-Sep-06 23:00

No, that is not the code that you are using. You can not use numbers as names of objects, so it won't even compile. Also, you can not use numbers as field names in the database like that.

If you don't want to post the exact code that you are using, put together a working example that demonstrates the problem. There is no point in trying to find an error in a piece of code that is different from the code where the actual error is.

---
b { font-weight: normal; }

kirthikirthi12-Sep-06 23:25

12-Sep-06 23:25

Hi
My mean is not hide the code my fields name are to big thats y i put fields name as numbers to better understood

Plz chk this

MYCODE
---------
Dim sConnectionString
Dim objCmd As New System.Data.OleDb.OleDbCommand
sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Names.mdb") & ";")
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objCmd.Connection = objConn
objCmd.CommandText = "INSERT INTO

Info(username,userpasswd,Name,email,try,loc,other,other1,num,yearwise,monthwise,skils,funarea,current,ug,pg,greatpg,RB,ugo

ther,pgother,postother,cpr) values('" & uname.Text & "','" & pass.Text & "','" & name.Text & "','" & email.Text & "','" &

c***ry.SelectedItem.Text & "','" & loc.SelectedItem.Text & "','" & other.Text & "','" & other1.Text & "','" & no.Text & "','"

& yearwise.SelectedItem.Text & "','" & monthwise.SelectedItem.Text & "','" & skilsmen.Text & "','" & Label1.Text & "','" &

currrent.SelectedItem.Text & "','" & ugrad.SelectedItem.Text & "','" & pggrad.SelectedItem.Text & "','" &

pggreat.SelectedItem.Text & "','" & RB.SelectedItem.Text & "','" & u1.Text & "','" & p1.Text & "','" & greatpg1.Text & "','"

& cpr.Text & "')"
objCmd.Connection = objConn
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()

asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf

Guffa12-Sep-06 23:49

12-Sep-06 23:49

That's better. Smile | :)

The problem is in the information that you left out in the previous post.

"Name" is a reserved keyword in Access.
"Current" is a reserved keyword in SQL, Jet and ODBC.

---
b { font-weight: normal; }

kirthikirthi14-Sep-06 0:51

14-Sep-06 0:51

HI
I changed DB fileds still it is giving same ERROR

Plz Chk this code

MYCODE
---------

Dim sConnectionString
Dim objCmd As New System.Data.OleDb.OleDbCommand
sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("DB22.mdb") & ";")
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objCmd.Connection = objConn
objCmd.CommandText = "insert into user(uname,pass) values(" & TextBox1.Text & "," & TextBox2.Text & ")"
objCmd.Connection = objConn
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()

asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf

Guffa14-Sep-06 1:30

14-Sep-06 1:30

User is a reserved keyword.

---
b { font-weight: normal; }

kirthikirthi14-Sep-06 2:07