>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], "Johannes Nel" <[EMAIL PROTECTED]> 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 >
