I am trying to write a query to select a trivia question, but I don't want
the trivia question category to be the same two days in a row so I added a
second SELECT syntax to find out what category was used yesterday. This
works when I test it live, but doesn't work when it is part of a cron
job.
How is the last mailing date variable set?
Have you tried printing out the queries that are run when it is run manually
and when it is run as a cron to find any differences?
-patrick
On Jul 11, 2010 8:23 AM, Ron Piggott ron.pigg...@actsministries.org
wrote:
I am trying to write a query to
I am trying to write a query to select a trivia question, but I don't want
the trivia question category to be the same two days in a row so I added a
second SELECT syntax to find out what category was used yesterday. This
works when I test it live, but doesn't work when it is part of a cron