Skip to main content
Participant
April 20, 2006
Question

cfselect and cfloop help

  • April 20, 2006
  • 2 replies
  • 606 views
I am working on an event calender application. What I am trying to achieve is to have 2 drop down lists with the months of the year in them. I want the selection from the first list field to define the starting point for the second list field. For example. The first choice from the 12 months is March. So I want the second box, located on the same page, to have from March to December as options. Then there is a submit button.

Then, below, on the same page, I would like to have a dynamic calender generated for the events between the months selected from the form. I have the calender section completed using a db query to populate the table with the events.

I can get this to mostly work by having the form on one page submit to the calender on another page though I cannot get the second list field to update based on the value passed from the first list field, I would really like this to work on a single page so that the user can resubmit different date combinatons on the fly.

Any help anyone can provide me with would be greatly appreciated. Thanks in advance.
This topic has been closed for replies.

2 replies

Inspiring
April 20, 2006
Use frames or iframes.
robspotAuthor
Participant
April 20, 2006
I am using a webhosting service so I am unable to use CFX tags and I would like to stay away from frames.

I sthere some other way I can accomplish this?
robspotAuthor
Participant
April 20, 2006
Ok..i have the page working almost completely right now.

I used IsDefined("Form.Submit"> in a <CFIF> <CFELSE> statement to get the form to submit the results to the same page, then i added a second copy of the form to the top of the reselts section of the calender so that the form is always present for use on the page.

The only thing I need help with now is making the second list box update it's choices from the selection of the first list box in the same form. Any ideas?

I can post code iff it will help any, but it is getting rather lengthy.
robspotAuthor
Participant
April 20, 2006
I figured out how to combine them into one page using IsDefined(Form.submit), but the form is replaced by the claender results. I would like to keep the form visible so users can make multiple selections without having to click a back button to access the form.

I also still need to figure out how to have the 2nd list field update from the results of the 1st list field.