Russel!!!
That's it man! Thank you SOOOOO much. I knew it had to be this simple.
Literally spent the last two days combing through books on SQL, CF,
Allaire and Forta's sites - ugh! This list is just the best resource
out there!
Thank you again!
> ----------
> From: Russel Madere
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, July 24, 2001 9:18 AM
> To: CF-Talk
> Subject: RE: >>>>> Using function inside Select statement
>
> You need to use the SQL functions. In Transact SQL use UPRER or
> LOWER.
>
> You SQL would look like:
>
> <CFQUERY NAME="GetData" DATASOURCE="HR">
> SELECT PERSON_LAST_NAME
> FROM TBL_PERSON
> WHERE LOWER(PERSON_LAST_NAME) LIKE LOWER('#Criteria#%')
> </CFQUERY>
>
> OR if you want to mix SQL and ColdFusion:
>
> WHERE LOWER(PERSON_LAST_NAME) LIKE '#LCase(Criteria)#%'
>
> Hope this helps you out.
>
> Russel
>
> > -----Original Message-----
> > From: Jason Blum [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 24, 2001 11: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
