CfStoredProc not displaying query results

I can fun the SP in SQL and it returns results fine. For some reason CfStoredProc is not working properly. Is my syntax incorrect?

<cfstoredproc procedure = "sp_CityStateSearch"
   dataSource = "REOS" debug="yes" returncode="yes">
   <cfprocresult name = "results">

   <cfprocparam type = "IN" CFSQLType = cf_sql_varchar
      value = "#FORM.CITY#" dbVarName = @City>
   
      <cfprocparam type = "IN" cfsqltype= cf_sql_varchar
         value = "#FORM.STATE#" dbVarName = @State>
     
</cfstoredproc>

<cfoutput>
#results.city#
</cfoutput>
lexoAsked:
Who is Participating?
 
erikTsomikConnect With a Mentor System Architect, CF programmer Commented:
That means that the SP got executed succesefully. So give me the code how do you output your SP
0
 
erikTsomikSystem Architect, CF programmer Commented:
check you log and see if the SP got executed
0
 
lexoAuthor Commented:
It's not running
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
erikTsomikSystem Architect, CF programmer Commented:
can you tell me exactly what the log says
0
 
lexoAuthor Commented:
I am using SQL Express so I dont have SQL Profiler.  Is there anything else I can get you to help?
0
 
erikTsomikSystem Architect, CF programmer Commented:
you need to check colfusionj log files.There you get info about the error
0
 
lexoAuthor Commented:
There is no error being returned. The page is just simply blank. There is no log of the event that is not happening in the CF log files.
0
 
lexoAuthor Commented:
You're right. It was being executed sucessfully. It was my stupid error, the variable were not in the correct order.
0
 
erikTsomikSystem Architect, CF programmer Commented:
tHANKS . Can you also post the correct order
0
All Courses

From novice to tech pro — start learning today.