½ô¼±ÇóÖú£¡£¡Ò»¸öaccess ²»Ö§³Öin µÄÎÊÌâ

VB code:

if request("tpid")<>"" then
Sql="select * from [product] where typeid="&request("tpid")&" order by news_time desc"
else
set rsc=server.CreateObject("adodb.recordset")
sqlc="select id from [class] where resideid="&request("typeid")&" "
rsc.open sqlc,conn
sql="select * from news where typeid in ("&rsc("id")&") order by news_time desc"
end if

'»òÕß×îºóÒ»¾äÖ±½Óд³É
sql="select * from news where typeid in £¨select id from [class] where resideid="&request("typeid")& ") order by news_time desc"
'ÕâÑùÒ²²»Ðа¡



ÎÒµÄÊý¾Ý¿âÊÇaccess  ²»Ö§³Ö in Ôõô´¦ÀíºÃÄØ Ð»Ð»£¡£¡Âé·³°ïÎÒ¿´¿´ÉÏÃæµÄ ´úÂë ÎÒÓ¦¸ÃÔõô´¦Àí£¡£¡

---

ÄÄÀïÓпոñ°¡ £¿

---

ÄÇÎÒµÄÓï¾ä Ϊʲô²»ºÃʹÄØ ÇëÎÊÄÄÀïÓдíÎóÄØ Ð»Ð»ÁË £¡£¡

---

ºÇºÇ ¿´³öÀ´ÁË ²»ºÃÒâ˼ÁË ºÇºÇ ÎÒ±íÃûд´íÁË Ð»Ð»ÁË ¸÷λ