On 10/24/2003 at 16:52, you wrote:
>>Not sure what database platform you're using, but see if you can
>>specify your row limit within your SQL (PostgreSQL uses the 'limit'
>>keyword) instead of using maxrows="n".
CC> I'm using MS Access.
I've always used CFQUERY's maxrows attribute with Access stuff...
never checked to see if there is a way to limit rows within the SQL.
Maybe it supports 'TOP n' like SQLServer?
Otherwise, maybe something like:
<cfscript> if(not testmode){maxrows=100000;}else{maxrows=5;} </cfscript>
<cfquery... maxrows="#maxrows#">
...
</cfquery>
~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]