经验是总结的吗???

[feifeiyaqi]

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

[bzscs]

Request("ID")可能为空值，造成出错