Adam wrote:

>>I didnt try isql, but in ibwebadmin and IBExpert the query is ok, its just
>>in the php that i m having this problem, but i need to run it using php :(
>
> If it runs fine in these tools then your problem has NOTHING to do
> with Firebird. It is either a problem with your PHP or with your PHP
> driver for Firebird.
>
> I would suggest you take it to the Firebird-PHP list where they can
> work out what is wrong.

Bit late Adam - he has already worked out the problem which is due to
NULL entries in the text fields - something that it is worth flagging to
other users :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.