sql语句的结果集的再用

[lxw81p]

<%set rs=conn.execute("select * from pic where id="&id&"")%>

<%
set ty=rs("type")
sql3="select * from pic where type='ty' "
set rs3=conn.execute(sql3)
%>

表里有相应的值.下面的语句错在哪里?

应该怎样改?

[lxw81p]

调试成功立即给分!!!

[lxw81p]

shit..我想问题已经解决!

[jzywh]

sql3="select * from pic where type='" & type & "' "

[lxw81p]

还是不行!

[mjpclab]

<%set rs=conn.execute("select * from pic where id="&id&")%> --你这里干吗加2个引号？

sql3="select * from pic where type='" & type & "'"

[mjpclab]

<%set rs=conn.execute("select * from pic where id="&id)%>

<%
ty=rs("type") '不要set
sql3="select * from pic where type='" & type & "'"
set rs3=conn.execute(sql3)
%>

[zhutimy]

sql3="select * from pic where type='"&ty&"'"

[lxw81p]

错误类型：
ADODB.Field (0x80020009)
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录

--仍然是一个空的结果集,可是数据库里有这个值

[lxw81p]

还是没有成功

[lxw81p]

<%
rs.close
set rs=nothing
%>
<%
rs3.close
set rs3=nothing
%>

我是放在最尾部

[jzywh]

respinse.write sql3

[jzywh]

response.write sql3

[poron9]

<%
set rs=conn.execute("select * from pic where id="&id&"")
set ty=rs("type")
sql3="select * from pic where [type]='"&ty&"'"
set rs3=conn.execute(sql3)
%>

[lxw81p]

请问楼上,这个[]在这里有什么意思?谢谢

[fogheart]

<%
set rs=conn.execute("select * from pic where id="&id&"")
if not rs.eof then
ty=rs("type")
else
ty = ""
end if
sql3="select * from pic where type='"&ty&"'"
set rs3=conn.execute(sql3)
%>

[winstarr]

<%
set rs=conn.execute("select * from pic where id="&id&"")
ty=rs("type")
sql3="select * from pic where type='"&ty&"'"
set rs3=conn.execute(sql3)
%>