On 2/20/07, Jim Cassata <[EMAIL PROTECTED]> wrote:
> while on the "subject" of best practice, I have a question re CFC practice.
>
> In the days I made my app, I have a table (simplified) that lists IT servers.
> Looks kinda like this:
>
> serverid | servername | servertype |
>
> 1 | win01 | 1 |
>
> 3 | win09 | 2 |
>
> 2 | win06 | 3 |
>
>
>
> Now server type was just 1=production, 2=dev, 3=test.
of course, the term "best practice" is highly subjective, so you'll
likely get a few answers. i'd suggest maybe using a CASE statement in
your SQL.
SELECT
serverID,
serverName,
CASE serverType
WHEN 1 THEN 'Production'
WHEN 2 THEN 'Dev'
WHEN 3 THEN 'Test'
END
--
Charlie Griefer
================================================
"...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/
Archive: http://www.houseoffusion.com/groups/Flex/message.cfm/messageid:3640
Subscription: http://www.houseoffusion.com/groups/Flex/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.37
