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" <[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 > > > > > -- j:pn \\no comment
