Blog:: Entries

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