Re: Nested Looping SQL Querys

2006-09-21 Thread Steve Holden
Carsten Haese wrote: > On Thu, 2006-09-21 at 01:12, Dennis Lee Bieber wrote: > >>On Wed, 20 Sep 2006 13:21:54 -0400, Steve Holden <[EMAIL PROTECTED]> >>declaimed the following in comp.lang.python: >> >> >>>.execute() is a cursor method, not a connection method. Some DB API >>>modules do implement

Re: Nested Looping SQL Querys

2006-09-21 Thread Carsten Haese
On Thu, 2006-09-21 at 01:12, Dennis Lee Bieber wrote: > On Wed, 20 Sep 2006 13:21:54 -0400, Steve Holden <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: > > > .execute() is a cursor method, not a connection method. Some DB API > > modules do implement it as a connection method,

Re: Nested Looping SQL Querys

2006-09-20 Thread Steve Holden
Dennis Lee Bieber wrote: [...] > # not conn.execute() ? That's what all the DB-API compliant adapters > use > > result = conn.execute(sql, params) > .execute() is a cursor method, not a connection method. Some DB API modules do implement it as a connection method, but that makes it impo

Re: Nested Looping SQL Querys

2006-09-20 Thread Steve Holden
Bruno Desthuilliers wrote: > Fuzzydave wrote: > > (snip) > """ > pubID=cgiForm.getvalue('pubID') > pubName=cgiForm.getvalue('pubName','Unknown Publication') > > sqlcheck1 = "SELECT pub_type FROM medusa.cmi_publication WHERE pub_id = > '"+pubID+"'" > overseas1 = conn.query(sqlcheck1) > pubType = c

Re: Nested Looping SQL Querys

2006-09-20 Thread Bruno Desthuilliers
Fuzzydave wrote: > I am back developing futher our Python/CGI based web application run by > a Postgres DB > and as per usual I am having some issues. It Involves a lot of Legacy > code. s/Legacy/Norwegian Blue/ -- bruno desthuilliers python -c "print '@'.join(['.'.join([w[::-1] for w in p.spl

Re: Nested Looping SQL Querys

2006-09-20 Thread Bruno Desthuilliers
Fuzzydave wrote: (snip) """ pubID=cgiForm.getvalue('pubID') pubName=cgiForm.getvalue('pubName','Unknown Publication') sqlcheck1 = "SELECT pub_type FROM medusa.cmi_publication WHERE pub_id = '"+pubID+"'" overseas1 = conn.query(sqlcheck1) pubType = cmi.fetch_rows(overseas1) """ May we have the url

Nested Looping SQL Querys

2006-09-20 Thread Fuzzydave
I am back developing futher our Python/CGI based web application run by a Postgres DB and as per usual I am having some issues. It Involves a lot of Legacy code. All the actual SQL Querys are stored in the .py files and run in the .cgi files. I have the problem that I need to construct a row from t