>I was wondering if there is a way to pull column information >from oracle to help with form validation. It would be really >nice if I could set up my database and then have coldfusion >read the setup of my tables and perform its form validation >based on that.
Oracle stores this kind of info in pseudo tables called the data dictionary. A db user can get data abut "his" objects in tables like user_tables, user_tab_columns, user_constraints, etc. If you have the appropriate privs, you can also check all_tables, etc for any user's objects. .... but i would have to go with Jim's suggestion to use jdbc - more reusable across different db platforms. The data dictionary contains waaaay more info, but it's not stuff you need for form validation code. /t ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:218262 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
