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

Read More Post

STAY CONNECTED

Most Popular

Manifesting Your Dream Career: Finding Your Passion And Purpose
01 Aug

Manifesting Your Dream Career: Finding Your Passion And Purpose

Are you passionate about finding your dream career? Manifesting can help you align your career with your passions and purpose.

Revolutionizing Your Ride: Expert Auto Service At Carolina Auto Service
27 Feb

Revolutionizing Your Ride: Expert Auto Service At Carolina Auto Service

Finding a reliable auto service provider is paramount in the bustling world of vehicle maintenance and repair. That's where Carolina

Floratam: The Robust Grass Solution From Council Growers SOD
25 Jan

Floratam: The Robust Grass Solution From Council Growers SOD

Floratam grass, a popular St. Augustine variety, has become a go-to choice for homeowners and landscapers seeking a lush, durable

Carolina Mobile Autoservice: Your Go-To For Expert Brake Service Repair
25 Jan

Carolina Mobile Autoservice: Your Go-To For Expert Brake Service Repair

For vehicle owners, the braking system is among the most critical components for safety and performance. Carolina Mobile Autoservice, a

Safeguarding Your Property: Expert Water Damage Services By MBC Capital
24 Jan

Safeguarding Your Property: Expert Water Damage Services By MBC Capital

Water damage can significantly impact homes and businesses, often leaving a trail of destruction and disruption in its wake. Understanding

Revanesse Lip Filler: The Secret To A Perfect Pout – Discover America’s New Favorite At Beauty From Ashes Aesthetics
19 Jan

Revanesse Lip Filler: The Secret To A Perfect Pout – Discover America’s New Favorite At Beauty From Ashes Aesthetics

In the ever-evolving world of cosmetic enhancements, there's a constant quest for the next big thing. The latest darling in