Re: Refactoring Table Creation

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

> The parameters need to be supplied in a tuple, even if there is only one.
> So the statement should be-
> self.cur.execute("insert into category (cat_name) values (?)",(i,))

   Thanks, Adrian. I knew it was so simple, but I missed that part when I
read the docs.

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.