> But in order to do that I have to be able to find all the properties on a field but simply looping through the sysobjects table in SQL Server, and then dynamically scripting out each table...
yep i'm doing it the easy way and using the MS SQL server tables... sigh, maybe i'll update this later to include MySQL or figure out a java or CFQuery meta data solution works.. SELECT cast(syscolumns.name as varchar(25)) as field,cast(systypes.name as varchar(20)) as type,syscolumns.length FROM syscolumns,systypes WHERE id = (select id from sysobjects where name='#this.table#') and syscolumns.xtype = systypes.xtype ## ## ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
