Sql insert statement

<i><b>Originally posted by : Prakash (bhanu@ccmb.ap.nic.in)</b></i><br />How to pass text values in INSERT statement to insert in to a table. I made use of following sql statement. <br />It is giving error.<br /><br />Con=server.createobject("ADODB.CONNECTION")<br />Con.open("dsn name here")<br />Con.execute " insert into tablename(feild1,field2) values ("text1","text2") ")<br /><br />I tried other way also<br />Sql= "Insert into tablename(feild1,field2)"<br />Sql=sql&"values('"&variable1 &" ' "<br />Sql=sql &" ' " &variable2 & " ' )"<br />Con.execute (s)<br /><br /><br />What might be the problem. If any body could help I will be thank full to them.<br /><br />

<i><b>Originally posted by : Patrick (patrick@patrickqg.com)</b></i><br />The SQL command is usually:<br /> INSERT INTO tablename values (field1, field2).<br /><br />But, see http://w3.one.net/~jhoffman/sqltut.htm#Adding_Data<br /><br /><br />------------<br />Prakash at 5/8/2000 6:32:57 AM<br /><br />How to pass text values in INSERT statement to insert in to a table. I made use of following sql statement. <br />It is giving error.<br /><br />Con=server.createobject("ADODB.CONNECTION")<br />Con.open("dsn name here")<br />Con.execute " insert into tablename(feild1,field2) values ("text1","text2") ")<br /><br />I tried other way also<br />Sql= "Insert into tablename(feild1,field2)"<br />Sql=sql&"values('"&variable1 &" ' "<br />Sql=sql &" ' " &variable2 & " ' )"<br />Con.execute (s)<br /><br /><br />What might be the problem. If any body could help I will be thank full to them.<br /><br />