asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP
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Õ¾Àï ±¾ÉíÓÐÊý¾Ý µ«ÊÇ»¹ÊÇËÑË÷²»µ½
ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ £ºselect * from guide where city_name='±±¾©' order by pai descÊÇ·ñÓнá¹û£¿ ±±¾©ÊÇÄã´«µÝµÄ²ÎÊý£¿»¹ÊÇÖ±½Ó¾ÍÄÇÑùдµÄ£¿£¿ÒýÓà ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ £ºselect * from guide where city_name='±±¾©' order by pai descÊÇ·ñÓнá¹û£¿ ±±¾©ÊÇÄã´«µÝµÄ²ÎÊý£¿»¹ÊÇÖ±½Ó¾ÍÄÇÑùдµÄ£¿£¿ ÎÒÕâ¿ìÊÇ»ñÈ¡µÄÖµ ×Ö¶ÎÀï¿Ï¶¨Óб±¾© ¶øÇҺü¸Ìõ µ«¾ÍÊDz»ÏÔʾ³öÀ´ µ«ÊÇÈç¹ûÎÒ°ÑÓï¾ä¸Ä³É select * from guide where id>2500 order by pai desc ¾ÍÄÜÑ»·do while Óï¾äÁË ÔÚÊý¾Ý¿âÀïÃæÖ±½ÓÔËÐÐ select * from guide where city_name='±±¾©' order by pai desc ÊÇ·ñÓнá¹û£¿ Êý¾Ý¿âÀïÃæÃ»ÓÐÎÊÌâ ¾Í ²»»áÓÐʲôÎÊÌâ
Ïà¹ØÎÊ´ð£º
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server) µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......