帮忙！sql语句

[IpConFigYYK]

sql = "select lei from car where lei = "&carlei&""
rs.open sql,conn,1,3
if rs.eof then

执行到rs.open sql,conn,1,3就报错！
提示：Microsoft JET Database Engine 错误 '80040e10'

至少一个参数没有被指定值。

[萝卜波]

'加上"'"
sql = "select lei from car where lei = '"&carlei&"'"

[stefli]

carlei是字符型，还是数字型啊。
如果是数字的话，就这样了。
如果是字符的话，那得加上单引号哦
sql = "select lei from car where lei='"&carlei&"'"

[ChianEagle]

你看看我的

<%
Set adoCon = Server.CreateObject("ADODB.Connection")

' 数据库连接信息及驱动
strcon = "driver={sql server};SERVER=MYJ;database=JOB;UID=sa;PWD=;"


' 设置活动连接连接到连接对象
adoCon.Open strCon
%>
<%
adocon.CursorLocation=3
Set MM_rs = Server.CreateObject("ADODB.Recordset")

strSQL = "SELECT * FROM BASEDATA ORDER BY BASENO"
MM_rs.Open strSQL, adoCon,adOpenStatic

[angelheavens]

如果lei是数值型则是
sql = "select lei from car where lei ="&carlei
rs.open sql,conn,1,1
if rs.eof then
如果lei是字符型则是
sql = "select lei from car where lei ='"&carlei&"'"

[IpConFigYYK]

谢谢了！我的问题解决了！！

[say1no2]

如果是字符型的要加上单引号，就像上面说的那样！

[bananasmiling]

问题解决快结贴!