dbvarname is blank in the debugging area

Forum|Forum|19 years ago
January 26, 2007
2 replies
430 views

I've supplied a dbvarname in my CFPROCPARAM tag, but when it shows the stored proc in the debugging it never shows the dbvarname. It shows type, cfsqltype, and value, but variable and dbvarname are always blank.

This topic has been closed for replies.

P

paross1

Participating Frequently

What's up with this sight the last few days? Dang duplicate posts, etc.

P

paross1

Participating Frequently

You didn't specify CF version, but dbvarname hasn't been used since CF 5....

cfprocparam tag

ColdFusion MX:
....dbvarname attribute behavior: it is now ignored for all drivers. ColdFusion MX uses JDBC 2.2 and does not support named parameters.

Phil

K

kslaneAuthor

Participant

Sorry about that. It's 7.0.2

That's the beauty of it. We can use dbvarname now. There was a recent hotfix that re-implements dbvarname. Now I don't have to specify ALL the params in the exact order the proc requires them. I can use dbvarname (like we used to be able to do in CF5) to just pass the params I need to pass.

It's great because we have a big nasty proc that gets used everywhere. In all the places it's used, there are only a few params that are needed, but we had to supply ALL of them. Then when our DB guy created a new param, we had to add it to all our code. THANKS to the CF gods for bringing dbvarname back!

P

paross1

Participating Frequently

Cool, didn't hear about the hotfix. (As usual, livedocs are last to be updated.) Looks like they neglected to add this parameter as being viewable from debug as well.... Hey, at least you got the fix, right?

Phil

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded