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

ÇëÎÊÈçºÎÔÚ³ÌÐòÀïµ÷ÓôæÔÚACCESSÀïµÄ²ÎÊý²éѯ

ACCESSÖеIJÎÊý²éѯÔÚ´ò¿ªÊ±»áµ¯³ö¶Ô»°¿òÌáʾÓû§ÊäÈëÏàÓ¦µÄ²ÎÊý£¬Óû§ÊäÈë²ÎÊýÖµºó£¬²éѯ½á¹û²Å»á·µ»Ø¡£

ÏÖÔÚÏëÒªÔÚ³ÌÐòÀïµ÷ÓôæÔÚACCESSÀïµÄ²ÎÊý²éѯ¶ÔÏó£¬ÇëÎÊÈçºÎ×ö£¿¹Ø¼üÊÇÈçºÎÔÚÖ´Ðиòéѯ֮ǰ£¬ÈçºÎÔÚ³ÌÐòÀïΪ¸Ã²éѯµÄ²ÎÊý´«Öµ£¿

Áí£¬´æºÃµÄ²éѯºÜ¸´ÔÓ£¬²»ÏëÔÚ´úÂëÀïÖØÐÂдһ±é£¬ËùÒÔÏëÿ´Îµ÷ÓÃÕâ¸ö´æºÃµÄ²éѯ¡£

PS ÎÒÓõÄÊÇACCESS2003¡£
×Ô¼ºÕÒµ½´ð°¸ÁË£º

http://topic.csdn.net/u/20091110/23/447defa1-512b-48a8-abb8-1a13a0a7fafe.html?seed=1433605678&r=61074590#r_61074590

ÀûÓÃado.command Ìí¼Ó²ÎÊý¡£

²ÎÊý²éѯ¿ÉÒÔǶÌ×ô£¿±ÈÈç²ÎÊý²éѯ´ÓÁíÒ»¸ö²ÎÊý²éѯµÄ½á¹û¼ÌÐø½øÐÐÊý¾Ý·ÖÎö£¿

²ÎÊý²éѯ¿ÉÒÔǶÌ×ô£¿±ÈÈç²ÎÊý²éѯ´ÓÁíÒ»¸ö²ÎÊý²éѯµÄ½á¹û¼ÌÐø½øÐÐÊý¾Ý·ÖÎö£¿

²»¿ÉÒÔǶÌ×
ÄãÐèÒª°Ñ ÁíÒ»¸ö²ÎÊý²éѯµÄ½á¹û ´æÈë±äÁ¿È»ºóÔÙµ÷Óá£

»òÕߺϲ¢ÄãµÄSQLÓï¾ä¡£

ÓÃ×Ö·û´®ÀÛ¼ÓÉú³ÉSQLÓï¾ä¡¡OR¡¡ÓÃADO½«²ÎÊý´«µÝ½øÈ¥


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

ACCESSµÄ×Ô¶¨Ò庯ÊýÔÚdelphiÀïÔõôÓÃÄØ...

ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()

¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...

Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!


(ÔÚA ......

ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â

ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:

<?xml version="1.0" encoding="utf-8"? ......

¹ØÓÚDelphiÁ¬½ÓACCESSÊý¾Ý¿â²éѯÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......

ÈçºÎÉ趨access logÖеÄauthenticated username?

ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿

Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ