[Zope] PYTHON script

[Eric Walstad]

Hey Norman,

This is kind of a stab in the dark, but it looks like your use of all single
quotes may be causing trouble.

If you want to use all single quotes (as in your email), you need to escape
your single quotes with backslashes:
myquery = 'SELECT location, SUM(IF(gender=\'M\',1,0)) AS M,
SUM(IF(gender=\'F\',1,0)) AS F\n'
myquery = myquery + 'FROM locations INNER JOIN employees USING (loc_code)
GROUP BY location;'

You can also define your string with triple quotes like:
myquery = """SELECT location, SUM(IF(gender='M',1,0)) AS M,
SUM(IF(gender='F',1,0)) AS F\n"""
myquery = myquery + "FROM locations INNER JOIN employees USING (loc_code)
GROUP BY location;"

Hope I'm on target with this one...

Eric.

> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> Norman Khine
> Sent: Monday, June 11, 2001 3:20 PM
> To: Zope
> Subject: [Zope] PYTHON script
>
>
> Hello I have a MySQL database and I can run the following script using the
> command prompt
>
> SELECT location, SUM(IF(gender='M',1,0)) AS M,
> SUM(IF(gender='F',1,0)) AS F
> FROM locations INNER JOIN employees USING (loc_code) GROUP BY location;
>
> this also works within Zope
>
> but when I try to run this from the python prompt I get an
>
> File "<stdin>", line 1
>     b.execute('SELECT location, SUM(IF(gender='M',1,0)) AS M,
> SUM(IF(gender='F',1,0)) AS F FROM locations INNER JOIN employees USING
> (loc_code) GROUP BY location')
>                                                ^
> SyntaxError: invalid syntax
>
> this is what I did
>
> >>import MySQLdb
> >>db = MySQLdb.connect(db='mydb',user='myuser',passwd='mypasswd')
> >>b = db.cursor()
> >>b.execute('myquery')
>
> error
>
> any ideas
>
> thanks
>
> norman
>
> ps perhaps this post is more suited to the python mail list,
> please forgive
> as I am only a member of the zope community.;^)
>
> zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
> zz/********/z/****\zzz|****\*\zz|*******|z
> z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine
> zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman@khine.net
> zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley
> z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK
> zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz
> zz/******/zz\******/zz|*|zzzzzzz|*|*****|z
> z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z
> zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
>
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )