I usually have dbinfo to get the needed metadata and generate my code based on that.
Something that should be implemented for CF9 would be something similar that LCDS support that is QueryRowType. With this kind of functionality, you can return directly your queries to the client and they will get converted to the corresponding AS classes. -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

