Hi Manuel,

Thanks for looking at this for me. The class definition is attached
to this email.

The '?' is not getting replaced by a value, or by NULL, which is the
problem.

Cheers,
Nik.



On 20/09/2008, at 6:44 AM, Manuel Lemos wrote:

> Hello,
>
> on 09/19/2008 06:39 AM Nik Sands said the following:
> > but in the situation I showed in my last example, it produces
> invalid
> > SQL. Shouldn't this be avoided, no matter what the value of the
> > variable?
> >
> > Metastorage knew the variable had no valid value (hence it
> displaying
> > the "?" in the "PrepareQuery" line of the debug output), shouldn't
> it
> > be doing something with that invalid value? (Eg, set it to NULL in
> > SQL, or report an error and don't run any SQL)
>
> ? in the prepared query is just a place holder that will be placed by
> the real value when the query is executed. If the variable is set to a
> value, ? is replaced by the value. Otherwise it is replaced by NULL.
>
> It should not give any errors if you set the variable to null .
>
> Anyway, just send me your class definition in the component format
> so I
> can check what may not be right.
>
> --
>
> Regards,
> Manuel Lemos
>
> Find and post PHP jobs
> http://www.phpclasses.org/jobs/
>
> PHP Classes - Free ready to use OOP components written in PHP
> http://www.phpclasses.org/
>
>



========================================================
NIK SANDS - Systems Administrator, IT Services, University of
Tasmania, Australia
Phone: +61-3-63243732 (BH)
AIM / iChat: brassnix







========================================================
NIXANZ - http://nixanz.com/

Like to help out as a beta tester? Let me know which application
you'd like to test.





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