There may be another way, but I know you can get field types, etc. from the ALL_TAB_COLUMNS table.
SELECT column_name,data_length,data_type,nullable FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'MYTABLE' You could use that information to build some validation based on the values returned. Dave -----Original Message----- From: Mike Soultanian [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 14, 2005 12:19 PM To: CF-Talk Subject: form validation utilizing database field types/sizes/etc 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? Thanks, Mike ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:218258 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
