Subject | Parameterized query fails on udf |
---|---|
Author | Yves Glodt |
Post date | 2006-07-25T14:20:39Z |
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
When I replace the ? with '$q' it works. Is this due to my udf or due to
firebird, or tp php...?
Best regards!
Yves
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
When I replace the ? with '$q' it works. Is this due to my udf or due to
firebird, or tp php...?
Best regards!
Yves