Hello,
Thanks in advance for any help as I’ve been a but stumped by this as my coding outside asp is limited to say the least.
I’m using dhtmlxCombo box for a search form and i have it creating the xml file from a MySQL database. The XML looks like this;
As you can see the option value is a number which is assigned to a breed of dog.
When the form is submitted it reloads the page in which the combo box resides but the option value is displayed in the text area of the box instead of the dog breed so the user is shown a number which means nothing to them.
How do i get the box to show the breed of dog and still work after the first submission if its submitted again without clicking in or changing the combobox results?
I’m using;
Thanks for the reply Darya,
I was unable to duplicate the issue in the exact format you requested so i have done it slightly differently. I hope that’s OK and it makes sense.
I needed to make the index page index.asp as i needed to run some code to show the issue, furthermore i couldn’t get the issue to work with a hard coded .xml file so i have used asp to generate it dynamically from a database in directory - complete-demo/xml/complete-demo.asp.
There is also an included file in index.asp called dogbreeds.asp and two hidden form fields i am using which have values that are generated from two variables in dogbreeds.asp. All the code for the asp is shown below. Thanks Again. http://www.cowtons.co.uk/complete-demo/index.asp
You will see when you click submit that the breedID is displayed (when i would like the breed to be displayed) when the page reloads and also for the form to be submitted again without changing anything in the combobox as I’m using this with other fields in the same form so a user can refine the search with other options such as colour, distance from postcode etc.
complete-demo.asp
<%@LANGUAGE="VBScript"%>
<%
Set my_conn = server.createobject("ADODB.Connection")
my_conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=mydatabase;"_
& "UID=myUserID;PWD=myPassWord; OPTION=35;"
%>
<%
mask = request.querystring ("mask")
pos = request.querystring ("pos")
'mask = "ame"
'pos = 0
Dim DaValue():Dim breed()
strSQL = "select count(*) as c from breeds WHERE breed LIKE '" & mask & "%'"
Set rs2 = my_conn.Execute(strSQL)
n = rs2("c")
set rs2 = nothing
ReDim DaValue(n):ReDim breed(n)
c = 0
strSQL = "select DaValue, breed from breeds WHERE breed LIKE '" & mask & "%'"
Set rs6 = Server.CreateObject("ADODB.Recordset")
Set rs6 = my_conn.Execute(strSQL)
do until rs6.eof
DaValue(c) = rs6("DaValue")
breed(c) = rs6("breed")
rs6.movenext
c = c + 1
loop
Set rs6 = nothing
response.write("<?xml version=""1.0"" ?>")
if pos = 0 then
response.write("<complete>")
else
response.write("<complete add=""true"">")
end if
for n = 0 to ubound(DaValue) - 1
response.write("<option value=""" & DaValue(n) & """>" & breed(n) & "</option>")
next
response.write("</complete>")
my_conn.close ' Close database connection
Set my_conn = nothing 'obj variable released
%>
Include file dogbreeds.asp
<%
if request.form("alfa4") <> "" then
dim breedID, breed
breedID = request.form("alfa4")
if breedID = "0" then breed = "Please select your breed"
if breedID = "1" then breed = "Affenpinscher"
if breedID = "2" then breed = "Afghan Hound"
if breedID = "3" then breed = "Airedale"
if breedID = "4" then breed = "Akita"
if breedID = "5" then breed = "Alaskan Malamute"
if breedID = "6" then breed = "American Bulldog"
if breedID = "7" then breed = "American Eskimo Dog"
if breedID = "8" then breed = "American Foxhound"
if breedID = "9" then breed = "American Hairless Terrier"
if breedID = "10" then breed = "American Staffordshire Terrier"
if breedID = "11" then breed = "American Water Spaniel"
if breedID = "12" then breed = "Anatolian Shepherd Dog"
if breedID = "13" then breed = "Australian Cattle Dog"
if breedID = "14" then breed = "Australian Shepherd"
if breedID = "15" then breed = "Australian Silky Terrier"
if breedID = "16" then breed = "Australian Terrier"
if breedID = "17" then breed = "Azawakh"
if breedID = "18" then breed = "Basenji"
if breedID = "19" then breed = "Basset Bleu de Gascogne"
if breedID = "20" then breed = "Basset Fauve De Bretagne"
if breedID = "21" then breed = "Basset Griffon Vendeen (Grand)"
if breedID = "22" then breed = "Basset Griffon Vendeen (Petit)"
if breedID = "23" then breed = "Basset Hound"
if breedID = "24" then breed = "Bavarian Mountain Hound"
if breedID = "25" then breed = "Beagle"
if breedID = "26" then breed = "Bearded Collie"
if breedID = "27" then breed = "Beauceron"
if breedID = "28" then breed = "Bedlington Terrier"
if breedID = "29" then breed = "Belgian Shepherd Dog (Groenendael)"
if breedID = "30" then breed = "Belgian Shepherd Dog (Laekenois)"
if breedID = "31" then breed = "Belgian Shepherd Dog (Malinois)"
if breedID = "32" then breed = "Belgian Shepherd Dog (Tervueren)"
if breedID = "33" then breed = "Bergamasco"
if breedID = "34" then breed = "Bernese Mountain Dog"
if breedID = "35" then breed = "Bichon Frise"
if breedID = "36" then breed = "Black & Tan Coonhound"
if breedID = "37" then breed = "Bloodhound"
if breedID = "38" then breed = "Boerboel"
if breedID = "39" then breed = "Bolognese"
if breedID = "40" then breed = "Border Collie"
if breedID = "41" then breed = "Border Terrier"
if breedID = "42" then breed = "Borzoi"
if breedID = "43" then breed = "Boston Terrier"
if breedID = "44" then breed = "Bouvier Des Flandres"
if breedID = "45" then breed = "Boxer"
if breedID = "46" then breed = "Bracco Italiano"
if breedID = "47" then breed = "Briard"
if breedID = "48" then breed = "Brittany"
if breedID = "49" then breed = "Bull Terrier"
if breedID = "50" then breed = "Bull Terrier (Miniature)"
if breedID = "51" then breed = "Bulldog (British only)"
if breedID = "52" then breed = "Bullmastiff"
if breedID = "53" then breed = "Cairn Terrier"
if breedID = "54" then breed = "Canaan Dog"
if breedID = "55" then breed = "Canadian Eskimo Dog"
if breedID = "56" then breed = "Catalonian Sheepdog"
if breedID = "57" then breed = "Cavalier King Charles Spaniel"
if breedID = "58" then breed = "Cesky Terrier"
if breedID = "59" then breed = "Chihuahua"
if breedID = "60" then breed = "Chinese Crested Dog"
if breedID = "61" then breed = "Chow Chow"
if breedID = "62" then breed = "Cirneco D'el Etna"
if breedID = "63" then breed = "Collie (Rough)"
if breedID = "64" then breed = "Collie (Smooth)"
if breedID = "65" then breed = "Coton De Tulear"
if breedID = "66" then breed = "Czechoslovakian Wolfdog"
if breedID = "67" then breed = "Dachshund (Long Haired)"
if breedID = "68" then breed = "Dachshund (Miniature Long Haired)"
if breedID = "69" then breed = "Dachshund (Miniature Smooth Haired)"
if breedID = "70" then breed = "Dachshund (Miniature Wire Haired)"
if breedID = "71" then breed = "Dachshund (Smooth Haired)"
if breedID = "72" then breed = "Dachshund (Wire Haired)"
if breedID = "73" then breed = "Dalmatian"
if breedID = "74" then breed = "Dandie Dinmont Terrier"
if breedID = "75" then breed = "Deerhound"
if breedID = "76" then breed = "Dobermann"
if breedID = "77" then breed = "Dogue De Bordeaux"
if breedID = "78" then breed = "English Setter"
if breedID = "79" then breed = "English Toy Terrier (Black & Tan)"
if breedID = "80" then breed = "Entlebucher Mountain Dog"
if breedID = "81" then breed = "Estrela Mountain Dog"
if breedID = "82" then breed = "Eurasier"
if breedID = "83" then breed = "Finnish Lapphund"
if breedID = "84" then breed = "Finnish Spitz"
if breedID = "85" then breed = "Fox Terrier (Smooth)"
if breedID = "86" then breed = "Fox Terrier (Wire)"
if breedID = "87" then breed = "Foxhound"
if breedID = "88" then breed = "French Bulldog"
if breedID = "89" then breed = "German Longhaired Pointer"
if breedID = "90" then breed = "German Pinscher"
if breedID = "91" then breed = "German Shepherd Dog (Alsatian)"
if breedID = "92" then breed = "German Shorthaired Pointer"
if breedID = "93" then breed = "German Spitz (Klein)"
if breedID = "94" then breed = "German Spitz (Mittel)"
if breedID = "95" then breed = "German Wirehaired Pointer"
if breedID = "96" then breed = "Giant Schnauzer"
if breedID = "97" then breed = "Glen of Imaal Terrier"
if breedID = "98" then breed = "Gordon Setter"
if breedID = "99" then breed = "Grand Blue De Gascogne"
if breedID = "100" then breed = "Great Dane"
if breedID = "101" then breed = "Greenland Dog"
if breedID = "102" then breed = "Greyhound"
if breedID = "103" then breed = "Griffon Bruxellois"
if breedID = "104" then breed = "Griffon Korthals"
if breedID = "105" then breed = "Hamiltonstovare"
if breedID = "106" then breed = "Harrier"
if breedID = "107" then breed = "Havanese"
if breedID = "108" then breed = "Hovawart"
if breedID = "109" then breed = "Hungarian Kuvasz"
if breedID = "110" then breed = "Hungarian Puli"
if breedID = "111" then breed = "Hungarian Vizsla"
if breedID = "112" then breed = "Hungarian Wirehaired Vizsla"
if breedID = "113" then breed = "Ibizan Hound"
if breedID = "114" then breed = "Irish Red & White Setter"
if breedID = "115" then breed = "Irish Setter"
if breedID = "116" then breed = "Irish Terrier"
if breedID = "117" then breed = "Irish Wolfhound"
if breedID = "118" then breed = "Italian Greyhound"
if breedID = "119" then breed = "Italian Spinone"
if breedID = "120" then breed = "Japanese Akita Inu"
if breedID = "121" then breed = "Japanese Chin"
if breedID = "122" then breed = "Japanese Shiba Inu"
if breedID = "123" then breed = "Japanese Spitz"
if breedID = "124" then breed = "Keeshond"
if breedID = "125" then breed = "Kerry Blue Terrier"
if breedID = "126" then breed = "King Charles Spaniel"
if breedID = "127" then breed = "Komondor"
if breedID = "128" then breed = "Kooikerhondje"
if breedID = "129" then breed = "Korean Jindo"
if breedID = "130" then breed = "Lagotto Romagnolo"
if breedID = "131" then breed = "Lakeland Terrier"
if breedID = "132" then breed = "Lancashire Heeler"
if breedID = "133" then breed = "Large Munsterlander"
if breedID = "134" then breed = "Leonberger"
if breedID = "135" then breed = "Lhasa Apso"
if breedID = "136" then breed = "Lowchen (Little Lion Dog)"
if breedID = "137" then breed = "Maltese"
if breedID = "138" then breed = "Manchester Terrier"
if breedID = "139" then breed = "Maremma Sheepdog"
if breedID = "140" then breed = "Mastiff"
if breedID = "141" then breed = "Mexican Hairless Dog (All)"
if breedID = "142" then breed = "Miniature Pinscher"
if breedID = "143" then breed = "Miniature Schnauzer"
if breedID = "144" then breed = "Neapolitan Mastiff"
if breedID = "145" then breed = "Newfoundland"
if breedID = "146" then breed = "Norfolk Terrier"
if breedID = "147" then breed = "Northern Inuit"
if breedID = "148" then breed = "Norwegian Buhund"
if breedID = "149" then breed = "Norwegian Elkhound"
if breedID = "150" then breed = "Norwegian Lundehund"
if breedID = "151" then breed = "Norwich Terrier"
if breedID = "152" then breed = "Old English Sheepdog"
if breedID = "153" then breed = "Otterhound"
if breedID = "154" then breed = "Papillon"
if breedID = "155" then breed = "Parson Russell Terrier"
if breedID = "156" then breed = "Pekingese"
if breedID = "157" then breed = "Perro De Presa Canario"
if breedID = "158" then breed = "Pharaoh Hound"
if breedID = "159" then breed = "Plott Hound"
if breedID = "160" then breed = "Pointer"
if breedID = "161" then breed = "Polish Lowland Sheepdog"
if breedID = "162" then breed = "Pomeranian"
if breedID = "163" then breed = "Poodles"
if breedID = "164" then breed = "Portuguese Podengo (Warren Hound)"
if breedID = "222" then breed = "Portuguese Sheepdog"
if breedID = "165" then breed = "Portuguese Water Dog"
if breedID = "166" then breed = "Pug"
if breedID = "167" then breed = "Pyrenean Mastiff"
if breedID = "168" then breed = "Pyrenean Mountain Dog"
if breedID = "169" then breed = "Pyrenean Sheepdog"
if breedID = "170" then breed = "Redbone Coonhound"
if breedID = "171" then breed = "Retriever (Chesapeake Bay)"
if breedID = "172" then breed = "Retriever (Curly Coated)"
if breedID = "173" then breed = "Retriever (Flat Coated)"
if breedID = "174" then breed = "Retriever (Golden)"
if breedID = "175" then breed = "Retriever (Labrador)"
if breedID = "176" then breed = "Retriever (Nova Scotia Duck Tolling)"
if breedID = "177" then breed = "Rhodesian Ridgeback"
if breedID = "178" then breed = "Rottweiler"
if breedID = "179" then breed = "Russian Black Terrier"
if breedID = "180" then breed = "Saint Bernard"
if breedID = "181" then breed = "Saluki"
if breedID = "182" then breed = "Samoyed"
if breedID = "183" then breed = "Schipperke"
if breedID = "184" then breed = "Schnauzer"
if breedID = "185" then breed = "Scottish Terrier"
if breedID = "186" then breed = "Sealyham Terrier"
if breedID = "187" then breed = "Segugio Italiano"
if breedID = "188" then breed = "Shar Pei"
if breedID = "189" then breed = "Shetland Sheepdog"
if breedID = "190" then breed = "Shih Tzu"
if breedID = "191" then breed = "Siberian Husky"
if breedID = "192" then breed = "Skye Terrier"
if breedID = "193" then breed = "Sloughi"
if breedID = "194" then breed = "Slovakian Rough haired Pointer"
if breedID = "195" then breed = "Small Munsterlander"
if breedID = "196" then breed = "Soft Coated Wheaten Terrier"
if breedID = "197" then breed = "American Cocker Spaniel"
if breedID = "198" then breed = "Clumber Spaniel"
if breedID = "199" then breed = "Cocker Spaniel"
if breedID = "200" then breed = "Springer Spaniel (English)"
if breedID = "201" then breed = "Field Spaniel"
if breedID = "202" then breed = "Irish Water Spaniel"
if breedID = "203" then breed = "Sussex Spaniel"
if breedID = "204" then breed = "Springer Spaniel (Welsh)"
if breedID = "205" then breed = "Spanish Water Dog"
if breedID = "206" then breed = "Staffordshire Bull Terrier"
if breedID = "207" then breed = "Swedish Lapphund"
if breedID = "208" then breed = "Swedish Vallhund"
if breedID = "209" then breed = "Tibetan Mastiff"
if breedID = "210" then breed = "Tibetan Spaniel"
if breedID = "211" then breed = "Tibetan Terrier"
if breedID = "212" then breed = "Utonagan"
if breedID = "213" then breed = "Vizsla"
if breedID = "214" then breed = "Weimaraner"
if breedID = "215" then breed = "Welsh Corgi (Cardigan)"
if breedID = "216" then breed = "Welsh Corgi (Pembroke)"
if breedID = "217" then breed = "Welsh Terrier"
if breedID = "218" then breed = "West Highland White Terrier"
if breedID = "219" then breed = "Whippet"
if breedID = "220" then breed = "Wirehaired Pointing Griffon"
if breedID = "221" then breed = "Yorkshire Terrier"
end if
%>
You are setting document.getElementById(‘ctxt’).value as combo text:
z.setComboText(document.getElementById(‘ctxt’).value)
After submit ctxt hidden input contains options key (breedID). If I submitted the first option, the input is like so:
So, combo behaves correctly.
Please check the following sample in Combo package, it shows how to submit forms without page reload:
dhtmlxCombo/samples/02_actions/03_combo_save.html dhtmlx.com/docs/products/dht … _save.html
Get a guaranteed answer from DHTMLX technical support team
under the most suitable support plan