Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASPÄ£ºý²éѯÎÞЧ,ѰÇó½â¾ö°ì·¨

asp+access,asp.netƽ̨,
¾ÍÕâÑùµÄ²éѯÓï¾ä,Ô­À´ÊÇ¿ÉÒÔÓõÄ,ºóÀ´ÖÐÁËľÂí,Çå³ýľÂíÖ®ºó,²éѯÓï¾ä³öÁËÎÊÌâ,

select * from job_c_hire where hire_place like '%ÎÄ%'
select * from job_c_hire where hire_place like '*ÎÄ*'

¾ÍÊÇÕâÑùµÄÒ»¾ä²éѯÓï¾ä,ÉÏÃæÕâÑùµÄд·¨¶¼µÃ²»³ö½á¹û,

д³É

select * from job_c_hire where hire_place like 'ÎÄÔ±'
ºÍ
select * from job_c_hire where hire_place like 'ÎÄ_'
¶¼¿ÉÒԲ鵽½á¹û,


²»ÖªÊÇʲôԭÒò¡£ÇëÏþµÃµÄÅóÓѸæÖ®¡£
ÕâÑùÊÔÊÔ
str="select * from job_c_hire where hire_place like'"&"%"&ss&"%"&"'"

Ò»Ñù²»Ðа¡£¬

ÎÒÏëÕâ¸öÎÊÌâ²»ÊdzöÔÚÓï¾äÉÏ£¬ºÜ¿ÉÄܳöÔÚÊý¾Ý¿âÓëADOÉÏ£¬µ«ÎÒÕÒ²»³öÔ­Òò¡£

select * from job_c_hire where hire_place like '*ÎÄ*'
Äã°ÑÕâ¾ä·Åµ½AccessÀïÃæÖ´ÐÐһϣ¬¿´¿´ÓÐûÓнá¹û£¡

Èç¹ûÉÏÃæÄܳö½á¹û£¬ÄÇôÏÂÃæÕâ¾äÔÚASPÀïÃæ¾ÍÓ¦¸ÃûÎÊÌâ
select * from job_c_hire where hire_place like '%ÎÄ%'


select * from job_c_hire where hire_place like '%ÎÄ%'

Õâ¾ä»°ÎÒÔÚACCESSÖÐÖ´ÐУ¬¿ÉÒԵõ½½á¹û£¬µ«·Åµ½ASP»·¾³ÖоͲ»ÐС£

Õâ¸öÎÊÌâÓ¦¸Ã²»ÊÇÓï¾äÉϵÄÎÊÌ⣬ºÜ¿ÉÄÜÊdzöÔÚÊý¾Ý¿âÓëADO»òƽ̨ÉÏ¡£

¿ì·Å¼ÙÁË»¹Ã»ÕÒµ½´ð°¸Ñ½¡£

ÊDz»ÊÇÄÇľÂí¼ÓÁËʲô¹ýÂ˵Ķ«Î÷,¹ýÂËÁË"*,%"

³¤¼Ù»ØÀ´ÁË£¬Ï£ÍûÖªµÀµÄ¸æËßÎÒ°¡£¬

ÖÐľÂíÒÔºóÄã×ö¹ýʲô


Ïà¹ØÎÊ´ð£º

Ò»¶Îaspתphp

<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......

ÎÒÏë×öÒ»¸öaspÍøÕ¾£¬µ«ÊDz»ÖªµÀ×öʲô£¡

×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......

ASPα¾²Ì¬µÄÁíÀàÎÊÌâ

ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬
²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£
Ö÷Òª´úÂëÈçÏ£º
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]

³ÌÐò´úÂë
AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý
<a href=&q ......

aspÉý¼¶µ½asp.net£¬ºÃ¶à½á¹¹¶¼²»ÖªµÀÈçºÎת»»

aspÏÂÃæ£¬µ±Òª¸ù¾Ý²»Í¬µÄȨÏÞÏÔʾһЩ¹¦Äܰ´Å¥µÄ»°»áд³É
<%
if ȨÏÞ=1 then
%>
<input type="submit" name="Submit" value="Ìá½»" />
<%
end i ......

aspÔõÑùʵÏÖ¸ÊÌØÍ¼µÄЧ¹û£¿ - Web ¿ª·¢ / ASP

ÓÐË­Äܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿

½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ

ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ