奇怪的错误信息
报错信息:ADODB.Recordset 错误 '800a0cc1'在对应所需名称或序数的集合中,未找到项目。
<%
set rs = Server.CreateObject("ADODB.Recordset")
sql = "Select * from kcorder,kc Where khqr = True and 始发地 = '北京市' and 始发市 = '北京辖区' and sfqx = '东城区' and kcid = kc.id Order By kcorder.id Desc"
rs.Open sql,Conn,1,1
do while not rs.eof
response.Write(rs("kcorder.id")&"<br>")
rs.movenext
loop
%>
表结构:
kcorder
-----------
id
kcid
hwname
hwzl
hwbz
bz
name
phone
qq
post
mobile
fax
address
email
web
addtime
ddnum
userid
dj
ckyj
dwyj
khqr
bzj
fc
zh
fctime
zhtime
khqrtime
-----------
kc
-----------
id
title
kcnum
kclen
kczz
kcstyle
始发地
始发市
sfqx
目的地
目的市
mdqx
yxq
bz
name
phone
qq
post
mobile
fax
address
email
web
time
sh
tj
ip
hits
userid
lx
syr
fdjh
cjh
---------