Thanks! This was what I had seen. Three things: It should allow more than 20 parameters. Those stock images with the people shot from the overhead view are a pet peeve of mine...they just scream late 90's :) Your wizard should be included in Studio by default (hear that Macr? :))...it's almost perfect for what it is.
However, I'm looking for more of a tool that will take the SQL, or connect to the data source directly and generate the cfstoredproc. It's the repetitive typing I'm trying to get around... I just wrote a little snippet to parse the SP varnames and datatypes after I posted though in case anyone wants for such a thing. <cfsavecontent variable="sp_text"> @web_order_reference_id char(20) ,@ord_program_id char(10) , etc... </cfsavecontent> <cfset dataTypeCFSQL = structNew()> <cfset dataTypeCFSQL.char = "CF_SQL_CHAR"> <cfset dataTypeCFSQL.varchar = "CF_SQL_CHAR"> <cfset dataTypeCFSQL.datetime = "CF_SQL_DATE"> <cfset dataTypeCFSQL.money = "CF_SQL_MONEY"> <cfset dataTypeCFSQL.int = "CF_SQL_INTEGER"> <cfloop list="#sp_text#" index="i"> <cfset dbvarname = mid( getToken(i,1),2, len(getToken(i,1)) )> <cfif getToken(i,2) CONTAINS "("> <cfset datatypeSQL = left(getToken(i,2), find("(", getToken(i,2)) - 1)> <cfelse> <cfset dataTypeSQL = getToken(i,2)> </cfif> <cfset dataType = dataTypeCFSQL[datatypeSQL]> <cfoutput> <cfprocparam type="In" dbvarname="#dbvarname#" value="" cfsqltype="#dataType#" null="No"><br> </cfoutput> </cfloop> -- jon mailto:[EMAIL PROTECTED] Thursday, December 26, 2002, 3:44:51 PM, you wrote: AC> You can get ours free of charge at http://www.ProductivityEnhancement.com. AC> It runs as a wizard within ColdFusion Studio. AC> Enjoy! :) AC> Respectfully, AC> Adam Phillip Churvis AC> Advanced Intensive ColdFusion MX Training AC> http://www.ColdFusionTraining.com AC> E-mail: [EMAIL PROTECTED] AC> Phone: 770-446-8866 AC> Team Macromedia Volunteer for ColdFusion AC> http://www.macromedia.com/support/forums/team_macromedia/ AC> ----- Original Message ----- AC> From: "jon hall" <[EMAIL PROTECTED]> AC> To: "CF-Talk" <[EMAIL PROTECTED]> AC> Sent: Thursday, December 26, 2002 3:02 PM AC> Subject: cfstoredproc code generator >> Does a free one of these exist? I faintly remember the topic coming >> up in the past, but my searches are coming up empty. >> >> I did find this one for $99. >> http://www.netwebapps.com/Products/speedDB/introduction.cfm >> >> -- >> jon >> mailto:[EMAIL PROTECTED] >> >> AC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm