Re: Ensuring Text Is Quoted On Insertion

On Mon, 20 Nov 2006, Adrian Klaver wrote:

> Alright, looking at your original post I am going to assume
> pName,sName,rNo and rTxt map to the above strings. If that is the case
> then do cur.execute(insertStatement,(pName,sName,rNo,rTxt))

Adrian,

   That's what I have. But, that's not what I see with the python print
statement. However, now that I think about it, there's no reason to assume
they work the same way. Pysqlite will take each complete string and assign
it to the field in the database, regardless of how it looks on the console
with the print statement.

   I needed to have tested it live and not assumed the same behavior as the
print statement. My apologies.

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