1
…
…
Posted At : Sep 01, 2008 21:46 PM
| Posted By : Ed Tabara
Related Categories:
,
,
If you have any concerns about Adobe products, you may use site to leave your suggestions for Adobe engineers. Also you may see top rated gripes by application. A related blog is available at .|
|
| 254 Views
| 2% / 0% Popularity
Posted At : Aug 16, 2008 17:30 PM
| Posted By : Ed Tabara
Related Categories:
Problem:
We have a DB table with varchar values. To make it easy i’ve created it with a QueryNew:
And what is needed is to do the following query:
Select *
From getTMP
Where col1 =
or col2 =
What we will get is the following error:Query Of Queries syntax error.
Encountered “. Query Of Queries runtime error.
It come that ColdFusion see the value of CFQUERYPARAM as a DATE and not as VARCHAR. Casting to varchar left and right sides of the equalities does not help at all.Solution:
Use LIKEinstead of =in the query like this:
Select *
From getTMP
Where col1 like
or col2 like
|
| 458 Views
| 4% / 36% Popularity
