Skip to main content
A
Anonymous
April 21, 2013
Question

how to loop through queries for different time zones

  • April 21, 2013
  • 2 replies
  • 984 views

I am working on a script that will send out daily messages to an individual who has subscribed to a particular company’s daily message.

The subscribers table has:

  • Firstname
  • Email
  • Company ID
    Delivery method
    • Desktop
    • Phone  

I have set up a query that pulls the subscribers information to:

  1. Determine which business
    1. Which layout to use (contact_id)
    2. Determines time zone
      1. Phones will be sent at a later time than the desktop
  2. Which version to send:
    1. Desktop with all graphics
    2. Phone with graphics removed

                               

I can use a cfloop to send the message out every morning, I just don’t know how to efficiently send out the message by the different time zones.

Each time zone will have 2 diff times:

  1. 5:00am for the desktop
  2. 8:00am for the phones

Any suggestions would be helpful.

    This topic has been closed for replies.

    2 replies

    M
    meensi
    Inspiring
    April 22, 2013

    You can schedule a job for each time zone..

    A
    Anonymous
    April 22, 2013

    Thanks Dan and Meensi for replying. I thought of doing something like this, I was afraid that scheduling 8 jobs over 4 hours may tax the server. It's not like I have a lot of emails to send out yet, I don't want to have to update the script too often.

    D
    Dan_Bracuk
    Inspiring
    April 21, 2013

    Schedule your job for every possible hours and send the appropriate emails each time.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices