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:345487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
