You need to put the function INSIDE the # signs.
Try this:
<CFQUERY NAME="GetData" DATASOURCE="HR">
SELECT PERSON_LAST_NAME
FROM TBL_PERSON
WHERE PERSON_LAST_NAME LIKE '#Lcase(Criteria)#%'
</CFQUERY>
-----Original Message-----
From: Jason Blum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 9:06 AM
To: CF-Talk
Subject: RE: >>>>> Using function inside Select statement
Hmmm.. That is definitely consistent with the function described in Forta
and elsewhere, but it still doesn't seem to work.
Here is the actual query I am trying to use
<CFQUERY NAME="GetData" DATASOURCE="HR">
SELECT PERSON_LAST_NAME
FROM TBL_PERSON
WHERE PERSON_LAST_NAME LIKE '#Criteria#%'
</CFQUERY>
...and I should be able to substitute
WHERE LCase(PERSON_LAST_NAME) LIKE LCase('#Criteria#%')
right?
But no dice...
Any thoughts?
Thanks all!
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 3:44 PM
To: CF-Talk
Subject: Re: >>>>> Using function inside Select statement
SELECT FirstName, LastName
FROM Names
WHERE LCase(FirstName) LIKE LCase('#Criteria#')
Use quotes around the criteria.
Jochem
Any yous guys know how to do dis?:
SELECT FirstName, LastName
FROM Names
WHERE LCase(FirstName) LIKE LCase(#Criteria#)
...meaning whether they search for "bob" or "Bob" I want to return "Bob."
But this doesn't work... Error code says 'invalid column name'
Sos I thought maybe:
SELECT LCase(FirstName) as LowerCasedName, LastName
FROM Names
WHERE LowerCasedName LIKE LCase(#Criteria#)
...but that dont work neither...
tanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
