ÇóÒ»¸ö±à³ÌºÃ°ì·¨£¬ÈçºÎͨ¹ý²úƷСÀàÕÒµ½´óÀࣨasp£©
id lbname topid ceng
1 ²úÆ·1 0 1
16 ²úÆ·2 0 1
17 ²úÆ·3 0 1
18 ²úÆ·4 0 1
19 ²úÆ·5 0 1
20 ²úÆ·6 0 1
21 ²úÆ·7 0 1
22 ²úÆ·8 0 1
23 ²úÆ·9 0 1
24 ²úÆ·10 0 1
25 ²úÆ·11 0 1
33 ²úÆ·12 1 2
34 ²úÆ·13 1 2
35 ²úÆ·14 34 3
ÒÔÉÏÊÇÒ»¸ö±í£¬ÒÑÖªid=35£¬ÈçºÎÕÒµ½Í¨¹ýtopid=34ÕÒµ½id=1£¬Çë¸ßÊֻشð£¬Ð»Ð»
¼ÙÉè±íÃûΪa¡£
select a.id from a,
(select topid from a where id=(select topid from a where id=35)) b
where a.id=b.topid;
¿ÉÒÔÓà ¡°ÓõݹéËã·¨¡± ¿ÉÒÔÈ¥ÍøÉÏËÑËÑ¿´¿´¾ßÌåµÄ½â´ð,×£Äã³É¹¦!
·ÖÀàÓ¦¸Ã²»¶à,Éú³Éµ½Ò»¸öÊý×éÀïÃæ
È»ºóÓõݹé,²Î¿¼ÎÞÏÞ¼¶ÏÂÀ²Ëµ¥
Ïà¹ØÎÊ´ð£º
--------------------------------
id id2
1 1
2 0
3 0
---------------------------------
id Ϊ×Ô¶¯±àºÅ ......
ÎÒÓÐÒ»¸öaspÔ´Â룬µ«ÊdzöÏÖÒ»¸öÎļþ£¬ÎÒÓÃasp½âÃܶ¼ÊÇÂÒÂë
Çë½Ì
VBScript code:
??
%# , #&')*)-0-(0%()(?
(((((((((((((((((((((((((( ......
----´íÎóÌáʾ--------------
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80004005'
»ùÓÚ²éѯµÄ¸üÐÂʧ°Ü£¬ÒòΪû·¢ÏÖÒª¸üеÄÐС£
/admin/inboundSQL.asp£¬ÐÐ 406
-- ......
Ô´ÂëÒªÊÇASPµÄ£»¿ÉÒÔÁгöÎļþÏÂÔØ¾Í¿ÉÒÔÁË
¿ÉÒÔÏñ×ÊÔ´¹ÜÀíÆ÷½çÃæµÄÑù¡£
ÄÇЩaspľÂí¾ÍÊÇÕâ¸öÍæÒâ
¶÷ ²î²»¶à°É ¾ÍÊÇҪûÓÐÐÞ¸ÄȨÏ޵İ¡
ûÓÐÐÞ¸ÄȨÏÞ .¿ÉÒÔÔÚ·þÎñÆ÷ÉÏÉèÖÃ.
ÎÒÊÇÂòµÄ¿Õ¼ä ÓÐ×Ô¼ºµÄÓòÃû Ö ......
<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......