ÔÚÒ»ÕÅaccess±íÖÐǶÌײéѯ
strSQLCmd.Format(_T("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),
strVar,strValue,strVar2,strValue2);
ÇëÎÊÕâÓï¾äÓÐÎÊÌâÂð
ûÓÐÎÊÌâ¡£
½¨ÒéÄãͨ¹ýµ÷ÊÔ°ÑÕâ¸ö ("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),strVar,strValue,strVar2,strValue2)
Êä³ö¿´Ò»Ï½á¹ûÊÇʲô£¿ ¹À¼ÆÄãµÄ±äÁ¿ÓÐÎÊÌâ¡£
strSQLCmdÄÚÈÝÊÇʲô
CString strSQLCmd;
ÊDz»ÊDZäÁ¿µÄÖµ´ú½øÈ¥ÊÇÕâÖÐÐÎʽ°¡£ºstrSQLCmd.Format(_T("select * from (select * from talk_info where strVar ='strValue') where strVar2 ='strValue2'")£»
Ïà¹ØÎÊ´ð£º
Ê®Íò¼Ç¼·ÖҳЧҳҪÇóºÜ¸ß,²»ÄܶÁÈ¡ÓеļǼÄÇÖÖ.²¢ÇÒÉÏ϶¼¿ÉÒÔ·Ò³,ÔÚ½á¹ûÖÐÅÅÐò.Èç:
°´ÈÕÆÚÅÅÐò
&n ......
¸÷λÅóÓÑ£¬AccessÓëSqlserver2005Á´½Óºó£¬ÔÚaccessÖпÉÒÔ·ÃÎÊsqlserverÖеÄÊý¾Ý£¬µ«Asp·ÃÎÊaccessÖеÄÊý¾Ýʱ£¬ÌáʾMicrosoft JET Database Engine (0x80004005)
ODBC--Á¬½Óµ½ 'test' ʧ°Ü¡£
Ìù³ö´úÂ ......
ÏÖÔÚ×öµÄÒ»¸ö¹«Ë¾ÏîĿҪÇóÒªÓÐÁ½¸ö°æ±¾ Ò»¸öÊÇÓÃAccessµÄÊý¾Ý¿â ÁíÒ»¸öÓÃsql server µÄÊý¾Ý¿â
ÇëÎÊÓÐ×ö¹ýÏà¹Ø¹¦ÄܵĸßÊÖ°ïæָ½Ì ÈçºÎʵÏÖ£¿
ÓõÄÊÇʲô˼·£¿
²Î¿¼petshopÀïÃæµÄ¼Ü¹¹¡£¡£¡£
......
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
ÓÃVBÇóACCESSÁ½¸ö±íµÄºÍ
a±íÀïÓÐ
ID Ãû³Æ ÊýÁ¿ ×ܼÛ
1 a 13 11
2 c 20 20
3 c 2 52
4 b&nb ......