Skip to main content
C
cfsetNewbie
Known Participant
January 31, 2010
Answered

get a dynamic cfselect to remember a selected value

  • January 31, 2010
  • 1 reply
  • 1608 views

Hello;

How do I get a cfselect to remember a value if a user has selected one of the choices, but forgets to fill out another form field?

here is my select:

<cfselect enabled="No" name="state" size="1" class="formSelect" multiple="no">
                <option value="">--Select a State--</option>
                <cfloop query= "SESSION.stat">
                  <option value="#state#">#state#</option>
                </cfloop></cfselect>

Everything works accept for remembering what a user chooses I usually use something like value="#form.state#" but it doesn't work in this insance. Can anyone help me? I can't figure this out.

thanks

This topic has been closed for replies.
Correct answer Adam Cameron.

I have to use a loop, it's embeded inside a cfoutput

No, you do not "have to" use a loop. As Dan suggested, you can use "the query and selected attributes" of cfselect. This replaces the cfloop. CF uses the query and column names you supply to populate the select list automatically. Likewise, it uses whatever "selected" attribute you supply value to pre-select the desired list option.

<cfquery name="SESSION.stat"

datasource="#APPLICATION.dataSource#"

cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">

What is the benefit of storing the query in the session scope, on top of caching the query?


What is the benefit of storing the query in the session scope, on top of caching the query?


Especially as the query is pulling out a list of states.  It's not like the recordset is going to be different from one person (session) to the next..?

Also: probably best to ORDER that list of states by something...

--

Adam

1 reply

D
Dan_Bracuk
Inspiring
January 31, 2010

Step 1 - do a query of queries to get ---Select a State--- as the first row of that query.

Step 2  - in your cfselect, use the query and selected attributes instead of the loop.

C
cfsetNewbieAuthor
Known Participant
January 31, 2010

I have to use a loop, it's embeded inside a cfoutput and I don't need to use he q

uery to set up the form. it goes like this:

<cfquery name="SESSION.stat" datasource="#APPLICATION.dataSource#" cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">
SELECT state, ID
FROM States
</cfquery>

then the form:

<cfoutput>

<cfform action="#cgi.script_name#" method="post">

<cfinput type="text" name="name" id="name" value="#form.name#">

My select:

<cfselect enabled="No" name="state" size="1" class="formSelect" multiple="no">
                <option value="">--Select a State--</option>
                <cfloop query= "SESSION.stat">
                  <option value="#state#">#state#</option>
                </cfloop></cfselect>

</cfform>

</cfoutput>


How would I make this work and remember what they selected if they forgot to type in their name? (There are a bunch of fields in this form, I just pulled the one so you see what's going on.)

A
Adam Cameron.Correct answer
Inspiring
February 1, 2010

I have to use a loop, it's embeded inside a cfoutput

No, you do not "have to" use a loop. As Dan suggested, you can use "the query and selected attributes" of cfselect. This replaces the cfloop. CF uses the query and column names you supply to populate the select list automatically. Likewise, it uses whatever "selected" attribute you supply value to pre-select the desired list option.

<cfquery name="SESSION.stat"

datasource="#APPLICATION.dataSource#"

cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">

What is the benefit of storing the query in the session scope, on top of caching the query?


What is the benefit of storing the query in the session scope, on top of caching the query?


Especially as the query is pulling out a list of states.  It's not like the recordset is going to be different from one person (session) to the next..?

Also: probably best to ORDER that list of states by something...

--

Adam

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