Kenneth,
You can include any options in your select that you want, either before or
after your query results. Just write them as if the query output weren't
present.
I notice that you're not using the "value" attribute within your OPTION
element. You can include this in your static options, and you can also use
an additional database field to populate it within the query output. If
you're inserting, this can be useful if the value you want to store differs
from the visible OPTION content.
e.g., instead of <OPTION>my option, you could write:
<OPTION value="1">My Option 1</option>
<OPTION value="2">My Option 2</option> (the end tags are optional, but I
prefer to include them)
Regards,
John Allred
Kenneth Tyler
<kentyler@pac To: [EMAIL PROTECTED]
bell.net> cc:
Subject: Re: Selects, default values..
06/29/2000
10:08 AM
Please
respond to
cf-talk
> How can i give a select a choice thats not contained in my query? Any
advice
Stew,
<SELECT NAME="mySelect">
<OPTION>my option
<CFOUTPUT QUERY = "myQuery">
<OPTION>#qryField#>
</CFOUTPUT>
</SELECT>
Kenneth Tyler, 8th Fold, Berkeley, CA, USA
>
--------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
