Hi,

I am currently using user defined table and there is a built in search which is case-sensitive. For example, if we have an entry called "Solutions" in the table and the user typed "solutions" for searching, it will not find any record. If the user types "Solutions", the record will be found.

Is it possible to make the search case-insensitive? (Is that actually a term? LOL)

Thank you for your help,
-Oliver

Hi Sebastian,
Thank you for your reply. Here is the solution I propose:

Replace the following from:

<xsl:variable name="filteredData" select="udt:Data[contains(*[name()=$searchColumns][1],$search) or contains(*[name()=$searchColumns][2],$search) or contains(*[name()=$searchColumns][3],$search) or contains(*[name()=$searchColumns][4],$search) or contains(*[name()=$searchColumns][5],$search)or contains(*[name()=$searchColumns][6],$search)or contains(*[name()=$searchColumns][7],$search)or contains(*[name()=$searchColumns][8],$search)or contains(*[name()=$searchColumns][9],$search)or contains(*[name()=$searchColumns][10],$search)]" />

with the following:

<xsl:variable name="filteredData" select="udt:Data[contains(translate(*[name()=$searchColumns][1], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][2], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][3], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][4], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][5], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][6], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][7], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][8], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][9], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][10], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))]" />

Does anybody have a drop down list box also working with the search form? Say you want to display a drop down list box from a defined list created from UDT, how could you add drop down list boxes to the search form so when a user wants to search through all the records, UDT then displays only the filtered records?

City/Metro - - - - - - - - - - - - Select - - - - - - - - - - - - Apollo Beach Atlantis Bal Harbour Bay Harbor Islands Belle Isle Belleair Belleair Beach Belleair Bluffs Belleair Shores Big Torch Key Boca Grande Boca Raton Bonifay Bonita Springs Bowling Green Boynton Beach Braden River Bradenton Bradenton Beach Brandon Branford Brooksville Cape Canaveral Cape Coral Cape Coral South Captiva Carrollwood Celebration Choctaw Beach Chuluota Citra Citrus Ridge Citrus Springs City Of Sunrise Clair Mel City Clarcona Clarksville Clearwater Clearwater Beach Clermont Clermont South Branch Postal Clewiston Cloud Lake Coco River Cocoa Cocoa Beach Coconut Creek Coconut Grove Coleman College Plaza Commons Conch Key Cooper City Copeland Coral Gables Coral Springs Cortez Cottondale Country Lakes Crawfordville Creekwood Crossing Crescent Beach Crescent City Crestview Cross City Cross Creek Crystal Beach Crystal River Crystal Springs Cudjoe Key Cutler Ridge Cypress Cypress Cleveland Cypress Gardens Cypress Gdns Dade City Dania Dania Beach Davenport Davie Davis Island Day Daytona Beach Daytona Beach Shores De Leon Springs Debary Deer Island Deerfield Beach Defuniak Springs Deland Delray Beach Deltona Deltona Pines Destin Dinsmore Doctors Inlet Dona Vista Doral Doral Branch Dowling Park Downtown Duck Key Duette Duke Field Afs Dundee Dunedin Dunnellon Durant E Rockland Key Eagle Lake Earleton East Naples Carrier Annex East Palatka East Rockland Key Eastlake Weir Eastpoint Eastside Eaton Park Eatonville Eau Gallie Ebro Edgar Edgewater Edgewood Eglin Afb Ehrlich El Jobean El Portal Elfers Elkton Ellenton Eloise Englewood Enterprise Estero Eustis Everglades Br Everglades City Evinston Exchange Fairfield Fairvilla Falkenburg Branch Fanning Springs Fanning Springs Father Felix Varela Fedhaven Felda Fellsmere Fern Park Fernandina Beach Ferndale Fifty Seventh Avenue Flagler Beach Flamingo Lodge Fleming Island Florahome Floral City Florence Villa Florida A And M University Florida City Florida Gulf Coast Univ Florida State University Forest City Forest Lakes Fort Lauderdale Fort Mc Coy Fort Meade Fort Myers Fort Myers Beach Fort Ogden Fort Pierce Fort Walton Beach Fort White Fountain Freeport Frostproof Fruit Cove Fruitland Park Fruitville Ft Lauderdale Gainesville Geneva Georgetown Gibsonton Gladiolus Gateway Glen Ridge Glen Saint Mary Glenwood Golden Beach Golden Gate Golden Gate Carrier Annex Golden Isles Postal Store Goldenrod Gonzalez Good Samaritan Goodland Gotha Graceville Graham Grand Island Grand Ridge Grandin Grant Grassy Key Green Acres Green Cove Springs Greenacres Greensboro Greenville Greenwood Grenelefe Gretna Grove City Groveland Gulf Breeze Gulf Gate Branch Gulf Hammock Gulf Stream Gulfport Haines City Haines Creek Hallandale Hallandale Beach Hampton Harmony Harold Hastings Havana Haverhill Haverhill Br Hawthorne Heathrow Hernando Hernando Beach Hialeah Hialeah Gardens Hiawassee Hibiscus High Springs Highland Beach Highland City Hillcrest Hilliard Hillsboro Beach Hobe Sound Holder Holiday Hollister Holly Hill Hollywood Holmes Beach Holt Home Shopping Homeland Homestead Homestead Afb Homestead Air Force Base Homosassa Homosassa Springs Horseshoe Bch Horseshoe Beach Hosford Howey In The Hills Hudson Hunt Club Hurlburt Field Hutchinson Beach Hutchinson Island Hypoluxo Immokalee Indialantic Indian Creek Indian Creek Village Indian Harbor Beach Indian Harbour Beach Indian Lake Estates Indian River Shores Indian Rocks Beach Indian Shores Indiantown Inglis Intercession City Interchange Square Interlachen Inverness Inverrary Islamorada Island Grove Island Walk Istachatta Jacksonville Jacksonville Beach Jacksonville N A S Jacob Jasper Jay Jennings Jensen Beach Jerome Jog Road Jonesville Jpv Juno Beach Jupiter Jupiter Inlet Colony Kathleen Kenansville Kendall Kennedy Space Center Kenneth City Key Biscayne Key Colony Beach Key Largo Key West Key West Naval Air Station Keystone Heights Killarney Kinard Kissimmee La Crosse Labelle Lacoochee Lady Lake Lake Alfred Lake Buena Vista Lake Butler Lake City Lake Clarke Shores Lake Como Lake Geneva Lake Hamilton Lake Harbor Lake Helen Lake Jackson Branch Lake Mary Lake Monroe Lake Panasoffkee Lake Park Lake Placid Lake Suzy Lake Wales Lake Worth Lakeland Lakeshore Lakewood Park Lakewood Ranch Lamont Lanark Village Land O Lakes Lantana Largo Lauderdale By The Sea Lauderdale Lakes Lauderhill Laurel Laurel Hill Lawtey Lazy Lake Lecanto Lee Leesburg Lehigh Acres Lely Shipping Lighthouse Point Lithia Little Torch Key Live Oak Lk Forest Lloyd Lochloosa Lockhart Long Key Longboat Key Longwood Lorida Loughman Lowell Lower Sugarloaf Key Loxahatchee Ludlam Lulu Lutz Lynn Haven Macclenny Macdill Afb Madeira Beach Madison Maitland Malabar Malone Manalapan Manasota Manatee Contract Branch Mango Marathon Marathon Shores Marco Island Margate Marianna Maricamp Mary Esther Masaryktown Mascotte Matlacha Matlacha Isles Maxville Mayo Mayport Naval Station Mc Alpin Mc David Mc Intosh Medley Melbourne Melbourne Beach Melbourne Village Melrose Melrose Vista Merchants Crossing Cont. Merritt Island Metro Market Mexico Beach Miami Miami Beach Miami Gardens Miami Lakes Miami Shores Miami Springs Micanopy Micco Micco Barefoot Peddler Miccosukee Mid Florida Mid Venice Middle Torch Key Middleburg Midway Milam Dairy Milligan Milton Mims Minneola Miramar Miramar Beach Miromar Lakes Molino Monticello Montverde Moore Haven Morriston Mossy Head Mount Dora Mount Pleasant Mount Plymouth Mt Pleasant Mulberry Murdock Myakka City N Fort Myers N Ft Myers Nalcrest Naples Naranja Naval Air Station Unit 2 Navarre Neptune Beach New Port Richey New Smyrna Beach Newberry Niceville Nichols Nobleton Nocatee Nokomis Noma Normandy North Bay Village North Cleveland North County Line North Fort Myers North Lauderdale North Miami North Miami Beach North Ocean Blvd North Palm Beach North Port North Redington Beach North Ridge Annex North Venice Northdale O Brien Oak Hill Oakland Oakland Park Ocala Ocean Reef Ocean Ridge Ochlockonee Bay Ochopee Ocklawaha Ocoee Odessa Ojus Okahumpka Okeechobee Old Town Oldsmar Olustee Olympia Heights Ona Oneco Opa Locka Orange City Orange Lake Orange Park Orange Springs Orchid Orlando Orlo Vista Ormond Beach Osprey Osteen Otter Creek Overstreet Oviedo Oxford Ozona Pace Page Field Pahokee Paisley Palatka Palm Bay Palm Bay West Palm Beach Palm Beach Gardens Palm Beach Gardens Mall Palm Beach Shores Palm City Palm Coast Palm Harbor Palm Springs Palma Ceia Palma Sola Palmdale Palmetto Palms Central Palms West Panacea Panama City Panama City Beach Parkland Parrish Pass A Grille Beach Pass A Grille Branch Patrick Afb Patrick Afb Patrick Air Force Base Paxton Pembroke Park Pembroke Pines Penney Farms Pensacola Pensacola Beach Perrine Perry Pierson Pine Castle Pine Hills Pinecraft Pinecrest Pinecrest Postal Store Pineland Pinellas Park Pinetta Placida Plant City Plantation Plymouth Poinciana Point Washington Polk City Pomona Park Pompano Beach Ponce De Leon Ponce Inlet Ponte Vedra Ponte Vedra Beach Port Canaveral Port Charlotte Port Orange Port Richey Port Saint Joe Port Saint John Port Saint Lucie Port Salerno Princeton Pt Orange Punta Gorda Putnam Hall Quail Heights Quincy Raiford Ramrod Key Red Bay Reddick Redington Beach Redington Shores Redland Renaissance Reunion Richland Ridge Manor Ridge Manor Estates Ridge Manor West River Ranch Riverland Riverview Riviera Beach Rockledge Roseland Rosemary Beach Rotonda West Royal Palm Beach Royal Plm Beach Rubonia Ruskin S Daytona S Daytona Bch Safety Harbor Saint Augustine Saint Augustine Beach Cpu Saint Cloud Saint George Island Saint James City Saint Leo Saint Lucie West Saint Marks Saint Pete Beach Saint Petersburg Saint Teresa Salem Salt Springs San Antonio San Carlos Contract Branch San Mateo Sand Lake Sanderson Sandestin Sanford Sanibel Santa Fe Santa Rosa Beach Sarasota Sarasota Square Satellite Beach Satsuma Scottsmoor Se Central Contract Branch Sea Ranch Lakes Sebastian Sebring Seffner Seminole Seville Sewalls Point Seybold Shady Grove Shady Hills Shalimar Sharpes Sidell Siesta Key Silver Springs Singer Island Snapper Creek Snapper West Annex Sneads Sopchoppy Sorrento South Bay South Creek South Daytona South Florida South Miami South Palm Beach South Pasadena South Venice Southport Southside Southwest Ranches Spanish Isles Annex Sparr Spring Hill Springs Plaza St Augustine St Lucie West St Pete Beach St Petersburg Bch St Petersburg Beach St Teresa Starke Steinhatchee Stock Island Stuart Stuart Annex Sugarloaf Sugarloaf Key Sugarloaf Shores Sumatra Summerfield Summerland Key Sumterville Sun City Sun City Center Sunny Hills Sunny Isles Beach Sunrise Sunset Sunset Point Suntree Surfside Survey Creek Suwannee Switzerland Sydney Tallahassee Tallevast Tamarac Tampa Tampa Palms Tangerine Tarpon Springs Tavares Tavernier Telogia Temple Terrace Tequesta Terra Ceia Terra Ceia Island The Villages Thomas Drive Thonotosassa Tice Tierra Verde Tiger Point Time Customer Service Inc Titusville Town N Country Trailer Estates Treasure Island Trenton Trilby Trinity Tropic Tuskawilla Tyndall A F B Tyndall Afb Uleta Umatilla Union Park Univ Of West Florida University University Of Miami University Of South Florida University Of Tampa University Park Upper Sugarloaf Key Valparaiso Valrico Vanderbilt Beach Venice Ventura Venus Vernon Vero Beach Viera Villa Of Santini Village Of Golf Village Of Palmetto Bay Village Of Wellington Virginia Gardens W Cocoa Wabasso Wachula Wacissa Wahneta Wakulla Springs Waldo Walnut Hill Warm Mineral Springs Watersound Wauchula Wausau Waverly Webster Weeki Wachee Weirsdale Wekiva Springs Welaka Wellborn Wellington Wesley Chapel West Beach Station West Boca West Delray Beach West Hollywood West Melbourne West Miami West Palm Bch West Palm Beach Westchase Westgate Contract Branch Weston Westside Branch Westville Wewahitchka White Springs Whitney Beach Wilbur By The Sea Wildwood Williston Wilton Manors