Anyone remember this article? http://coldfusion.sys-con.com/node/45569
Lets you drop down into Java and pull out the field types that your db reports back to the JDBC driver. Its neat on the surface, but too expensive on resources to use on the fly. Plus you have to put the for-real username and password directly into the template... Using vars doesn't work. Still, I like to use it during development if I have a monster query that I need to write up. Saves me the need to look back and forth from screen to screen to determine what the next cfsqltype is in my query list. Or stick it in front of a custom tag that writes the sql and cfqueryparams for you <!--- <cfmodule template="create_record.cfm" dbUserName="#attributes.DBUserName#" dbPassword="#attributes.DBPassword#" DSN="#attributes.DSN#" tableName="woof" fieldList="arf,bark,ruff,meow" SQLTypeList="CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_VARCHAR" valueList="how,now,brown,cow"> ---> <cfquery username="#attributes.DBUserName#" password="#attributes.DBPassword#" datasource="#attributes.DSN#"> INSERT INTO #attributes.tableName# ( #attributes.fieldList# ) VALUES ( <cfloop list="#attributes.fieldList#" index="FieldValue"> <cfset variables.LoopCounter=ListFindNoCase(attributes.fieldList,FieldValue)> <cfqueryparam cfsqltype="#ListGetAt(attributes.SQLTypeList,variables.LoopCounter)#" value="#ListGetAt(attributes.valueList,variables.LoopCounter)#" null="#YesNoFormat(not Len(ListGetAt(attributes.valueList,variables.LoopCounter)))#"> <cfif compareNoCase(ListLast(attributes.fieldList),FieldValue)>,</cfif> </cfloop> ) </cfquery> -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4