I'm leveraging the metadata to get the ordinal order of the columns instead of the lovely alphabetical order of columns, which MM's coldfusion throws at you. You can make some really nice code generation tools with the metadata as far as making DAOs and Beans ect. Previously I used to query sysobjects but that didn't work so well with anyhting other than MS SQL.
Adam H On 5/17/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > We haven't used Query Metadata yet, but we've already got an > application that really only works if we can use java nulls. Could we > have done it with CF6? Yes probably -- but it would have been a big > headache. It's not that we're "leveraging" java nulls per se -- but > rather that the lack of them in 6 was a hindrance. The admin API on > the other hand allowed us to replace 20 someodd lines of obscure and > unsupported serviceFactory code with 4 clean lines in one of our > adminsitrative tools. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206954 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
