|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
i have the following ...
<cfquery datasource="#request.dsn#" name="qcheckforEncCCNum"> DECLARE @rC int EXEC Check_Paym_For_Dup @ccNum = <cfqueryparam cfsqltype="cf_sql_varchar" value="#request.params.liteEncryptCCNum#">, @recCount = @rC OUTPUT SELECT IsNull(@rc, 0) AS rCount </cfquery> when i do <cfif qcheckforEncCCNum.rCount GT 0> ... </cfif> i receive variable rCount is not defined. the query calls a stored proc which has an output var called @recCount which is either 1 or 0. why doesn't CF not like this? thanks for the help in advance |
|
#2
|
|||
|
|||
|
You can't declare a T/SQL block within cfquery like that. You'll have to move all that into a T/SQL procedure and call it using EXEC or using the <cfstoredproc> tag.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > why it won't work? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|