Hi WIll,
Thanks. I found my old references and got it going.
Thanks A Bunch.
Ray
From: "Will Key" <[EMAIL PROTECTED]>
Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing
List<[email protected]>
To: "Dallas/Fort Worth ColdFusion User Group Mailing
List"<[email protected]>
Subject: Re: [DFW CFUG] Could someone rejog my memory?
Date: Thu, 16 Feb 2006 15:31:52 -0600
Sorry Ray,
I was just going to an appointment and maybe cut it too short..
I use php / mySQL now but when I was doing ColdFusion, I'd do something
like this -
I'd probably use a table for the states and pull the value of each row in
as a variable.
Something like ...
<SELECT name="userstate">
<CFLOOP QUERY="MyQuery">
<CFOUTPUT>
<option value="#stateabbreviation#"
<cfif #stateabbreviation# Is #GetUser.Userstate#> SELECTED</cfif>
>
#MyQuery.MyColName#
</option>
</CFOUTPUT>
</CFLOOP>
</SELECT>
This means that the code would check to see if the previously selected
value matches the current option. If so, then that option would be selected
on returning to the form ...
Make any sense?
There are probably much more elegant solutions now but I've pretty much
abandoned ColdFusion.
Opensource fits my budget better!
Good Luck
Will Key
*********** REPLY SEPARATOR ***********
On 2/16/2006 at 12:53 PM Ray Hughes wrote:
>Hi Will,
>
>What is your reference *value* referencing?
>
>Ray
>
>
>>From: "Will Key" <[EMAIL PROTECTED]>
>>Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing
>>List<[email protected]>
>>To: "Dallas/Fort Worth ColdFusion User Group Mailing
>>List"<[email protected]>
>>Subject: Re: [DFW CFUG] Could someone rejog my memory?
>>Date: Thu, 16 Feb 2006 12:40:13 -0600
>>
>>Try something like this ...
>> >
>> ><td> <SELECT NAME="Userstate" ">
>> ><OPTION VALUE="" <cfif *value* Is #GetUser.Userstate#> Selected</cfif>
>> ></OPTION>
>> ><OPTION VALUE="AL">Alabama</OPTION>
>>
>>
>>
>>_______________________________________________
>>Reply to DFWCFUG:
>> [email protected]
>>Subscribe/Unsubscribe:
>> http://lists1.safesecureweb.com/mailman/listinfo/list
>>List Archives:
>> http://www.mail-archive.com/list%40list.dfwcfug.org/
>> http://www.mail-archive.com/list%40dfwcfug.org/
>>DFWCFUG Sponsors:
>> www.HostMySite.com
>> www.teksystems.com/
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today - it's
FREE!
>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
>_______________________________________________
>Reply to DFWCFUG:
> [email protected]
>Subscribe/Unsubscribe:
> http://lists1.safesecureweb.com/mailman/listinfo/list
>List Archives:
> http://www.mail-archive.com/list%40list.dfwcfug.org/
> http://www.mail-archive.com/list%40dfwcfug.org/
>DFWCFUG Sponsors:
> www.HostMySite.com
> www.teksystems.com/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/