Ah, I see. That makes sense, though it's not a CF issue, it is a JDBC issue. Another option would be for your dba to create an additional sp which calls the original sp and contains just the params that you need. Just a thought.
On Tue, Jun 21, 2011 at 11:43 AM, Ras Tafari <rastaf...@gmail.com> wrote: > > my dba needs me to be able to pass those in like that, so that he can > have parameters > that i may not use, that our .net guys are using. they have the > ability to do this, cf is lacking :( > > On Tue, Jun 21, 2011 at 11:42 AM, Dean Lawrence <dean...@gmail.com> wrote: >> >> 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 <rastaf...@gmail.com> 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:345491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm