>> I'm kind of at a loss on how to group this statement right.
Don't forget, you can loop over the queries by using cfloop instead of cfquery. This might help you with your grouping. You can then do whatever grouping you need in the first query itself instead of on the output a few lines lower. To make sure you aren't experiencing key problems with your tables, try commenting out the actual cfquery for the update statement and adding a line return at the end of it. That way, you can see all of the update statements on the screen without hitting the DB. Once you know your results are the way you want, turn it back on and hit the DB. ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
