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]
