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
