How can I loop instead of hardcoding this info

Report · Jun 17, 2012

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>

Report · Jun 18, 2012

Use cfloop condition = "YourDateTime lte #MaxDateTime#"

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

Report · Jun 24, 2012

Like this Dan? Thanks

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

Report · Jun 25, 2012

Did it work when you ran it?

Report · Jun 25, 2012

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.

Report · Jun 25, 2012

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.

Report · Jun 25, 2012

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 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>

Report · Jun 25, 2012

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

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')#

Report · Jun 25, 2012

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>

Report · Jun 25, 2012

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

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

Report · Jun 25, 2012

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

<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 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>

Adobe Community

How can I loop instead of hardcoding this info

1 Correct answer