|
楼主 |
发表于 2014-2-20 14:37:27
|
显示全部楼层
本帖最后由 mj19881029 于 2014-2-20 14:41 编辑
yinlun 发表于 2014-2-20 14:30
对于mysql中的 表名 和字段名是不可以使用 单引号的,要使用`,检查下你的sql语句 ...
Sql语句如下,- sql = "insert into OA_EM_ReceiveEmail(fID,version,fQurey,fReplyState,fEmailName,fText,fFJID,fSendPerName," +
- "fSendPerID,fSendPerCode,fConsigneeID,fConsignee,fConsigneeCode,fSendTime) "
- + "values('"+fID+"',0,'未查看','未回复','"
- + fEmailName
- + "','"
- + fText
- + "','"
- + FJID
- + "','"
- + fSendPerName
- + "','"
- + fSendPerID
- + "','"
- + fSendPerCode
- + "','"
- + fConsigneeID
- + "','"
- + revicePerName
- + "','"
- + revicePerCode
- + "','"
- + dtStr
- + "') ON DUPLICATE KEY UPDATE version=0";
复制代码 |
|