RE: cfset/cfstoredproc

2002-03-29 Thread Janine Jakim
-Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:48 PM To: CF-Talk Subject: RE: cfset/cfstoredproc Janine, I don't think I'm following your example. What's wrong with the second example? also, why do you need 2 queries? Why

cfset/cfstoredproc

2002-03-28 Thread Janine Jakim
This is somewhat of a repost from the other day but haven't gotten any feedback- since I don't think I worded my problem very well. I am moving some of my work from cfquery to storedprocedures- the problem is the formatting when I use cfset with a stored procedures- they don't react the same way

RE: cfset/cfstoredproc

2002-03-28 Thread Mark A. Kruger - CFG
Janine, I don't think I'm following your example. What's wrong with the second example? also, why do you need 2 queries? Why not a join? a join would give you columns of name , answer name, answer, name, answer name, answer ORder by name and make sure there is a PK ... then do this: cfoutput