Skip navigation
goodychurro1
goodychurro1
Currently Being Moderated

How can I loop instead of hardcoding this info

Jun 17, 2012 8:28 PM

Hi all

I have the following code, how can I cfloop and dynamically output this info instead of having to have each meeting time? Thanks

 

<cfselect name="MEETINGTIME" width="90" label="Time"onchange="UsersGrid.dataProvider.editField(UsersGrid.sele ctedIndex, 'MEETINGTIME', MEETINGTIME.selectedItem.data);">

                        <option value="None">None</OPTION>

                            <option value="05:30 AM">05:30 AM</option>

                            <option value="06:00 AM">06:00 AM</option>

                            <option value="06:30 AM">06:30 AM</option>

                            <option value="07:00 AM">07:00 AM</option>

                            <option value="07:30 AM">07:30 AM</option>

                            <option value="08:00 AM">08:00 AM</option>

                            <option value="08:30 AM">08:30 AM</option>

                            <option value="09:00 AM">09:00 AM</option>

                            <option value="09:30 AM">09:30 AM</option>

                            <option value="10:00 AM">10:00 AM</option>

                            <option value="10:30 AM">10:30 AM</option>

                            <option value="11:00 AM">11:00 AM</option>

                            <option value="11:30 AM">11:30 AM</option>

                            <option value="12:00 AM">12:00 AM</option>

                            <option value="12:30 AM">12:30 AM</option>

                            <option value="01:00 AM">01:00 AM</option>

                            <option value="12:00 PM">12:00 PM</option>

                            <option value="12:30 PM">12:30 PM</option>

                            <option value="01:00 PM">01:00 PM</option>

                            <option value="01:30 PM">01:30 PM</option>

                            <option value="02:00 PM">02:00 PM</option>

                            <option value="02:30 PM">02:30 PM</option>

                            <option value="03:00 PM">03:00 PM</option>

                            <option value="03:30 PM">03:30 PM</option>

                            <option value="04:00 PM">04:00 PM</option>

                            <option value="04:30 PM">04:30 PM</option>

                            <option value="05:00 PM">05:00 PM</option>

                            <option value="05:30 PM">05:30 PM</option>

                            <option value="06:00 PM">06:00 PM</option>

                            <option value="06:30 PM">06:30 PM</option>

                            <option value="07:00 PM">07:00 PM</option>

                            <option value="07:30 PM">07:30 PM</option>

                            <option value="08:00 PM">08:00 PM</option>

                            <option value="08:30 PM">08:30 PM</option>

                            <option value="09:00 PM">09:00 PM</option>

                            <option value="09:30 PM">09:30 PM</option>

                            <option value="10:00 PM">10:00 PM</option>

                            <option value="10:30 PM">10:30 PM</option>

                            <option value="11:00 PM">11:00 PM</option>

                            <option value="11:30 PM">11:30 PM</option>

                          </cfselect>

913 Views   10 Replies   Latest reply: goodychurro1, Jun 25, 2012 3:57 PM
 
Replies
  • Dan Bracuk
    Currently Being Moderated
    1. Dan Bracuk,
    Jun 18, 2012 4:40 AM   in reply to goodychurro1
    Report

    Use cfloop condition = "YourDateTime lte #MaxDateTime#"

     

    inside your loop use DateAdd to increment YourDateTime and use TimeFormat to display it.

     
    |
    Mark as:
  • goodychurro1
    Currently Being Moderated
    2. goodychurro1,
    Jun 24, 2012 7:44 PM   in reply to Dan Bracuk
    Report

    Like this Dan? Thanks

     

    <cfset YourDateTime = "7:30AM">
    <cfset MaxDateTime = "11:30PM">

    <cfloop condition = "YourDateTime lte #MaxDateTime#">
    #timeFormat(dateAdd('n', 30, YourDateTime),'hh:mm:ss tt')#
    </cfloop>

     
    |
    Mark as:
  • Dan Bracuk
    Currently Being Moderated
    3. Dan Bracuk,
    Jun 25, 2012 5:17 AM   in reply to goodychurro1
    Report

    Did it work when you ran it?

     
    |
    Mark as:
  • goodychurro1
    Currently Being Moderated
    4. goodychurro1,
    Jun 25, 2012 8:20 AM   in reply to Dan Bracuk
    Report

    When I add the code I get a nasty screen of death, when I take it away the error goes. Error:

     

    IIS 7.5 Detailed Error

     

    HTTP Error 500.0 - Java heap space
    The page cannot be displayed because an internal server error has occurred.

     
    |
    Mark as:
  • Dan Bracuk
    Currently Being Moderated
    5. Dan Bracuk,
    Jun 25, 2012 9:33 AM   in reply to goodychurro1
    Report

    That's probably because you have an infinite loop.   Also, you are setting your two variables to strings instead of datetime objects.  This might cause unexpected results.

     
    |
    Mark as:
  • -==cfSearching==-
    Currently Being Moderated
    6. -==cfSearching==-,
    Jun 25, 2012 11:06 AM   in reply to goodychurro1
    Report

    goodychurro1 wrote:

     

    #timeFormat(dateAdd('n', 30, YourDateTime),'hh:mm:ss tt')#

     

    That does not change the value of the #YourDateTime# variable. So the loop just runs until it crashes because

    the value of #YourDateTime# is always less than 11:30PM.  You need to increment the value on each loop and assign the new value to #YourDateTime#.

     

            <cfloop ....>

                    ...

                    <cfset YourDateTime = dateAdd('n', 30, YourDateTime)>

            </cfloop>

     
    |
    Mark as:
  • goodychurro1
    Currently Being Moderated
    7. goodychurro1,
    Jun 25, 2012 2:35 PM   in reply to Dan Bracuk
    Report

    Hi Dan, thanks I tried this it is almost working, I get all the times in half hour intervals from 8 - 5.30 but in the wrong date!! {ts '1899-12-30 08:00:00'}

     

    <cfset YourDateTime = "7:30AM">
    <cfset MaxDateTime = "11:30PM">

    <cfset startweek_dt = TimeFormat(YourDateTime, "hh:mm") >
    <cfloop index="ii" from="1" to="20">
      <cfset startweek_dt = DateAdd('n',30, startweek_dt)>
      <cfoutput>#startweek_dt#</cfoutput><br>
      </cfloop>

     
    |
    Mark as:
  • goodychurro1
    Currently Being Moderated
    8. goodychurro1,
    Jun 25, 2012 2:38 PM   in reply to -==cfSearching==-
    Report

    Thanks cfsearching, I don't understand where I use YourDateTime variable if it is inside the cfloop, I tried using the variable in the to and from parts of cfloop but I kept getting errors

     

    <cfset YourDateTime = "7:30AM">
    <cfset MaxDateTime = "11:30PM">

    <cfloop condition = "YourDateTime lte #MaxDateTime#" >
    #timeFormat(dateAdd('n', 30, YourDateTime),'hh:mm:ss tt')#
    <cfset YourDateTime = dateAdd('n', 30, YourDateTime)>
    </cfloop>

     
    |
    Mark as:
  • -==cfSearching==-
    Currently Being Moderated
    9. -==cfSearching==-,
    Jun 25, 2012 4:21 PM   in reply to goodychurro1
    Report

    I get all the times in half hour intervals from 8 - 5.30 but in the wrong date!! {ts '1899-12-30 08:00:00'}

     

    It is not the wrong date.  Since you only specified a time (ie "07:30AM") the "date" portion defaults to 0 or 12/30/1899 .  If you needed a specific time and date, you must specify it when creating the variables. For example:

     

          <cfset YourDateTime = createDateTime(2012, 6, 25, 7, 30, 0)> ... or

          <cfset YourDateTime = parseDateTime("2012-06-25 07:30AM")>

     

    BUT .. in your case it does not make a difference because you are not using the date for anything. So just use timeFormat() to display the time only.

     

         ie     #timeFormat( yourVariableName,  'hh:mm:ss tt')#

     
    |
    Mark as:
  • goodychurro1
    Currently Being Moderated
    10. goodychurro1,
    Jun 25, 2012 3:57 PM   in reply to goodychurro1
    Report

    Thanks cfsearching, this code works great for outputting the times:

     

    <cfset YourDateTime = "7:00AM">

    <cfset startweek_dt = #timeFormat( YourDateTime,  'hh:mm tt')# >
    <cfloop index="ii" from="1" to="23">
      <cfset startweek_dt = DateAdd('n',30, startweek_dt)>
      <cfoutput>#timeFormat( startweek_dt,  'hh:mm tt')#</cfoutput><br>
      </cfloop>

     

    This code works great for outputting them in a cfselect:

     

    <cfset YourDateTime = "7:00AM">

    <cfset startweek_dt = #timeFormat( YourDateTime,  'hh:mm tt')# >
    <option value="None">None</OPTION>
    <cfloop index="ii" from="1" to="23">
      <cfset startweek_dt = DateAdd('n',30, startweek_dt)>
                                <option value="<cfoutput>#timeFormat( startweek_dt,  'hh:mm tt')#</cfoutput>"><cfoutput>#timeFormat( startweek_dt,  'hh:mm tt')#</cfoutput></option>
      </cfloop>

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points