Re: Please Explain This Error

Ok, then let me suggest this, what I do is declare cur and con as global
variables then I don't have to do anything. In some instances I have a
SQLite class as well that only creates a new connection when there is
not one.
You write:

   Excellent suggestion, Greg. But, cur.fetchone() is on line 129 (now)
and
the error is still on the line above with the 'self.cur.execute(...'.

try changing self.cur.execute to cur.execute and see if that works.


Thanks,

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


                                                                                                                                           
                      Rich Shepard                                                                                                         
                      <rshepard@appl-ecosys        To:       "For users of the pysqlite database module." <pysqlite-IAPFreCvJWPBWskQ1e/[email protected]>       
                      .com>                        cc:                                                                                     
                      Sent by:                     Subject:  Re: [pysqlite] Please Explain This Error                                      
                      pysqlite-bounces@list                                                                                                
                      s.initd.org                                                                                                          
                                                                                                                                           
                                                                                                                                           
                      11/02/2006 04:26 PM                                                                                                  
                      Please respond to                                                                                                    
                      "For users of the                                                                                                    
                      pysqlite database                                                                                                    
                      module."                                                                                                             
                                                                                                                                           
                                                                                                                                           




On Thu, 2 Nov 2006, [email protected] wrote:

> Just saw you bug, you have self.cur, then you say cur.fetchone() it
> should be self.cur.fetchone()

   Excellent suggestion, Greg. But, cur.fetchone() is on line 129 (now)
and
the error is still on the line above with the 'self.cur.execute(...'.

   I think that I tried that, too, before writing. I'm still getting
used to
knowing where I need to specify the specific object using 'self' and
when I
don't.

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
_______________________________________________
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 
______________________________________________________________________