How to make a parametrized SQL Query on Classic ASP?

by

Use the adodb.command object.

with createobject("adodb.command")
    .activeConnection = application("connectionstring")
    .commandText = "select * from sometable where id=?"
    set rs = .execute( ,array(123))
end with

I would also advise to use a custom db access object instead of using adodb directly. This allows you to build a nicer api, improves testability and add hooks for debuging/logging/profiling. Secondly you can add request scoped transactions with implicit rollback’s on errors using the class_terminiate event. Oure db access object offers the following query api 

call db.execute("update some_table set column=? where id=?", array(value, id))
set rs = db.fetch_rs("select * from some_table where id=?", array(id))
count = db.fetch_scalar("select count(*) from some_table where column > ?", array(value))

More Related Contents:

  1. Error trying to call stored procedure with prepared statement
  2. Convert UTF-8 String Classic ASP to SQL Database
  3. Using Stored Procedure in Classical ASP .. execute and get results
  4. How to use ASP variables in SQL statement
  5. SQL insert into database with apostrophe
  6. Rowset does not support scrolling backward
  7. operation not allowed when the object is closed when running more advanced query
  8. How to delete the records by using SQL [closed]
  9. How do I obtain a Query Execution Plan in SQL Server?
  10. Left Join With Where Clause
  11. What is the string concatenation operator in Oracle?
  12. How can I introduce multiple conditions in LIKE operator?
  13. SQL Server: Make all UPPER case to Proper Case/Title Case
  14. What is a ‘multi-part identifier’ and why can’t it be bound?
  15. Using sql function generate_series() in redshift
  16. How to make SQL many-to-many same-type relationship table
  17. Relational database design question – Surrogate-key or Natural-key?
  18. CASE WHEN statement for ORDER BY clause
  19. formula for computed column based on different table’s column
  20. How does this CASE expression reach the ELSE clause?
  21. Automate Version number Retrieval from .Dtsx files
  22. SQL Command not properly ended?
  23. Calculate working hours between 2 dates in PostgreSQL
  24. Passing Parameters to a Stored Procedure using ASP
  25. How to measure the execution time of a query on Spark
  26. How do you copy a record in a SQL table but swap out the unique id of the new row?
  27. Using IF ELSE statement based on Count to execute different Insert statements
  28. Distributed transaction error?
  29. Determine what user created objects in SQL Server
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment