On Sep 7, 10:39 pm, mcl <[EMAIL PROTECTED]> wrote:
> On 7 Sep, 14:11, Carsten Haese <[EMAIL PROTECTED]> wrote:
>
>
>
> > On Fri, 2007-09-07 at 05:52 -0700, mcl wrote:
> > > > ValueError: invalid literal for int(): 0-
> > > > args = ('invalid literal for int(): 0-',)
>
> > > > =========================================
> > > > Thanks Richard
>
> > > Sort of solved it.
>
> > > On that particular table it did not like * for all fields.
>
> > > Any reason why that would be the case ?
>
> > None that we can divine without more information. What's the schema for
> > the table in question, which column(s) are you excluding to make the
> > query work, and what kind of data is in the column(s) you're excluding?
>
> > --
> > Carsten Haesehttp://informixdb.sourceforge.net
>
> Thanks for replying.
>
> I did not exclude any columns and the Schema is:
>
> CREATE TABLE lstData (
> qlCat varchar(20) NOT NULL default '',
> qlTitle varchar(255) NOT NULL default '',
> qlSubTitle varchar(255) default NULL,
> qlDetails text,
> qlPic varchar(20) default NULL,
> qlPostCode varchar(16) default NULL,
> qlUpd timestamp NOT NULL default '0000-00-00 00:00:00' on update
> CURRENT_TIMESTAMP,
> KEY `idx-qlCat` (qlCat)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> Thanks again
>
> Richard
saw this before on earlier MySQLdb and timestamp column
try upgrading your MySQLdb
see https://bugzilla.redhat.com/show_bug.cgi?id=155341 or
http://www.ravenbrook.com/project/p4dti/master/code/replicator/mysqldb_support.py
--
http://mail.python.org/mailman/listinfo/python-list
