Subject | Re: Incompatible column/host variable data type. |
---|---|
Author | Sergio |
Post date | 2011-02-03T21:18:55Z |
> I think that you will need to give more information about the values thatthanks for the answer Martijn!
> are used in this query before we can help you.
The values are
:ID = 1
:ID_EMPRESAS = 1
:NOMBRE = 'PRUEBA'
:DIRECCION = ''
:TELEFONOS = ''
if I remove the "AND (:NOMBRE <> '')" parts the query runs without problem. As this simple query is for cheking if a customer already exist in the database, I don't want to evaluate the blank fields, thats why I added the forementioned part.
Thanks again!!
-s