Thanks all. That is what I thought... -----Original Message----- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 3:34 PM To: CF-Talk Subject: RE: QofQ and SQL TOP statements...
Che, TOP is T-SQL specific I believe. You would need to use it in your SQL query (to the Db) then use Q of Q of to join 1 or more queries together. If what you are trying to do is combine 2 queries on the DB - consider "UNION".... -Mark -----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 2:32 PM To: CF-Talk Subject: QofQ and SQL TOP statements... QofQ and SQL TOP statements... can these be used together? If so, how? I keep getting an error that looks like this: Query Of Queries syntax error. Encountered "(. Incorrect Select Statement, Expecting a 'FROM', but encountered '(' instead, A select statement should have a 'FROM' construct. Thanks, Che ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
