Home > IT Answers > Development > re-writting a cfprocresult froma stored procedure as a regular query type thing
Andy11983
0 pts.
 re-writting a cfprocresult froma stored procedure as a regular query type thing
ColdFusion
Hi, I was wondering if someone can help me.I have the following bit of code :: CODE :: <cfprocresult name="getparams" resultset="1"> <cfprocresult name="getsites" resultset="2"> <cfprocresult name="getClassified" resultset="3"> <cfprocresult name="getUnClassified" resultset="4"> <cfprocresult name="getDeleted" resultset="5"> </cfstoredproc> :: END CODE :: I need to re-write this using queries as we are abdoning using "stored procedures" Thie querys "getClassifed", "getUnclassifed", "getDeleted","getSites", "getParams" are in anothe cf file called .templateswithactions.cfm. So my question is how do i re-write the result set so i dont use it in store procedures. Appreciate any and all help. Thanks Andy

Software/Hardware used:
ASKED: May 17, 2005  4:47 AM
UPDATED: May 17, 2005  7:15 AM
RELATED QUESTIONS
Answer Wiki:
rewrite the result set? as i understand it, since you won't be using stored procedures, simply remove the entire CFSTOREDPROC tag and replace it with 5 CFQUERY tags, the contents of which you will have to reverse-engineer from the stored proc source code
Last Wiki Answer Submitted:  May 17, 2005  7:15 am  by    0 pts.
All Answer Wiki Contributors:    0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _