Question

ASP问题，字符串的语法错误 在查询表达式 ''带有初装修)' 中。

错误提示：
错误号：-2147217900
错误描述：字符串的语法错误 在查询表达式 ''带有初装修)' 中。sql=insert into AspCms_GuestBook(LanguageID,FaqTitle,Contact,ContactWay,Content,AddTime,FaqStatus,AuditStatus,infocity,inforegion,infoemail,infofloorname,infohouse_01,infohouse_02,infohouse_03,infofloor,infofitment_time1,infofitment_time2,inforequire_material,infofitment_type) values(1,'1','1','1','1','2012-3-25 13:25:34','False','False','1','1','1','1','2','1','1','高层','三','5月份','普通品牌','带有初装修)

ASP源代码SQL语句：
Conn.Exec"insert into {prefix}GuestBook(LanguageID,FaqTitle,Contact,ContactWay,Content,AddTime,FaqStatus,AuditStatus,infocity,inforegion,infoemail,infofloorname,infohouse_01,infohouse_02,infohouse_03,infofloor,infofitment_time1,infofitment_time2,inforequire_material,infofitment_type) values("&setting.languageID&",'"&FaqTitle&"','"&Contact&"','"&ContactWay&"','"&Content&"','"&AddTime&"','"&FaqStatus&"','"&AuditStatus&"','"&infocity&"','"&inforegion&"','"&infoemail&"','"&infofloorname&"','"&infohouse_01&"','"&infohouse_02&"','"&infohouse_03&"','"&infofloor&"','"&infofitment_time1&"','"&infofitment_time2&"','"&inforequire_material&"','"&infofitment_type&")","exe"

请问错在那里呢 谢谢 我还需要补充什么吗？

Answer 1

你好 请试下下面的句子
Conn.execute("insert into {prefix}GuestBook(LanguageID,FaqTitle,Contact,ContactWay,Content,AddTime,FaqStatus,AuditStatus,infocity,inforegion,infoemail,infofloorname,infohouse_01,infohouse_02,infohouse_03,infofloor,infofitment_time1,infofitment_time2,inforequire_material,infofitment_type) values("setting.languageID",'"&FaqTitle&"','"&Contact&"','"&ContactWay&"','"&Content&"','#"&AddTime&"#','"&FaqStatus&"','"&AuditStatus&"','"&infocity&"','"&inforegion&"','"&infoemail&"','"&infofloorname&"','"&infohouse_01&"','"&infohouse_02&"','"&infohouse_03&"','"&infofloor&"','"&infofitment_time1&"','"&infofitment_time2&"','"&inforequire_material&"','"&infofitment_type&")" )