经验是总结的吗???
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '<'.
/EBusiness/visit/ViewDetail.asp,行21 问题::::
行21就是:
(1.)SQLQuery="Select * From [Goods] Where ID="&ID怎么改就对了?
(2.)Set Rs=DataCon.Execute (SQLQuery)这句错可能是
SQLQuery="Select * From [Goods] Where ID="&ID句中ID的数据类型为
CREATE TABLE [dbo].[GOODS] (
[ID] [int] NOT NULL )
如果ID的数据类型为:varchar了这句变成SQLQuery="Select * From [Goods] Where ID="&ID&""在测试是正解的,
如果变成SQLQuery="Select * From [Goods] Where ID= '"&ID&"'"测试就错了,请问为什么?
(3.)id的数据类型是int还是varchar,请问原因是?
-----------------------------------
Set DataCon=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.Recordset")
Set RsType=Server.CreateObject("ADODB.Recordset")
Set RsSubType=Server.CreateObject("ADODB.Recordset")
DataCon.ConnectionTimeout=20
DataCon.Open "DSN=Ebusiness","Administrators","19761105"
ID=Request("ID")
SQLQuery="Select * From [Goods] Where ID="&ID
Set Rs=DataCon.Execute (SQLQuery)
If Rs.EOF Then
ReturnErrorPage wsecWrongGoodsID
End If