Çë½Ì¸öÎÊÌ⣬aspÖйØÓÚsql²éѯÓï¾ä×éºÏ×Ö·û´®

ÌìÓïÓÆÓÆ

<%     
         set cmd=server.CreateObject("adodb.command")
         cmd.activeconnection=cn
      *  cmd.commandtext="select brand,model,description,prise from tb1+hardware_name"  *
   set rs=cmd.execute
      
    %>     

´òÐǺÅÄÚ¾äÀïhardware_nameÊÇÒ»¸ö±äÁ¿£¬ËüºÍtb1×é³ÉÎÒÊý¾Ý¿âÖеıíÃû£¬Ëüͨ¹ýÓû§ÊäÈëµÃµ½Öµ£¬µ«ÊÇÎÒÓ¦¸ÃÔõôд²Å¿ÉÒÔ£¿ÎҵıíÃû×Ö¶¼ÊÇÒÔtb1¿ªÍ·µÄ£¿

ûÐÄû·Î

ûÈËÖªµÀô£¬×Ô¼º¶¥¡£

©»°×Ó^à³

¶¥4Â¥

¤Ñ¥Û

set cmd=server.CreateObject("adodb.command")
         cmd.activeconnection=cn
tab="tb1"&hardware_name
      cmd.commandtext="select brand,model,description,prise from " &tab
   set rs=cmd.execute

°®Ç麣555

±äÁ¿¾Í·ÅÔÚ×Ö·û´®(¼´Ë«ÒýºÅÍâÃæ)
"select brand,model,description,prise from tb1" & hardware_name