very quick question

[quiero mas]

In my database a field is designated as 0 or -1 . When i make my form how do
i set up the drop down menu so that the user chooses yes or no and these
represent 0 or -1 ?

Much appreciated

search page
<cfquery name="English" datasource="simple"> ( English is the language the
user can reply yes or no to)
SELECT Simple.???????
FROM Simple

</cfquery>

<select name="English">
<cfoutput query="English">
<option value="#English#">#English#</option>
</cfoutput> </select>

I hope you can all understand

Best Regards

[leuqcar]

hello quiero !!!

u cud use the following code :

<select name = "english_lang">
<option value=""></option>
<option value="1">Yes</option>
<option value="0">No</option>
</select>


regards..
kel

[MikerRoo]

Please read some usability studies.

If this can only be yes or no, use a checkbox.

Selectors annoy the snot out of many (most?) web users and have been proved to greatly increase entry errors.

[mxstu]

I agree with MikerRoo. For simple yes or no options, radio buttons are more intuitive and easier to use, providing a higher level of usability.

[quiero mas]

Thanks everyone for your time to respond. I have thought about radio buttons
and check boxes but i wanted to kept continuity.
i will see how all ideas work and get back to youi all

again thanks for your input

regards
quiero mas

[BKBK]

<cfquery name="English" datasource="simple"> ( English is the language the user
can reply yes or no to)
SELECT Simple.English
FROM Simple
</cfquery>

Your code has quite a few problems. Assuming your database table is
called preferences , fix it with something like:



<cfquery name="languageQuery" datasource="simple">
SELECT userLanguage FROM preferences
WHERE userID = '#input_ID#'
</cfquery>

<!--- English is the language the user can reply yes or no to --->
<cfoutput query="languageQuery">
#userLanguage#:&nbsp;<select name="#userLanguage#">
<option value="yes" selected>yes</option>
<option value="no">no</option>
</select><br><br>
</cfoutput>

[quiero mas]

thanks alot - actually what i am trying to use is
1. let a user decide which language they want
2. pull the apropriate information fom a few different tables

project background: a multilingual hospital guide for non japnese residents
here in japan.
so i have each hospital and its information and then the