I have been using a CFMAIL tag with a query results set.I specify the TO field to be the var representing the column in the db containing the email address.That works fine.
Now I want to create a testMode state for testing and want to change the TO field based on if I'm in TestMode or not.
What
CF,
On 10/24/2003 at 14:53, you wrote:
CC I have been using a CFMAIL tag with a query results set.I
CC specify the TO field to be the var representing the column in the
CC db containing the email address. That works fine.
CC Now I want to create a testMode state for testing and want to
CC
CF,
On 10/24/2003 at 14:53, you wrote:
...
How about doing your test mode switching in your SQL:
cfquery...
select cfif not testmodedbcolumnnamecfelse'[EMAIL PROTECTED]' as dbcolumnname/cfif
...
cfif testmodelimit n/cfif;
/cfquery
Thanks!This looks like the answer. Now why didn't I think of
CF,
On 10/24/2003 at 14:53, you wrote:
...
How about doing your test mode switching in your SQL:
cfquery...
select cfif not testmodedbcolumnnamecfelse'[EMAIL PROTECTED]' as dbcolumnname/cfif
...
cfif testmodelimit n/cfif;
/cfquery
Thanks!This looks like the answer. Now why didn't I think of
CF,
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
I am writing a small script to send out a newsletter. The recipients email
address are stored in a database. I would like to create a loop that would
send let's send 50 emails, pause for a few seconds and then send the next 50
in the database. Is this possible?
thanks,
Luis
Coldfusion sent out an email to a completely different email address than
it
was supposed to. It definitely seems like some sort of logic problem or sql
statement problem, but I have
gone through the code over over and even set up a testing environment with
the exact same code and database
7 matches
Mail list logo