Subject Re: [firebird-php] Parameterized query fails on udf
Author Jochem Maas
Yves Glodt wrote:
> Hi,
>
> I have a problem with a query that fails whenever I put a parameter as an UDF
> variable: Consider this:
>
>
> ... and SIMPLE(LIBELLE1) LIKE('%'||SIMPLE(?)||'%') order byLIBELLE1 ...
> Error code: -804
> Error message: Dynamic SQL Error SQL error code = -804 Data type unknown
>

smells like an charset encoding error.

>
> When I replace the ? with '$q' it works. Is this due to my udf or due to
> firebird, or tp php...?
>
>
> Best regards!
> Yves
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>