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:346524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
