Case Sensitivity in SQL Queries
I'm pulling a great big list of faculty names from our mammoth admisitrative database. The query is alphabetizing Lowercase names after Uppercase names, so I've got a guy with a last name of van Oosterhout, and that's coming in after a guy named Zimmer. Is there some way for me to specify to the query that I don't want it to alphabetize sensitive to case? How about when I output it? What I just read regarding the groupcasesensitive attribute of cfoutput is that you set it to "no", and it will preserve the case insensitivity of an already case-insensitive query. I just wish I *had* a case-insensitive query to preserve! Willy Ray ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Case Sensitivity in SQL Queries
I'm pulling a great big list of faculty names from our mammoth admisitrative database I just wish I *had* a case-insensitive query to preserve! Have you tried the "scalar SQL function UCase? http://cfhub.com/SQL/scalars/ucase.cfm It should "force" the results to all upper case... of course, LCase() should work as well :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Case Sensitivity in SQL Queries
Try something like: Order by ucase(lastname) Regards, Howie - Original Message - From: "Willy Ray" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 4:28 PM Subject: Case Sensitivity in SQL Queries I'm pulling a great big list of faculty names from our mammoth admisitrative database. The query is alphabetizing Lowercase names after Uppercase names, so I've got a guy with a last name of van Oosterhout, and that's coming in after a guy named Zimmer. Is there some way for me to specify to the query that I don't want it to alphabetize sensitive to case? How about when I output it? What I just read regarding the groupcasesensitive attribute of cfoutput is that you set it to "no", and it will preserve the case insensitivity of an already case-insensitive query. I just wish I *had* a case-insensitive query to preserve! Willy Ray ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Case Sensitivity in SQL Queries
try this in your order by Select firstname, lastname, UPPER(lastname) AS ordName FROM ... ORDER BY ordName -or- this might even work Select . ORDER BY UPPER(LastName) HTH, Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 3:29 PM To: CF-Talk Subject: Case Sensitivity in SQL Queries I'm pulling a great big list of faculty names from our mammoth admisitrative database. The query is alphabetizing Lowercase names after Uppercase names, so I've got a guy with a last name of van Oosterhout, and that's coming in after a guy named Zimmer. Is there some way for me to specify to the query that I don't want it to alphabetize sensitive to case? How about when I output it? What I just read regarding the groupcasesensitive attribute of cfoutput is that you set it to "no", and it will preserve the case insensitivity of an already case-insensitive query. I just wish I *had* a case-insensitive query to preserve! Willy Ray ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
