Re: difference between statements

>> I very rarely work directly in sqlite, but Deletes and Inserts have
to
>> have a con.commit() after them.
>>
>> Also you may be having a problem which I have experienced, if a query
>> contains parentheses then paremeter substitution fails. In other
words
>> if I have a query like this:
>>
>> cur.execute("""select * from Products where ProductID = (select
>> ProductID from Sponsor where SponsorID = ?)""", (12,)) [...]
>
>Works fine here (tried with SQLite 3.3.5).
>
>-- Gerhard

That was my error, the culprit was the mx.ODBC driver, not sqlite, sorry
for any confusion.


Thanks,

Greg Givler
Information Technology
Lockwood®
10 Valley Stream Parkway
Malvern, PA 19355
Phone: (484) 605-4826
Email: [email protected]


                                                                                                                                           
                      Gerhard Häring                                                                                                       
                      <[email protected]>             To:       "For users of the pysqlite database module." <pysqlite-IAPFreCvJWPBWskQ1e/[email protected]>       
                      Sent by:                     cc:                                                                                     
                      pysqlite-bounces@list        Subject:  Re: [pysqlite] difference between statements                                  
                      s.initd.org                                                                                                          
                                                                                                                                           
                                                                                                                                           
                      03/29/2007 10:52 AM                                                                                                  
                      Please respond to                                                                                                    
                      "For users of the                                                                                                    
                      pysqlite database                                                                                                    
                      module."                                                                                                             
                                                                                                                                           
                                                                                                                                           




[email protected] wrote:
> I very rarely work directly in sqlite, but Deletes and Inserts have to
> have a con.commit() after them.
>
> Also you may be having a problem which I have experienced, if a query
> contains parentheses then paremeter substitution fails. In other words
> if I have a query like this:
>
> cur.execute("""select * from Products where ProductID = (select
> ProductID from Sponsor where SponsorID = ?)""", (12,)) [...]

Works fine here (tried with SQLite 3.3.5).

-- Gerhard
_______________________________________________
pysqlite mailing list
pysqlite-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/pysqlite

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please call the help desk at ext 4850
______________________________________________________________________




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________