If you run MS SQL server, install the client tools and the Books Online on
your machine. Those 2 components have saved my tail during deadline
situations more often that I care to count.
They are where I turn to on almost every SQL problem I have.
They have also kept our DBA sane because he doesn't need to answer my
questions all of the time. :)
Russel
> -----Original Message-----
> From: Jason Blum [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 7:34 AM
> To: CF-Talk
> Subject: RE: >>>>> Using function inside Select statement
>
>
> 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
