关于数据库搜索问题………………

[Coverboy_6]

我要在数据库中三大类别的信息分三类别显示，请问以下写法有问题没有？
………………
vhot=Request.QueryString("hot")
fp_sql1="SELECT * FROM product WHERE (kind='"1"'and"
if (vhot="")then
fp_sql1=fp_sql1+"(id=id)"
else
fp_sql1=fp_sql1+"(hot='"&vhot&"')"
end if
fp_sql1=fp_sql1+") ORDER BY CODE ASC"

fp_sql2="SELECT * FROM product WHERE (kind='"2"'and"
if (vhot="")then
fp_sq2l=fp_sql2+"(id=id)"
else
fp_sql2=fp_sql2+"(hot='"&vhot&"')"
end if
fp_sql2=fp_sql2+") ORDER BY CODE ASC"

fp_sql3="SELECT * FROM product WHERE (kind='"3"'and"
if (vhot="")then
fp_sql3=fp_sql3+"(id=id)"
else
fp_sql3=fp_sql3+"(hot='"&vhot&"')"
end if
fp_sql3=fp_sql3+") ORDER BY CODE ASC"

response.write(fp_sql)


'主要是这三句话是否写的正确啊？
set rs1=Application("mconn").Execute(fp_sql1)
set rs2=Application("mconn").Execute(fp_sql2)
set rs3=Application("mconn").Execute(fp_sql3)

[Coverboy_6]

怎么没有人回答我啊？？？

[逍遥小贼]

fp_sql1="SELECT * FROM product WHERE (kind='1'and"
* 这个是字符串常量吧，那就直接用''引起来

[Coverboy_6]

'主要是这三句话是否写的正确啊？
set rs1=Application("mconn").Execute(fp_sql1)
set rs2=Application("mconn").Execute(fp_sql2)
set rs3=Application("mconn").Execute(fp_sql3)

是否要写成
set rs1=Application("mconn1").Execute(fp_sql1)
set rs2=Application("mconn2").Execute(fp_sql2)
set rs3=Application("mconn3").Execute(fp_sql3)