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

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