<CFQuery Name="getuser" Datasource="wweb_status">
Select * from admin
Where username = '#trim(session.username)#'
</CFQUERY>
and here as well:
<CFIF trim(getuser.priority) EQ "high">
<option value="custom">Custom Status Message</option>
But as always I do appreciate the quick and helpful responses.
Robert O.
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 01, 2004 3:46 PM
To: CF-Talk
Subject: Re: populating dropdowns
Why would checking case insensative get you into trouble?
As you say it would be bad design to make HIGH and high mean differant
things, so why then would session.username='high' mean anything
differant than UCASE(session.username) is 'HIGH'?
Bryan Stevenson wrote:
> The value could be high,High,HIGH,HiGH etc. SO checking to see if
> it's 'high' can get you into trouble (unless of course HIGH and high
> have different meanings...then by all means it should be as it was
> written (but IMHO that would be bad design to have HIGH and high mean
> different things).
>
> It's case sensitive because the value of username could be stored in the
> DB as all upper/lower/mixed case....to be case insensitive you have to
> check values of the same case...all upper...all lower...whatever floats
> yer boat.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
