cfprocparam

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. TIA Anthony

----- Excess quoted text cut - see Original Post for more ----- 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!

ugh... and it doesn't even pass the dbvarname parameter to the table generated in the debugging output. ----- Excess quoted text cut - see Original Post for more -----