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»ÊÇÄÇľÂí¼ÓÁËʲô¹ýÂ˵Ķ«Î÷,¹ýÂËÁË"*,%"
³¤¼Ù»ØÀ´ÁË£¬Ï£ÍûÖªµÀµÄ¸æËßÎÒ°¡£¬
ÖÐľÂíÒÔºóÄã×ö¹ýʲô
Ïà¹ØÎÊ´ð£º
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
ÎÒµÄ網頁´ú碼為ASP語ÑÔ,驗證·½Ê½為ϵ統×Ô帶µÄWINDOW驗證ģʽ.
現ÔÚÎÒÈç¹ûÒªÔÚASP´ú碼ÖÐ獲È¡當ǰµÄµÇÈëÈË ......
ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬
²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£
Ö÷Òª´úÂëÈçÏ£º
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]
³ÌÐò´úÂë
AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý
<a href=&q ......
owc11Âú×ã²»ÁËÒªÇó£¬ÓÐûÓиüºÃµãµÄ£¬aspÄܵ÷ÓõÄ
Ŀǰû·¢ÏÖ£¬°ïÄã¶¥£¡
Ó¦¸ÃûÓÐÁ˰É
×ÔÒÑд¡£¶¥
°ï¶¥£¬¹Ø×¢£¡
ºÃÏñ¾ÍÕâ¸öÁË£¬Ä¿Ç°»¹Ã»¿´µ½ÆäËûµÃÉÏÊÐʹÓᣡ£¡£°ï¶¥£¡
×Ô¼ºÔÙ¶¥Ò»ÏÂ
ºÃÏñÊÇûÓÐ ......