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/

Reply via email to