AccessÊýÖµÐÍ×Ö¶ÎÄ£ºý²éѯµÄÎÊÌâ
sql="select * from house where fw_mc like '%12|13|14%'"
fw_mcÊÇÒ»¸öÊýÖµÐÍ×Ö¶Î,ÕâÑùдµÄ»°²»ÐÐ..
ÓÐת»»Ò²Ã»³É¹¦..
¸÷λÓк÷½·¨¸æËßÎÒÒ»ÏÂ..
fw_mc´æ´¢µÄÊý¾ÝÊÇʲôÑù×ӵģ¿
Õâô¿ì°¡....
fw_mc ÀïµÄÊý¾Ý±ÈÈç:4 , 5 ,6 ....12,13ÕâÑùµÄ.
ÎÒÊÔÒ»ÏÂ
ÒѾ¸ã¶¨ÁË¡£Ð»Ð»ÁË¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
ÍøÉÏÕÒµ½µÄ¶¼ÊÇasp.net
ÓÐûÓÐaspµÄµ¼Èëµ¼³öÍêÕû´úÂë
ÒýÓÃ
CSDNÉÏÄãËÑËÑ ¾ÍÓкܶà Õâ¸öÊǵ¼³öhttp://topic.csdn.net/u/20100104/10/fd959988-1ea6-46eb-9fe3-c4fe0e5ba234.html?8966
²»ÊÇµÄ ÎÒÏÖÔÚÄܵ¼ÈëºÍµ¼³ ......
ÎÒ²éѯaccess£¨97£©µÄʱºòÀÏÊÇÌáʾ²ÎÊý²»×㣬µ«ÊÇÎÒÔÚaccess²éѯÕâÌõÓï¾äÊÇûÓдíÎóµÄ¡£ÊÇÔõô»ØÊÂÄØ£¿
SQL code:
SELECT * from wcj WHERE Pno = '3' And TRim(Conclusion) = 'ºÏ¸ñ' and (NET) is null
S ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......