Re: [cfaussie] Query of Query question

You can but you need to escape local ie select * from [local].d Paul. On Mon, Jul 18, 2011 at 4:38 PM, Steve Onnis st...@cfcentral.com.au wrote: Can you not do a QofQ on a LOCAL variable? ** ** I tried to do this ** ** cfquery dbtype=query name=LOCAL.d

RE: [cfaussie] Query of Query question

Is LOCAL a reserved word or something? From: Paul Kukiel [mailto:kuki...@gmail.com] Sent: Monday, 18 July 2011 4:42 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Query of Query question You can but you need to escape local ie select * from [local].d Paul. On Mon, Jul

Re: [cfaussie] Query of Query question

...@cfcentral.com.au wrote: Is LOCAL a reserved word or something? ** ** *From:* Paul Kukiel [mailto:kuki...@gmail.com] *Sent:* Monday, 18 July 2011 4:42 PM *To:* cfaussie@googlegroups.com *Subject:* Re: [cfaussie] Query of Query question ** ** You can but you need to escape local ie