ASPÑ»¯¶ÁÈ¡ÐÔÄÜÇë½Ì£¡ - Web ¿ª·¢ / ASP
sql="xxxxxxx" rs.open sql conn,1,1 Do while not rs.eof ID=¶ÁÈ¡µÄid ÏÂÃæÔÙ¸ù¾Ý¶ÁÈ¡µÄÕâ¸öID.µ÷ÓñðµÄ¸ö±íÄÚÈݵÄʱºò£¬¾ÍÑÏÖØÓ°ÏìÁ˶ÁÈ¡ËÙ¶È Response.write aaaaa(ID) rs.movenext Loop Function aaaaa(str) set rss=Server.CreateObject("adodb.recordset") sql = "Select Áбí from ±í where ID="&str&" order by idd asc" rss.Open sql, Conn, 1, 1 If Not(rss.bof And rss.eof) Then cc="dddddddddddddddddddddd" End if:rss=nothing aaaaa=cc End Function Çë¸ßÊÖÖ¸µãһϣ¬Èç¹û²»Ó°ÏìËÙ¶È
ÄãÕâ2¸öID¹ØÁªÆðÀ´£¬ÓÃ1¸öSELECT²éѯ³öÀ´£¬ È»ºó·Åµ½Êý×éÀȻºóÔÙÏëÔõô¸ã¾ÍÔõô¸ã ×¢Òâ±íÖÐÊÇ·ñÓб¸×¢×ֶΣ¬²»¹ÜÀïÃæÓÐûÓж«Î÷£¬ÔÚÒ»¸öÒ³Ãæµ÷ÓÃÒ»¸öÒÔÉϵı¸×¢×ֶζ¼»áÑÏÖØÓ°ÏìËÙ¶ÈÒýÓà ÄãÕâ2¸öID¹ØÁªÆðÀ´£¬ÓÃ1¸öSELECT²éѯ³öÀ´£¬ È»ºó·Åµ½Êý×éÀȻºóÔÙÏëÔõô¸ã¾ÍÔõô¸ã ·ÖÀà±í¡£ÄÚÈÝ±í¡£ µØÖ·±í ÏÖÔÚ¶ÁÈ¡·ÖÀ࣬ÒѾ°ÑclassidºÍÄÚÈݱíµÄ·ÖÀàID¹ØÁªÁË ÓÃÁËinner join µ«µØÖ·±í£¬»¹Òª¶ÁÈ¡ÄÚÈݱíµÄIDÔÙ¶ÁÈ¡µØÖ·£¬ Ö»ÄÜÑ»·¶ÁÈ¡³öÄÚÈݱíµÄIDºó£¬²ÅÄܸù¾ÝID¶ÁÈ¡µØÖ·±íµÄÄÚÈݰ¡£¬ Èç¹ûÈý¸ö±í¶¼¹ØÁª£¬»¹²»»á£¬Âé·³Ö¸µãһϠ¸ø³öÏêϸ´úÂë±í½á¹¹£¬Çë¸÷λ´ó¸ç°ï·ÖÎöһϣ¬Èç¹û²ÅÄܲ»Ó°ÏìËÙ¶È£¡ <% Sql = "select B.ÄÚÈݱíID,B.·ÖÀàµÄID,B.ÄÚÈݱêÌâ, from ·ÖÀà±í a inner join ÄÚÈݱí b on a.·ÖÀàID=b.·ÖÀàID where
Ïà¹ØÎÊ´ð£º
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£ ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£ ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£ ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡ ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º sql×¢Èë©¶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´ ³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿ ×¢Èë©¶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹ ±©¿â©¶´Ôõô·ÀÖ¹ »¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif ÕâÖÖ©¶´Ôõôȥ± ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server) µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
SQL code: rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1 do while not rs.eof or rs.bof ¡£¡£ ¡£¡£ ¡£¡£ rs.movenext loop Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......