I use some of these tables for a CFC that handles my insert/update/delete SQL statements.
On 9/14/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote: > > >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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218268 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
