Re: Ensuring Text Is Quoted On Insertion

Rich Shepard <[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
On Mon, 20 Nov 2006, Adrian Klaver wrote:

> cur.execute(insertStatement,('wetlands','quantity','qn1','if size is
> large,then value is increased'))

Adrian,

   This works when the strings are defined and constant. However, in the
application they are not. Each row of the wx.ListCtrl() has distinct values
for each of the four columns, and each set of four constitutes a record to
be inserted into the database.

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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.