Ne razbrah napalnl vaprosa, no eto kakvo mislia:
1. Vmesto da submitvash forma sled vsiko "onchange", ne mozhe li edin buton (ili link, ili picture) s onclick="document.form1.submit();" i sled tova si imash dannite s "Request.Form("...")
2. Mislia che po-optimizirano e v nachaloto edna zaiavka kam bazata danni za UserPreferences i da slozhish vsichko v promenlivi i masivi, naprimer
(VBScript - sori)
<%
If uID <> "" Then
strSQL = "Select * From User_Pref_Table Where user_id = " & uID
oRS.Open strSQL, ...
...
selectedCountry = oRS("country")
...
oRS.Close
Else
selectedCountry = "Canada"
End If
%>
Sled tova kato si palnish menutata (ot tablitsa ili ot masiv) neshto ot roda na:
<Select name="userCountry">
<%For i 0 To UBound(aryCountries)%>
' ili Do While Not oRS.EOF - zavisi koi nachin izberesh
<option value=<%=aryCountries%><%If aryCountries(i) = selectedCountry Then%> selected<%End If%>><%=aryCountries(i)%>></option>
<%Next%>
Ta tova... Pone niakakvi idei, ako ne pomosht.