I have a drop down menu which values come from a database table, it will display the value based on the value from another table. Problem is that it is case sensitive and I need it to be NOT case sensitive. Here is the code :
-------
<select name="POBCntry" class="bodytext" id="select4" onFocus="mark(this,'#C2D5E
B','#00000
0')" onBlur="mark(this,'#FFFFFF
','#000000
')">
<option value="" <%=(("" == (ContactDetails.Fields.Ite
m("PobCoun
try").Valu
e))?"SELEC
TED":"")%>
>Please select a Country</option>
<%
while (!WorldCountries.EOF) {
%>
<option value="<%=(WorldCountries.
Fields.Ite
m("country
").Value)%
>" <%=(((WorldCountries.Field
s.Item("co
untry").Va
lue) == ((ContactDetails.Fields.It
em("PobCou
ntry").Val
ue)))?"SEL
ECTED":"")
%> ><%=(WorldCountries.Fields
.Item("cou
ntry").Val
ue)%></opt
ion>
<%
WorldCountries.MoveNext();
}
if (WorldCountries.CursorType
> 0) {
if (!WorldCountries.BOF) WorldCountries.MoveFirst()
;
} else {
WorldCountries.Requery();
}
%>
</select>
---
Worldcountries.country is the field that is being compared to contactdetails.pob
I need to make those two not-case sensitive so that if for example worldcountries.country = Mexico and contact.details.pob = MEXiCo it will still compare them and display the value of worldcountries.country, regardless of how the user entered the name in contactdetails.pob.
I appreciate the help, let me know if you need any more info.
I am using MS SQL 200, ASP/Javascript page.