>CF,
>
>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]
- Vars in CFMAIL and CFQUERY tags CF Coder2
- Re: Vars in CFMAIL and CFQUERY tags Ubqtous
- Re:Vars in CFMAIL and CFQUERY tags CF Coder2
- CF Coder2