>
>On 10/24/2003 at 14:53, you wrote:
>...
>
>How about doing your test mode switching in your SQL:
>
><cfquery...>
>select <cfif not testmode>dbcolumnname<cfelse>'[EMAIL PROTECTED]' as dbcolumnname</cfif>
>...
><cfif testmode>limit n</cfif>;
></cfquery>
Thanks! This looks like the answer. Now why didn't I think of that?
>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".
I'm using MS Access.
CFCODER2
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]