3 Replies Latest reply on Apr 22, 2013 2:34 AM by rickaclark54

    how to loop through queries for different time zones

    rickaclark54

      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.