Re: Error Binding Parameter 0

On Wed, 20 Dec 2006, Rich Shepard wrote:

>   What do you suggest as a way of re-writing the above as a set of
> concatenated strings? My first attempt generates an error near the comma
> in the third line.

   I don't know near which comma the error is located. After several other
format changes I now have this:

   stmt1 = """insert into variable (var_name, var_desc, policy_name, sub_policy_name)
                    values (?,?,?,?),
           (varDlg().varName, varDlg().varDesc, varDlg().polName, varDlg().subName)
           """
   self.appData.cur.execute(stmt1)

and the error message is:

   File "/data1/eikos/variablePage.py", line 239, in OnVarAdd
     self.appData.cur.execute(stmt1)
pysqlite2.dbapi2.OperationalError: near ",": syntax error

   I don't know _which_ comma is referenced so I don't see the error.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)    |            Accelerator
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863