frank, > I know that ColdFusion MX ships with the Merant MySQL ODBC driver, version > 5 may as well. nope, not in 5, you have to go get it from mysql.com yes, available by default in CFMX(6). ooooh, now with subqueries....sheesh--i think even foxpro supports subqueries. ;p nagrom http://morgankelsey.com