> I'm confused about cfprocparam. (mx7pro) The documentation > states you have to specify them in order relative to the > stored proc. There is no way to bind them to the proc's > variable. However the debugging output generates a table > for each proc call and there is a column for dbVarName, > which makes me think that binding to a named parameter is > possible. Has anyone written a replacement cfstoredproc > tag? Can I use the underlying java to do this? Does anyone > have any good links for this. Mostly what i've found so far > just repeats that you must pass all db vars in order.
You must pass all db vars in order. Sorry, but I couldn't resist. You must, in fact, do so. The DBVARNAME attribute used to work prior to CFMX using some databases, but it doesn't work with CFMX and is there for backward compatibility - you can still have it, but it doesn't actually do anything I guess. I don't think you can do this from Java; I believe this is a limitation of either the database drivers or of JDBC itself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214211 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
