错误类型：Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

来源：百度知道 编辑：UC知道 时间：2024/05/28 19:02:53
请高人指点

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'sumvalue'.
/ceshi/atmo/jszx.asp, 第 567 行

代码如下:

sql="select discount_value from shop_discount where discount_begin_value<"&sumvalue&" and discount_end_value>="&sumvalue

'response.write ("<hr>")
'response.write sql
set myrs=server.CreateObject("adodb.recordset")
myrs.open sql,conn,3,3
if not myrs.bof and not myrs.eof then
discount_value=myrs("discount_value")
end if
'response.write ("<hr>

sql="select discount_value from shop_discount where discount_begin_value< " & sumvalue & " and discount_end_value >= " & sumvalue

这样就行了.你没有注意空格.

sql="select discount_value from shop_discount where discount_begin_value<'"&sumvalue&"' and discount_end_value>='"&sumvalue&"'

想不通啊,为什么后面那个 变量你只加了 "&

后面要加完