LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-pc9.htm

coldfusion/6.1/htmldocs/tags-pc9.htm

codyfox — 2005-10-05T09:47:30

What I am finding hard to believe is that there was a logical reason for changing this and not changing the documentation anywhere except at the bottom of this page. Even the Coldfusion help files on Dreamweaver 8 have the old examples of using the tag. The error that is generated from SQL server is obscure and nearly impossible to debug. This should not be changed at a further date, this should be changed now!

coldfusion/6.1/htmldocs/tags-pc9.htm

jrunrandy — 2004-11-04T13:44:34

Arguments are positional without dbvarname.

If you pass the first, second, third, etc. arguments (with cfprocparam) in the correct order - they will match the stored procedure.

With CF5 & dbvarname, you could pass arguments out of order if you wanted to.

For example:

A stored procedure takes 3 arguments: NAME, ADDRESS, ZIP

With CFMX you must pass these arguments in the same order - NAME, ADDRESS, ZIP.

With CF5 you could pass the zip code first if you wanted to.

coldfusion/6.1/htmldocs/tags-pc9.htm

PaulArbouw — 2004-11-04T11:53:28

since dbvarname no longer works.. how do I tell the stored procedure what the value is of the variables that it uses?

coldfusion/6.1/htmldocs/tags-pc9.htm

jrunrandy — 2004-04-30T11:04:51

Good catch. We'll fix this in the next CF rev. Thanks.

coldfusion/6.1/htmldocs/tags-pc9.htm

wyntermoonwolf — 2004-04-30T10:54:19

The documentation for cfprocparam states:
Changed the dbvarname attribute behavior: it is now ignored for all drivers. ColdFusion MX uses JDBC 2.2 and does not support named parameters.

The example should be modified not to use it. The example given came from the CF5 docs.