Advanced Search

Using Parameterized Statements

/ Published in: ASP
Save to your folder(s)
Parameter markers are Da Bomb!

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. dim MyColumn3Value: MyColumn3Value = "something stringy"
  2. ...
  3. dim sql: sql = "select Column1, Column2 from MyFavoriteTable where Column3 = ?"
  4. set rs = connection.Execute(sql, Array(MyColumn3Value))

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.