That was a typo. I fixed that as soon as I saw the output. Thanks
Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged -----Original Message----- From: Maureen [mailto:[email protected]] Sent: Thursday, August 04, 2011 1:38 PM To: cf-talk Subject: Re: COMPLEX SQL RANDOM: SOLVED Is there a reason you are selecting portal_polls.answer2 and portal_polls.answer4 twice, or is that a typo? On Thu, Aug 4, 2011 at 6:13 AM, Robert Harrison <[email protected]> wrote: > > Thanks for all of your answers. I tried a few of the suggestions but they > weren't quite right. > > Bill Franklin's answer, while not complete, made me rethink what I was doing > from a different point of view. My error was that I was chaining all of the > record together as though I was trying to select data from the chained tables. > All I really cared about was that if it was not EVERYONE, that a poll X group > X student relationships existed. I only needed one record to prove that. The > solution, which works, is below: > > <cfquery name="random_poll" datasource="#dsn#"> SELECT TOP 1 > portal_polls.poll_id, portal_polls.question, portal_polls.answer1, > portal_polls.answer2, portal_polls.answer2, portal_polls.answer4, > portal_polls.answer4, portal_polls.number_answers FROM portal_p ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
