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 ÊÇ·ñÓнá¹û£¿ Êý¾Ý¿âÀïÃæûÓÐÎÊÌâ ¾Í ²»»áÓÐʲôÎÊÌâ
Ïà¹ØÎÊ´ð£º
ÐèÇóÈçÏ£º ѧԺ 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 ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøվͼƬ¶¼Õ¼ÓÃÁËÒ»´ó°ë ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂ𣿠Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵ 3Q´ó¼Ò htmlÒ³Ãæ. Õâ¸ö,¼ÈÈ»Ö÷Ò ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔضԻ°¿ò£¿ PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿ Response.Redirect("test.jpg") ÒýÓà Response.Redirect( ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......