Sounds awesome ;) So in theory, CF could use Hibernate (when it releases that stuff in 9) to automatically parametise a query, with no extra work from the developer, ie. the developer just writes:
<cfquery name="myQuery" datasource="myDs"> SELECT foo FROM bar WHERE foobar = 4570 </cfquery> .... and cf then parses the query to see what are paramatisable values, then queries Hibernate with the column, table and datasource info to get the datatype for each param. Come to think of it, by that point it should be easy enough for CF to figure out the datatypes by itself but perhaps Hibernate could help with all this somewhere. Anyways, I'm not all that fussed by this being a possibility, just humouring an idea. Do you think this would be possible without any extra configuration from the dev? Can't wait to try your port of Hibernate for CF :) Dominic ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

