2. LIKE '%#people#%'
-jc
Daniel Kessler wrote:
> I have two questions.
>
> 1 - I have a list that I sort by last name (ORDER BY lname ASC). I
> don't have control over the data entry and noticed today that A-Z
> (uppercase) is before a-z (lowercase). Is there a way to get them to
> sort together (Aneka, botha,Sebrook, etc.)?
>
> 2 - I have a DEPARTMENT column which lists multiple departments. As a
> temporary kludge, I list all the departments in one column and
> separate them with a pipe "|". For example, "Kinesiology|Office of
> the Dean" I need to be able to do a query for each department
> separately, so that I can list all the "Office of the Dean" people,
> which is it's own page. If I enter just "Office of the Dean" it
> works, but if it's "Kinesiology|Office of the Dean", it doesn't show
> up. Here's the query:
>
> <cfset people="Office of the Dean">
> <CFQUERY NAME="people_search" DATASOURCE="dch">
> SELECT id,fname,lname,type,title,dept,phone
> FROM PEOPLE
> WHERE dept LIKE '#people#'
> ORDER BY lname ASC
> </CFQUERY>
>
> --
> Daniel Kessler
>
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD 20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
