http://wikipedlla.com/query_of_query_and_top > Hi, > Just wondering if there was an equivalent of top n that could be used > in a query-of-query. > When I used top 10, i received an error, so I used > the maxrows attribute instead to restrict the values. just wondering if I > have done the correct thing > eg > <CFQUERY > datasource="testdatasource_local" name="TEST"> > > SELECT > TOP 1000 > > * > FROM > > test_table > </CFQUERY> > <cfquery name="test2" > dbtype="QUERY" maxrows="10"> > > select > > * > from > > TEST > </cfquery> > Thanks, > Scott > Thornton, Programmer > Billing Unit > Hunter-New England Area Health > Service > ext: 24505 p: +61 02 4941 4505 m: 0413 800 242 >
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
