> > 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
That's the direction I'm heading too, but I've scrapped it for now (bigger fish and all that). As for the meta data solution, it's entirely broken in CFMX. Jim Schley (and another CF engineer) I talked to took a look at the CF source code, and many of the "is" methods don't even call the java methods necessary to get the information. They just return an error, end of story... They filed a bug on it, and I'm hoping it gets fixed for Blackstone so I can actually use them :). The hooks are there, but whatever engineer was working on that part of it just never finished the job. Dan ---------------------------------------------------------- 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]
