We've been thinking about making such a stored procedure generator as either a standalone utility or an add-on to our DatabaseBlocks product (version 3 of which is about to go into Alpha to a select group of dedicated testers).
It wouldn't be free, but it would do virtually all the work for you; just point to the stored procedure and change any default attributes you want to tweak, and the calling code would be generated for you, along with shells for the CFOUTPUT of each result set and OUTPUT parameter returned from the procedure. It would also still allow the same approach as our current Stored Procedure Wizard for those who want to start with the prototype shells for the CF call and the procedure interface and then add the logic later on. The reason why the current Stored Procedure Wizard allows only 20 parameters is because of the limitations of VTML and WIZML, which don't enable programming infinite loops and which choke and puke when parsing too much script. Anyway, I hope the current Stored Procedure Wizard serves you well. Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ ----- Original Message ----- From: "jon hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 26, 2002 4:39 PM Subject: Re: cfstoredproc code generator > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
