Adrian, Yeah, if I change it from LOCAL to LOCAL2 it seems to work just fine. It seems odd that this would be a reserved word in QofQ. I do not see it anywhere in the documentation. Well, a slight nuisance, but nothing to get my panties in a bunch over.
Thanks for the help. ....................... Ben Nadel Web Developer Nylon Technology 350 7th Ave. Suite 1005 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Sanders: Lightspeed too slow? Helmet: Yes we'll have to go right to ludacris speed. -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 4:35 PM To: CF-Talk Subject: RE: Q of Q oddity Local is probably a reserved word. It turns blue in query analyser. Try using a different name for your struct and see if that fixes it. Adrian -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 09 February 2006 21:30 To: CF-Talk Subject: Q of Q oddity Hey all, so I am trying to do a query or queries and am getting a very odd behavior. I have an email bean (EmailBean) that has a query of attachments (FilePath, DeleteAfterSending). After I send out an email (based on the email bean) I query for files I have to delete: <cfset var LOCAL = StructNew() /> <cfse LOCAL.Attachments = ARGUMENTS.EmailBean.GetAttachments() /> <cfquery name="LOCAL.OldFileQuery" dbtype="query"> SELECT * FROM LOCAL.Attachments WHERE DeleteAfterSending = 1 </cfquery> This throws an error when it parses "FROM LOCAL" in the SQL statement. However, I have done a thousand query of queries this way and it works. The only difference is that I am usually using a passed argument instead of a local variable. So I tried a tweak: <cfset var LOCAL = StructNew() /> <cfse LOCAL.Attachments = ARGUMENTS.EmailBean.GetAttachments() /> <cfset ARGUMENTS.Attachments = LOCAL.Attachments /> <!--- NEW LINE ---> <cfquery name="LOCAL.OldFileQuery" dbtype="query"> SELECT * FROM ARGUMENTS.Attachments WHERE DeleteAfterSending = 1 </cfquery> As you can see above, I am merely setting an arguments variable to the LOCAL attachment value. And guess what? This parses fine and works as expected. What is going on here? Why would ARGUMENTS scope work but not the LOCAL "pseudo" scope within the UDF? Its this crazy or is it just me? Thanks, ......................... Ben Nadel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231840 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
