这是一个创建于 4020 天前的主题，其中的信息可能已经有所发展或是发生改变。
向网站提交数据时网站数据库出错,大概能看出是提交内容格式不正确,但是怎么改却没有头绪,求众V2EXer帮忙
INSERT INTO et_content (user_id,content_body,posttime,type) VALUES ('24579','<Storage {'title': u'fg'}>','1384345479','weixin') Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'title': u'fg'}>','1384345479','weixin')' at line 1
INSERT INTO et_content (user_id,content_body,posttime,type) VALUES ('24579','<Storage {'title': u'fg'}>','1384345479','weixin') Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'title': u'fg'}>','1384345479','weixin')' at line 1
 |
1
qiayue 2013-11-13 20:39:23 +08:00  1
('24579','<Storage {'title': u'fg'}>','1384345479','weixin')
改为 ('24579','<Storage {"title": "ufg"}>','1384345479','weixin') 或者 ('24579','<Storage {\'title\': \'ufg''}>','1384345479','weixin') 你原文的 u'fg' 我认为是你手误，你本来想写的是 'ufg' 吧？ |
|
2
qiayue 2013-11-13 20:39:57 +08:00
我也手误了
或者 ('24579','<Storage {\'title\': \'ufg\'}>','1384345479','weixin') |
 |
3
shiny 2013-11-13 20:41:52 +08:00
怎么 content 存的这个，先把 python Storage 对象正确转成字符串+转义吧。
|
Select Language