I have a database of race results cover six years. The results table has a date field, race name field, and fields for the first 50 finishers. I also have a race name table and a racers table. The fields in the results table are populated with the corresponding key fields for the race and runners.
The user will select a racer to query. I need to loop through the results table and do two things: 1) check the name of the race, and 2) check with field that the runner finished in each race. (first loop, check all race #1 entries and placement of runner #1, second loop check all race #2 entries and placement of runner #1, etc. For results, I need to show the name of each race, and the number of top 5 finishes, top 10 finishes, top 15 finishes and average finish that that runner has had in that particular race over the years. I'm confused as to whether to use cfswitch or cfif statements. Or whether I should use arrays. Could someone give some guidance, and possible examples of how the code should look? Thanks, Tim __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists