ugh... and it doesn't even pass the dbvarname parameter to the table generated in the debugging output.
On 8/9/05, Dave Watts <[EMAIL PROTECTED]> wrote: > > 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:214220 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
