honestly i would set it up that, you had the values in a database that was an [datatype]int column, and assign values to those various states. however, when the page is viewed, interpret the values of the states, the integers 1[running] 2[offline] 0[unknown]
and then translate those integer values into words on the fly from your query or do a count(id) from MachineStatus where state = 1 and then that would return your count of machine that own a state of 1. tony -----Original Message----- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 3:18 PM To: CF-Talk Subject: OT: Stupid SQL Problem (in oracle) I need some way to convert a word into a number. I know I've done it once before, but I can't remember what I did. For example, I have a query that will return something like the following: Machine1 Running Machine2 Running Machine3 Offline Machine4 Running Machine5 Offline Machine6 Unknown I want to get some result like this: Running Offline Unknown Total 3 2 1 6 I know it has something to do with a sum and translating "Running" into 1, "Offline" into a 1 and "Unknown" into a 1, I just can't remember how I did it. This is an oracle 8i system I'm working with. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax: (502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
