I think it is pymysql's problem because it dosen't escape query
correctly, so, an syntax error is throwed.
MySQLdb can escape query well, as a result , when I update web2py to
new version, this error occurs.
On 2月15日, 下午6时09分, Johann Spies wrote:
> On 15 February 2011 08:49, hywang wrote:
>
> >
On 15 February 2011 08:49, hywang wrote:
> Please help to run it :-)
>
> # File Name: default.py
>
> def index():
>db.define_table("pymysql",Field("content","text"),migrate=True)
>content = """'http://img1.t.sinajs.cn/t3/style/css/common/
> layer.css'"""
>#content = """this sentence i
Please help to run it :-)
# File Name: default.py
def index():
db.define_table("pymysql",Field("content","text"),migrate=True)
content = """'http://img1.t.sinajs.cn/t3/style/css/common/
layer.css'"""
#content = """this sentence is no problem at all"""
db.executesql("INSERT INTO py
I install two different version web2pys , one is 1.91.6 and the other
is 1.87.3
1.87.3 works well while 1.91.6 throws the error
On 2月14日, 下午5时53分, "Martin.Mulone" wrote:
> are you sure is not syntax error?
>
> db.executesql("insert into hytest (conent)values(%s)",content)
>
> "conent"
are you sure is not syntax error?
db.executesql("insert into hytest (conent)values(%s)",content)
"conent"
5 matches
Mail list logo
