Re: ValueError: too many values to unpack

I meant to say column and typed rows, sorry about that, but again, my
advice is to avoid select * when you can. Just to avoid things in the
future if you ever add a column to your table, then you have to change
all your legacy code to handle the added column value being returned.

BTW, I rarely follow my own advice and am always fixing bugs because of
it :)

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] ValueError: too many values to unpack                          
                      pysqlite-bounces@list                                                                                                
                      s.initd.org                                                                                                          
                                                                                                                                           
                                                                                                                                           
                      11/30/2006 02:52 PM                                                                                                  
                      Please respond to                                                                                                    
                      "For users of the                                                                                                    
                      pysqlite database                                                                                                    
                      module."                                                                                                             
                                                                                                                                           
                                                                                                                                           




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

> The other possibility is that you have more rows than the 5 you are
> returning, that is why select * is bad, you should do a select
model_desc,
> model_type, keName, agent from tablename

Greg,

   One row, five columns. But, you're correct that by specifying each
column
by name I avoid the mis-match I had.

Thanks,

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 
______________________________________________________________________