You should be able to just query the DB using sp_help <your stored proc name> and the second result will be the input params/params of that SP
-----Original Message----- From: Kenton Gray To: CF-Talk Sent: 11/03/2005 18:06 Subject: Get needed parameters for stored procedure dynamically I'm currently looking at how to do some cfc code generation to reduce some repetitive tasks (http://www.mail-archive.com/[email protected]/msg211154.html) Right now I'm looking at stored procedures and i'd like a way to tell coldfusion the name of the stored procedure and "look" at it, and figure out what parameters it requires. Then output a cffunction with the storedproc calls and storedprocparams generated automagically. I looked over all the coldfusion stored procedure tags and I didn't see any match so I'm thinking maybe I need to look at a specific sql syntax? Anyone have any idea how to set me in the right direction? I also thought perhaps I could get info from this http://www.cfczone.org/blogs/rob/index.cfm?mode=entry&entry=3FB9FD57 -9D37-D68F-D9C0C54B86B24E08 but it doesn't seem to hold any value for what I need. Any ideas? Kenton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
