Yep,

The problem was that i had empty values in the database, and those empty
values got messed up, i fixed setting NULL in all fields that were empty,
instead of leaving it blank.

Its kinda weird cause i never had problems with it and i aways left fields
blank, but now i m gonna set all the empty stuff as NULL.

Thanx guys for helping :)

On 12/12/05, Lester Caine <lester@...> wrote:
>
> 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.
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "firebird-support<http://groups.yahoo.com/group/firebird-support>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com<firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>


[Non-text portions of this message have been removed]