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
--
http://mail.python.org/mailman/listinfo/python-list
