That's not what I meant. I'm talking about manually assigning a value to a hand, not using the ID field. So the dataset could look like this:
1|Two Pair|10 2|Flush|25 3|Straight Flust|50 4|Royal Flush|300 How is that not pure? Each hand has a distinct value correct? To me it seems as if you'd simply be saving time doing lookups for each hand when you could just compare numbers. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 2:09 PM To: CF-Talk Subject: Re: ordering Poker hands > why not just one table with the hands ordered appropriately? ....because I'm a bit of a data purist ;-) The order of records in a table "implying" a hierarchy is a no no in most books. IN my books it should be VERY explicit (thus my example)....no room for confusion. Just think if someone accidentally deleted 2 pair and then it had to be added as the last record...thus "implying" 2 pair beats everything...bad bad bad ;-) Cheers ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259512 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
