SQL parametized insert

Question

Could someone help me with the syntax preferably jScript for inserting data into DB table using parameters.i am getting an error with the parameters ThanksFunction&nbsp;InsertToDb(var1 ,var2)&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var Qry;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qry = ADO.CreateADOQuery();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var conStr = "Provider=*****.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=####;Data Source=&nbsp;&nbsp; ####";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qry.ConnectionString = conStr;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qry.SQL = "INSERT INTO example (column1,column2) VALUES &gt;= :var1,:var2 ";&nbsp; //&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qry.Parameters.ParamByName("column1").Value = var1;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qry.Parameters.ParamByName("column2").Value = var2;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qry.ExecSQL();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; catch(e )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log.Error(e.description);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qry.Close();&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;

tristaanogre · Answer

What's the error you're getting? &nbsp;

raskenny · Answer

&nbsp;&nbsp;i get error " Parameter var1 not found "&nbsp; All i want to do is insert&nbsp;whatever paameters passed to the method into the database i just cant figure outh the syntax&nbsp;for the insert statement.selection statements work fine for me&nbsp;using parameters but not insertThanks&nbsp;

tristaanogre · Answer

I don't think you need to worry about using parameters on the query itself... you can do it simply with concatenated strings like so...function InsertToDb(var1 ,var2){ &nbsp;&nbsp; &nbsp; var Qry;&nbsp; &nbsp; Qry = ADO.CreateADOQuery();&nbsp; &nbsp; var conStr = SQLUtilities.ConnectionString;&nbsp;&nbsp; &nbsp; Qry.ConnectionString = conStr;&nbsp; &nbsp; try &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; { &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Qry.SQL = "INSERT INTO example (column1,column2) VALUES (\'" + var1 + "\',\'" + var2 +"\')"&nbsp; &nbsp; &nbsp; &nbsp; Qry.ExecSQL();&nbsp; &nbsp; }&nbsp; &nbsp; catch(e )&nbsp;&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; Log.Error(e.description); &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; } &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; Qry.Close(); &nbsp;&nbsp;}Note that, in my example, I'm assuming Var1 and Var2 are strings so I needed to include the "\'" special character in order to designate the string identifiers.

raskenny · Answer

I am callinng the method InsertToDB("test","test2"); //passed as strings i get an error&nbsp; Incorrect syntax near 's (Column1,Column2) VALUES ( '

tristaanogre · Answer

Paste in what you have because I did pretty much your exact same test and it worked fine... &nbsp;Would like to see if, perhaps, you're missing something.

Forum Discussion

SQL parametized insert

6 Replies

Related Content

SQL insert with JScript arrays and adodb

How to Execute SQL Stored Procedure with Parameters on TestComplete

Error java.lang.IllegalArgumentException: Parameter 'name' was not found in the SQL Query

How to execute a SQL query which includes temp table ( creates and inserts ) - JDBC Step

soapui parameter equivalent to curl parameter

Recent Discussions

Access a child in a tree Structure through Keyword Strokes

Turn off all Edge messageboxes

How to verify data from another application, the data which keeps changing

Audit and Reporting purposes

Textbox values disappear after adding Year value from Date Picker