accessʱ¼ä²éѯÎÊÌ⣬ÔÚÏߵȣ¬Ð»Ð»

VBScript code:

sql = "Select * from new2010year where 1=1 and FormatDateTime(b_levetime,2)=#"&b_levetime&"# order by id desc"
response.write("sql="+sql)


SQLÊä³öºóSQL code:
sql=Select * from new2010year where 1=1 and FormatDateTime(b_levetime,2)=#2010-01-06# order by id desc
£¬°ÑÊä³öµÄSQLÓï¾äÔÚaccessÊý¾Ý¿âÖÐÔËÐУ¬Ã»ÓÐÎÊÌ⣬
·ÅÔÚaspÖоÍÓÐÎÊÌ⣬Òì³£ÊÇ:
Microsoft JET Database Engine (0x80040E14)
±í´ïʽÖÐ 'FormatDateTime' º¯Êý䶨Òå
Çë´ó¼Ò¿´¿´£¬Ð»Ð»

---

ÓöþÂ¥µÄ·½·¨
Êä³öµÄSQLÓï¾äSQL code:
Select * from new2010year where 1=1 and Format(b_levetime,'YYYY-MM-DD')='2010-01-06' order by id desc

ÔÚaccessÖÐÊÇÄܲéѯµ½Öµ£¬µ«ÔÚ·ÅÔÚasp³ÌÐòÖÐÓÐÒì³£ÈçÏ£º
Microsoft JET Database Engine (0x80040E10)
ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ¡£Microsoft JET Database Engine (0x80040E10)
ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ¡£

---

ÄãÊÇÔõôÁ¬½ÓMDBµÄ£¿ADO£¿Á¬½Ó×Ö´®

---

Set rs = Server.CreateObject("ADODB.Recordset")

---

VBScript code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://ww