
April 25th, 2003, 12:51 PM
|
|
Registered User
|
|
Join Date: Apr 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
unable to insert into the database
hi all,<br><br>i created a table. <br><br>example : test<br><br>fieldnames are : col1 , col2 , col3?<br><br>when i am going to insert into the col3? i am getting error. is beacause of the ? in fieldname.<br><br>if there is a ? in field name , what is method ?<br><br><br>Dim objDB<br>Dim objRS<br>Dim sDBName<br>sDBName = "driver={Microsoft Access Driver (*.mdb)};dbq=e:example.mdb"<br>Set objDB = Server.CreateObject("ADODB.Connection")<br>objDB.Open sDBName<br><br>Set objRS = objDB.Execute("insert into test(col1,col2,col3?) values('" & a & "','" & b & "','" & c & "')")<br><br>it is working with first two field names. i am getting error with 3rd field name because of ? in the field name (i think) what is the solution?
|