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 On Tue, Jun 21, 2011 at 11:19 AM, Dean Lawrence <dean...@gmail.com> wrote: > > If you look at the history portion of the docs > (http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_14.html#1102102) > it states "Changed the dbvarname attribute behavior: it is now ignored > for all drivers. ColdFusion uses JDBC 2.2 and does not support named > parameters". You need to pass the procparams in the the order that > they are defined in the stored proc. > > On Tue, Jun 21, 2011 at 10:53 AM, Russ Michaels <r...@michaels.me.uk> wrote: >> >> sorry, its a poorly constructed question.. >> are you referring to passing parameters on the cfstoredproc tag? >> >> then see this >> >> http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:49286 >> >> >> >> >> On Tue, Jun 21, 2011 at 3:15 PM, Ras Tafari <rastaf...@gmail.com> wrote: >> >>> >>> wow, thanks. i had no idea :) >>> >>> lol, the subject was more indicative of what my question was... >>> >>> whats up with dbvarname and named parameters in cf8/9? >>> >>> doesnt seem to work (out of the box)... is there a work around? >>> >>> tw >>> >>> On Tue, Jun 21, 2011 at 10:09 AM, Russ Michaels <r...@michaels.me.uk> >>> wrote: >>> > >>> > Hi, >>> > >>> > MSSQL 2000 does indeed support stored procedures. >>> > >>> > Russ >>> > >>> > On Tue, Jun 21, 2011 at 2:54 PM, Tony <tonyw...@gmail.com> wrote: >>> > >>> >> >>> >> hi guys and gals. >>> >> >>> >> what experience if any does anyone have with this and sql server 2000? >>> >> it would really help if this worked with sprocs. >>> >> >>> >> thanks! >>> >> tony >>> >> >>> >> Tony Weeg >>> >> Sr. Web Applications Architect & Developer >>> >> Navtrak, Inc. >>> >> Smart Companies Drive Navtrak >>> >> www.navtrakgps.com >>> >> 800.787.2337 >>> >> >>> >> >>> > >>> > >>> >>> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:345488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm