ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿ÃÇ°ïæ·ÖÎö һϣ¡£¡£¡ ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë XML code: <?xml version="1.0" encoding="utf-8"?> <?xml-stylesheet type="text/xsl" href="inc/sq.xsl"?> <Information> <Station> <Company>³¤½</Company> <name>99Õ¾</name> <inflow>30200</inflow> <outflow>30200</outflow> <reslevel>147.72</reslevel> <output>17190</output> <time>2009-08-23 8:00:00</time> </Station> <Station> <Company>»ÆºÓ</Company> <name>33µçÕ¾</name> <inflow>30200</inflow> <outflow>25600</outflow> <reslevel>65.5</reslevel> <output>17789</output> <time>2009-08-24 8:01:00</time> </Station> </Information>
access²»Ö§³ÖxmlÎļþÀàÐÍ,Ö»ÄܶÁ³öÀ´xmlÊý¾ÝÓÃÑ»·insert½øaccess Òª²»¾ÍÉèΪ´ó×Ö¶ÎÀ´µ±×Ö·û´®´æ£¬SQL2005ÀïÓÐXMLÀàÐ͵Ä×ֶΣ¡ÒýÓà access²»Ö§³ÖxmlÎļþÀàÐÍ,Ö»ÄܶÁ³öÀ´xmlÊý¾ÝÓÃÑ»·insert½øaccess Õâ¸öÄܲ»ÄÜ˵Ïêϸµã°¡£¬ÎÒûÓÐ×ö¹ý£¬ÓÐÏêϸµÄ´úÂë¾ÍºÃÁË Õâ¸öÄܹ»Åжϵ±Ç°µÄXMLÎļþ¸üк󣬾ÍÀ´Ñ»·µÄ½«Êý
Ïà¹ØÎÊ´ð£º
<?php include("adodb/adodb.inc.php"); $db = &NewADOConnection("access"); $access = realpath("Data.mdb"); $dsn = "Provider=Microsoft.J ......
ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º |/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg ......
ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º |/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jp ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÒ°ÑsqlµÄÊý¾Ý¿â»»ÎªaccessÊý¾Ý¿â£¬Ö»ÐÞ¸ÄÁËÁ¬½ÓÎļþ£¬ÆäËüµÄ¶¼Ã»Óиı䣬³öÏÖ´íÎó(0x80004005) 無·¨Ö¸³öµÄ錯誤¡£ function returnrsByParam(strsql,con,cursor_type,lock_type,options) ......