如何在 SQL 语句中使用 ASP 变量 [英] How to use ASP variables in SQL statement

问题描述

<%
postit = request.querystring("thispost")
response.write(postit)
%> 

postit 是变量.response.write 有效，这都在下面的 SQL 语句之上.

postit is the variable. The response.write works and this is all above the SQL statement below.

这是 SQL，但是当我添加 postit 变量时，我收到以下错误消息:

This is the SQL however when I add the postit variable I get this error message:

delCmd.CommandText="DELETE * FROM post WHERE (pos_ID = postit )"

Microsoft Access Database Engine error '80040e10'
No value given for one or more required parameters. 
/student/s0190204/wip/deleterecord.asp, line 32

推荐答案

给SQL添加参数:

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

这篇关于如何在 SQL 语句中使用 ASP 变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！