On 9/14/05, Mike Soultanian <[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. > > I did some research on this and it seems like SQL server supports a > standard format using INFORMATION_SCHEMA to return the column types and > sizes and what not. Is there some way to pull similar information from > oracle so I can use that for form validation purposes? >
Yep. Look into using the USER_* tables (specifically, USER_TABLES and USER_TAB_COLS). You can simply query those tables to get everything you need. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218334 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
