How to use ASP variables in SQL statement

by

Add a parameter to the SQL:

delCmd.CommandText="DELETE * FROM post WHERE (pos_ID = ?)"
delCmd.Parameters.Append delCmd.CreateParameter("posid", adInteger, adParamInput)   ' input parameter
delCmd.Parameters("posid").Value = postit

More Related Contents:

  1. Convert UTF-8 String Classic ASP to SQL Database
  2. Using Stored Procedure in Classical ASP .. execute and get results
  3. SQL insert into database with apostrophe
  4. How to make a parametrized SQL Query on Classic ASP?
  5. operation not allowed when the object is closed when running more advanced query
  6. Error trying to call stored procedure with prepared statement
  7. Making a query with a single row out
  8. Using group by on multiple columns
  9. Passing an array of parameters to a stored procedure
  10. SQL Server : GROUP BY clause to get comma-separated values [duplicate]
  11. Return multiple columns of the same row as JSON array of objects
  12. How to update Identity Column in SQL Server?
  13. How to log SQL statements in Grails
  14. Is there common street addresses database design for all addresses of the world? [closed]
  15. SQL Between clause with strings columns
  16. Selecting the second row of a table using rownum
  17. Does Oracle store trailing zeroes for Number data type?
  18. Why can’t I use column aliases in the next SELECT expression?
  19. SQL: getting the max value of one column and the corresponding other columns [duplicate]
  20. Does an empty SQL table have a superkey? Does every SQL table have one?
  21. How to delete in MS Access when using JOIN’s?
  22. SQLite3 UNIQUE constraint failed error
  23. How to count in SQL all fields with null values in one record?
  24. Repeat Rows N Times According to Column Value
  25. How to change column order in a table using sql query in sql server 2005?
  26. Getting results between two dates in PostgreSQL
  27. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  28. INNER JOIN vs multiple table names in “FROM” [duplicate]
  29. sql swap primary key values
  30. DataReader.GetString() via columnname

Leave a Comment