If you call the line: #importQuery[ "email" ] [ 1 ]#
Right above that query of queries, does it recognize the email column? ....................... Ben Nadel www.bennadel.com -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 9:13 AM To: CF-Talk Subject: QoQ oddity I am getting a strange error when trying to use QoQ on a large dataset that is in the memory (30,000 rows). Here is the code that breaks (simplified): <cfquery name="getEmails" dbtype="query"> SELECT DISTINCT email FROM importQuery; </cfquery> This gives: The select column reference [email] is not in the column list of any of the table in the FROM table list. However, when I output from #importQuery.columnList#, email is definitely there. I have tried using "SELECT DISTINCT [email]", "SELECT DISTINCT 'email'"... uppercase, lowercase, everything... but still nothing. This ONLY seems to happen with a large query. Has anyone ever come across anything like this... or is anyone even aware of problems using large datasets with QoQ? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246409 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
