SP's AND cfqueryparam?

2008-07-09 Thread Will Tomlinson
Are you safe just using stored procedures alone, or do you always need to couple them with cfqueryparam? Do you always cfqueryparam everything, no exceptions? Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most

Re: SP's AND cfqueryparam?

2008-07-09 Thread Eric Cobb
Do you always cfqueryparam everything, no exceptions? Yep! Are you safe just using stored procedures alone, or do you always need to couple them with cfqueryparam? If you're going to use stored procedures, use the cfstoredproc tag with cfprocparams. Thanks, Eric Will Tomlinson wrote:

Re: SP's AND cfqueryparam?

2008-07-09 Thread Ian Rutherford
cfprocparam takes the place of cfqueryparam in stored procedures. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j

Re: SP's AND cfqueryparam?

2008-07-09 Thread Dominic Watson
cfprocparam takes the place of cfqueryparam in stored procedures. Unless you are using regular cfquery like so (in which case, yes - always use cfqueryparam!): cfquery name=foo datasource=bar exec sp_myStoredProc cfqueryparam value=#foo# c. /cfquery Dominic -- Blog it up: