asp中的错“标准表达式中数据类型不匹配。”
if INT_ID = "" then
strSql = ""
strSql = strSql &" INSERT INTO "
strSql = strSql & GLOBAL_DB_TRADEPRODUCT
strSql = strSql &" ( "
strSql = strSql &" INT_BID "
strSql = strSql &" ,INT_SID "
strSql = strSql &" ,CHR_AUDITING "
strSql = strSql &" ,NVC_NUMBER "
strSql = strSql &" ,NVC_NAME "
strSql = strSql &" ,NVC_SAVENAME "
strSql = strSql &" ,INT_ORDER "
strSql = strSql &" ,TXT_BASEINFO "
strSql = strSql &" ,TXT_DESCRIBE "
strSql = strSql &" ,DAT_CREATETIME "
strSql = strSql &" ) "
strSql = strSql &" VALUES( "
strSql = strSql &" '" & INT_BID &"'"
strSql = strSql &" ,'" & INT_SID "'"
strSql = strSql &" ,'" & CHR_AUDITING &"'"
strSql = strSql &" ,'" & NVC_NUMBER &"'"
strSql = strSql &" ,'" & NVC_NAME &"'"
strSql = strSql &" ,'" & NVC_SAVENAME &"'"
strSql = strSql &" ,'" & INT_ORDER &"'"
strSql = strSql &" ,'" & TXT_BASEINFO &"'"
strSql = strSql &" ,'" & TXT_DESCRIBE &"'"
strSql = strSql &" ,'" & NOW() &"'"
strSql = strSql &")"
conn.execute strSql
错误:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。
/manage/tradeedit.asp, 第 92 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; CIBA; .NET CLR 2.0.50727)
------解决方案--------------------你表 GLOBAL_DB_TRADEPRODUCT 表中所有字段都是字符型的?
数字型则不要加引号,日期型则用#2009-10-02#
------解决方案--------------------将strSql显示出来看看
------解决方案--------------------