MySQLdb: ValueError Something Stupid

mcl mcl.office at googlemail.com
Fri Sep 7 16:39:46 CEST 2007


On 7 Sep, 14:11, Carsten Haese <cars... at uniqsys.com> 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




More information about the Python-list mailing list