求助一个简单的ASP问题，在一个表里得到一个产品brand_id去另外一个表brand里想读它的名称，可是却读不出来

[大刘_南京]

id=cint(request.QueryString("shop_id"))
if id<>"" then
Set res=Server.CreateObject("ADODB.RecordSet")
sql="select * from product where shop_id="&id
res.open sql,con,3,3

myBrandId=Cint(res("brand_id"))

set res1=Server.CreateObject("ADODB.RecordSet")
sql="select * from class where sort_id="&myBrandId
res1.open sql,conn,1,1
if res1.eof and res1.bof then
getBrandName="no brand"
else
getBrandName=res1("brand_name")
end if
res1.close
set res1=nothing


myBandName=getBrandName
getBrandName得不到结果，请高手指点，谢谢！

[king_shadow]

id=cint(request.QueryString("shop_id"))
if id<>"" then
Set res=Server.CreateObject("ADODB.RecordSet")
sql="select * from product where shop_id="&id
res.open sql,con,3,3

myBrandId=Cint(res("brand_id"))

set res1=Server.CreateObject("ADODB.RecordSet")
sql="select * from [class] where sort_id="&myBrandId
res1.open sql,conn,1,1
if res1.eof and res1.bof then
getBrandName="no brand"
else
getBrandName=res1("brand_name")
end if
res1.close
set res1=nothing


myBandName=getBrandName

[kakimsun]

UP！

[lonaerd]

set res1=Server.CreateObject("ADODB.RecordSet")
sql="select * from class where sort_id in (select brand_idfrom product where shop_id="&id &")"

res1.open sql,conn,1,1

一个select语句就可以了

[lonaerd]

sql="select * from class where sort_id in (select brand_id from product where shop_id="&id &")"
少个空格

[dcyuan480]

你class表中的sort_id为myBrandId 对应的记录中brand_name项在数据库中有值吗?是否为空?

或者你应该在
Set res=Server.CreateObject("ADODB.RecordSet")
sql="select * from product where shop_id="&id
res.open sql,con,3,3
后加一个判断res是否为空的判断

[大刘_南京]

回2楼 king_shadow(天才混混)
class改成正确的brand也不行

res肯定不为空的