Folks, I'm playing with some query metadata work and just want to verify that I'm not crazy. If you take a query and do a getMetadata() function on it, you get back an object of this type:
coldfusion.sql.QueryTableMetaData which, among it's many methods, has some like this isAutoIncrement (returns boolean) isCaseSensitive (returns boolean) isCurrency (returns boolean) isDefinitelyWritable (returns boolean) isNullable (returns int) isReadOnly (returns boolean) isSearchable (returns boolean) isSigned (returns boolean) isTypeKnown (returns boolean) isWritable (returns boolean) of which the isNullable is of most interest to me. It seems as if these functions are just simply broken, which makes sense considering the small amount of column metadata returned by query.getMetadata() -- just the name, type, and case-sensitivity. I found a reference to a bug filed about this time last year http://www.mail-archive.com/[email protected]/msg07288.html Am I doing something wrong (could be, been doing Java and Ruby more frequenly as of late)? Or is there no simple way to get the nullability of a db column from the metadata? For the record, CFMX 7.0.1, dev edition and MySQL 4.1 -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:221777 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
