Nope - not as a non string. Make it a number! Try this... insert into category(id, version, name, ordering, external, createddate, modifieddate, createdby_id, modifiedby_id) values (477,14,'Leads',0,'false',NULL,1234567,NULL,1109);
Does it work? If so, you will need to convert the string to a timestamp (ie. The number of seconds since the unix epoch on January 1st, 1970). --- In [email protected], "Johannes Nel" <[EMAIL PROTECTED]> wrote: > > i did try and pass it as a non string, which gave an error as well.as i > said, weirdly it works when i use a sqlite tool, only from AS it fails. > > On Mon, Nov 3, 2008 at 7:54 PM, valdhor <[EMAIL PROTECTED]> wrote: > > > From memory, a *nix timestamp is a Real so it is having trouble > > converting '2008-08-19 16:46:54.26' to a number. > > > > Have you tried converting it before adding it to the database? > > > > --- In [email protected] <flexcoders%40yahoogroups.com>, > > "Johannes Nel" <johannes.nel@> > > wrote: > > > > > > > > Hi All > > > I have a sql statement which runs sans any issues in my sqlite > > viewer, but > > > when executed from within air it gives me the error > > > SQLError: 'Error #3132: Data type mismatch.', details:'could not convert > > > text value to numeric value.' > > > this is the table schema > > > CREATE TABLE category ( > > > id bigint NOT NULL, > > > "version" integer NOT NULL, > > > name character varying(255), > > > ordering integer NOT NULL, > > > "external" boolean NOT NULL, > > > createddate timestamp without time zone, > > > modifieddate timestamp without time zone, > > > createdby_id bigint, > > > modifiedby_id bigint > > > ); > > > and here is the sql statement > > > insert into category(id, version, name, ordering, external, createddate, > > > modifieddate, createdby_id, modifiedby_id) values > > > (477,14,'Leads',0,'false',NULL,'2008-08-19 16:46:54.26',NULL,1109); > > > > > > any ideas? > > > i find it really weird that this works on a SQLite level, but not > > from AS. > > > > > > johan > > > > > > > > > -- > > > j:pn > > > \\no comment > > > > > > > > > > > > > -- > j:pn > \\no comment >
