not quite the right list for this topic...but TOP is not so ubiquitous outside of MS SQL world, eh? No top in Oracle.
fyi http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001266.htm is probably the most detailed info that I know of on QofQ. DK On 8/3/06, Brad Wood <[EMAIL PROTECTED]> wrote: > > I've never understood why cfquery uses maxrows instead of the ubiquitous > "top" keyword. > > ~Brad > > -----Original Message----- > From: Ian Skinner [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 03, 2006 10:22 AM > To: CF-Talk > Subject: RE: QoQ SQL support. > > It would be very nice to have a complete feature list of SQL commands > and such that works with QoQ. > > And maybe a list of common SQL features that QoQ does NOT support at > least currently. I don't know how many times I have tried to do an > outer join in a QoQ before I remember it only supports inner joins. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/groups/CF-Talk/message.cfm/messageid:248765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
