Ras, I don't understand why you would abandon your stored procs. All you need to do is remove the dbvarname attribute and pass the cfprocparam tags in the order that the parameters are defined in the stored proc itself and it works. As for the change in status, if you look at the history comment, it is the JDBC drive that no longer supports named parameters, not just a random decision to stop supporting them.
On Tue, Jun 21, 2011 at 11:24 AM, Ras Tafari <[email protected]> wrote: > > i know, i checked that too, this was my last hope... i did say "work-around" > :( > > all good, not using cfstoredproc anymore, we are just going to use straight > sql. > > i wonder why this was put to "no longer supported" status > -- --------------------------------------------------------------------------- Dean M. Lawrence INTERNET DATA TECHNOLOGY p // 888.438.4381 ext. 701 w // www.idatatech.com f // www.facebook.com/idatatech t // www.twitter.com/idatatech Social Marketing | SEO | Design | Internet Development ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

