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
-~----------~----~----~----~------~----~------~--~---
