> Do all JDBC drivers ignore @dbvarname?
Yes.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training center
> 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.
Pass in nulls or defaults for those values.
> they have the ability to do this, cf is lacking :(
This is a Java thing, not a CF thing. JDBC simply doesn't
o: cf-talk
Subject: Re: dbvarname mssql cf8?
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
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 wrote:
>
> my dba need
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 wrote:
>
> Ras, I don't understand why you would abandon you
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,
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 wrote:
>
> If you look at t
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 pr
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 wrote:
>
> wow, thanks. i had no idea :)
>
> lol, the
I have been using stored procs with SQL 2000 for many years on CF
versions 5-9. dbvarnames are ignored in the java versions of
ColdFusion. If you pass all the procparams to the stored procedure in
the order that they are defined int the stored proc, it works fine.
Dean
On Tue, Jun 21, 2011 at 10
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 wrote:
>
> Hi,
>
> MSSQL 200
Hi,
MSSQL 2000 does indeed support stored procedures.
Russ
On Tue, Jun 21, 2011 at 2:54 PM, Tony 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. We
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
~~
13 matches
Mail list logo