错误信息:Microsoft VBScript 编译器错误 错误 '800a03f6' 缺少 'End' /iisHelp/common/500-100.asp,行242 Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]不允许从数据类型 varchar 到数据类型 money 的隐性转换(表 'mydb.dbo.FinancialRecord',列 'FundTypeA')。请使用 CONVERT 函数来运行此查询。 /finance/AddFinancialRecord.asp,行70 第70行数据:
conn.Execute(" insert into FinancialRecord (Name, Department, ProjectName, "_
& "FundTypeA, FundTypeB, " _
& "FundTypeC, FundTypeD, Sum, Summary, Re, AddDate, AccountName) values ("_
& "'" & TheName &"', " _
& "'" & TheDepartment &"', " _
& "'" & TheProjectName &"', " _
& "'" & TheFundTypeA &"', " _
& "'" & TheFundTypeB &"', " _
& "'" & TheFundTypeC &"', " _
& "'" & TheFundTypeD &"', " _
& "'" & TheSum &"', " _
& "'" & TheSummary &"', " _
& "'" & TheRe &"', " _
& "'" & TheDate &"', " _
& "'" & TheAccountName & "') ")
conn.Execute(" insert into FinancialRecord (Name, Department, ProjectName, "_
& "FundTypeA, FundTypeB, " _
& "FundTypeC, FundTypeD, Sum, Summary, Re, AddDate, AccountName) values ("_
& "'" & TheName &"', " _
& "'" & TheDepartment &"', " _
& "'" & TheProjectName &"', " _
& "'" & TheFundTypeA &"', " _
& "'" & TheFundTypeB &"', " _
& "'" & TheFundTypeC &"', " _
& "'" & TheFundTypeD &"', " _
& "'" & TheSum &"', " _
& "'" & TheSummary &"', " _
& "'" & TheRe &"', " _
& "'" & TheDate &"', " _
& "'" & TheAccountName & "') ")
解决方案 »
- 求一SQL语句
- 请大家继续帮帮忙哈!SQL2000中的SELECT语句.
- 请教一条sql语句
- sql server 2005 服务没有安装
- 请教一个语句
- 这样的update语句应该怎么写,求救!!!!
- 本人太菜解决不了,求正解呀。例如一个表有id a1 a2 a3 a4 cmdid~~~~~~~~~
- [馨郁星愿] 烦人的问题又出现了。。。。
- 表中有一binary类别的字段,存有初始数据,现在导出到sql文本文件,做为安装时导入初始数据用,可导入一直出错在binary这个地方,如何解决?
- 树型数据咋实现层层相加?
- 为什么装不了?
- sql server2000 mdb和ldb 文件均变为了0KB 同时备份文件也变为了0kb,有何办法恢复数据?
提示很明顯了,如果字段類型是money的話,在數據前後不要加上單引號。TheFundTypeA為money類型,就這麼修改代碼conn.Execute(" insert into FinancialRecord (Name, Department, ProjectName, "_
& "FundTypeA, FundTypeB, " _
& "FundTypeC, FundTypeD, Sum, Summary, Re, AddDate, AccountName) values ("_
& "'" & TheName &"', " _
& "'" & TheDepartment &"', " _
& "'" & TheProjectName &"', " _
& TheFundTypeA &", " _ --去掉這裡前後的單引號
& "'" & TheFundTypeB &"', " _
& "'" & TheFundTypeC &"', " _
& "'" & TheFundTypeD &"', " _
& "'" & TheSum &"', " _
& "'" & TheSummary &"', " _
& "'" & TheRe &"', " _
& "'" & TheDate &"', " _
& "'" & TheAccountName & "') ")
如果表中還有money類型的列,參考上面的方法來修改