I don't know cold fusion, but I redesigned the page The page was fine, until about 6 months ago the search in the campground area went case sensitive. I don't know if it's in the web design cf,html or something on the backend in the db? the code for the search page is
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"[URL unfurl="true"]http://www.w3.org/TR/html4/loose.dtd">[/URL]
<!--- This template uses a form to allow users to select
from dynamically populated select boxes and/or enter information
used to search for national parks --->
<!--- Get information about the type of park --->
<CFQUERY NAME="Getcity" DATASOURCE="rvingdata">
SELECT city FROM campgrounds GROUP BY city
</CFQUERY>
<html><!-- InstanceBegin template="/Templates/table_test2.dwt.cfm" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="doctitle" -->
<title>RVingUSA Template Horiz Header</title>
<!-- InstanceEndEditable --><style type="text/css">
<!--
body {
background-color: #009900;}
.style1 {
color: #FFFFCC;
font-size: 16px;
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
font-style: italic;}
.style4 {font-family: Arial, Helvetica, sans-serif; font-size: 14px;}
a:link {color: #996600;}
a:hover {color: #009900;}
a:visited {color: #996600;}
a.toplink:link {color: #FFFF99;}
a.toplink:hover {color: #FFFF00;}
a.toplink:visited {color: #FFFF99;}
.style5 {font-size: 14}
.style6 {color: #FFFFCC}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style10 {font-size: 12px}
.style12 {
font-weight: bold;
color: #000000;
font-size: 12px;
}
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body>
<table width="800" border="2" align="center" cellpadding="5" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFCC">
<tr>
<th scope="col"><table width="800" border="1" align="center" cellpadding="2" cellspacing="0">
<tr>
<th width="819" scope="col"><img src="images/RVingUSA_Header.jpg" width="800" height="100"></th>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<th colspan="2" scope="col"><table width="100%" height="30" border="0" cellpadding="0" cellspacing="0" bgcolor="#996600">
<tr>
<th scope="col"><span class="style1">Welcome to RVingUSA.com, the internet's BEST
search engine for campgrounds & RV Parks! </span></th>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" bgcolor="#014D02">
<tr>
<th scope="col"><span class="style4"><a href="[URL unfurl="true"]http://www.rvingusa.com"[/URL] class="toplink">HOME</a> | <a href="main_search.cfm" class="toplink">CAMPGROUND SEARCH</a> | <a href="main/submit.html" class="toplink">SUBMISSIONS</a> | <a href="[URL unfurl="true"]http://www.sepub.com"[/URL] class="toplink">SOUTHEAST PUBLICATIONS USA, INC.</a> </span></th>
</tr>
</table>
</th>
</tr>
<!-- InstanceBeginEditable name="Content" -->
<tr>
<td width="2%" align="left" valign="top"> </td>
<td width="83%" align="left" valign="top"><table width="650" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td height="40" bgcolor="#004D00">
<center><font size="3" color="white">Simply enter the information you wish to search by.<BR>
</font><font color="white"> <span class="style10">You may reduce the search further by entering information into additional fields. (all fields are optional):</span></font>
</center>
</td>
</tr><TR><TD></td></tr>
<TR><TD><FORM ACTION="search.cfm" METHOD=POST>
<!--- The two select boxes below are dynamically populated using the queries
above. Note the location of CFOUTPUT inside the select, but around the
option value which is dynamically filled. --->
<div align="left">
<center>
<table width="650" border="0">
<tr>
<td><B>Campground </B>
<INPUT TYPE="text" NAME="campground" Size="20"><br>
<span class="style12">Searches are case sensitive.</span></td>
<td><B>City </B>
<SELECT NAME="city">
<OPTION VALUE="AllCities" SELECTED>(All Cities or Select a City from the list)
<CFOUTPUT Query="Getcity">
<OPTION VALUE="#city#">#city#
</CFOUTPUT>
</SELECT></td><TD><INPUT TYPE="Submit" VALUE="SEARCH"></td>
</tr>
</table>
</center>
</div>
</FORM></td></tr><TR><TD><CENTER><B><font size="4">-OR- Click on the State Abbreviation to
search by State</font></B></CENTER></td></tr>
<TR><TD><table border="0">
<tr>
<td><map name="FPMap1">
<area href="state_search.cfm?state=FL" shape="polygon" coords="466, 230, 510, 232, 539, 280, 545, 279, 548, 269, 537, 240, 526, 223">
<area href="state_search.cfm?state=GA" shape="polygon" coords="495, 222, 526, 219, 528, 203, 504, 177, 484, 177">
<area href="state_search.cfm?state=AL" shape="polygon" coords="491, 222, 483, 179, 462, 182, 464, 227">
<area href="state_search.cfm?state=MS" shape="polygon" coords="462, 235, 454, 235, 450, 229, 436, 227, 437, 207, 437, 195, 444, 183, 460, 183">
<area href="state_search.cfm?state=LA" shape="polygon" coords="452, 240, 456, 246, 450, 245, 446, 250, 442, 248, 433, 244, 425, 245, 421, 243, 416, 245, 417, 232, 410, 212, 436, 207, 435, 227, 450, 229, 453, 236">
<area href="state_search.cfm?state=TX" shape="polygon" coords="413, 246, 389, 259, 382, 275, 388, 287, 366, 281, 343, 248, 334, 249, 327, 254, 299, 225, 330, 222, 332, 171, 357, 174, 360, 196, 373, 199, 388, 201, 402, 200, 409, 207, 411, 220">
<area href="state_search.cfm?state=NM" shape="polygon" coords="331, 168, 328, 220, 283, 225, 283, 227, 277, 227, 281, 164">
<area href="state_search.cfm?state=AZ" shape="polygon" coords="272, 227, 255, 226, 225, 210, 230, 173, 232, 165, 235, 167, 240, 161, 278, 165">
<area href="state_search.cfm?state=HI" shape="polygon" coords="130, 204, 131, 190, 81, 150, 49, 135, 34, 145, 30, 151, 116, 216">
<area href="state_search.cfm?state=AK" shape="polygon" coords="39, 125, 69, 107, 71, 101, 74, 94, 77, 100, 88, 94, 98, 95, 109, 98, 125, 111, 133, 110, 133, 104, 120, 100, 114, 90, 106, 91, 102, 89, 89, 45, 65, 42, 49, 54, 44, 53, 53, 64, 51, 67, 48, 63, 39, 67, 40, 73, 49, 76, 57, 76, 48, 82, 40, 85, 41, 93, 49, 99, 50, 103, 53, 103, 58, 104, 58, 108">
<area href="state_search.cfm?state=CA" shape="polygon" coords="224, 175, 229, 179, 225, 204, 203, 206, 203, 200, 198, 192, 193, 189, 177, 177, 168, 136, 159, 106, 162, 98, 169, 86, 199, 93, 192, 127">
<area href="state_search.cfm?state=NV" shape="polygon" coords="223, 98, 244, 103, 238, 162, 234, 165, 228, 174, 194, 128, 200, 95">
<area href="state_search.cfm?state=UT" shape="polygon" coords="267, 105, 266, 116, 281, 120, 281, 161, 241, 160, 247, 103">
<area href="state_search.cfm?state=CO" shape="polygon" coords="339, 166, 341, 121, 283, 117, 284, 161">
<area href="state_search.cfm?state=OK" shape="polygon" coords="362, 166, 333, 166, 333, 170, 358, 171, 362, 193, 404, 201, 403, 166">
<area href="state_search.cfm?state=AR" shape="polygon" coords="440, 167, 405, 168, 406, 199, 413, 209, 433, 207, 442, 182, 443, 174">
<area href="state_search.cfm?state=TN" shape="polygon" coords="477, 161, 448, 165, 444, 178, 450, 182, 475, 179, 490, 175, 496, 169, 501, 166, 506, 160, 511, 157">
<area href="state_search.cfm?state=SC" shape="polygon" coords="528, 201, 543, 190, 547, 177, 534, 169, 522, 169, 517, 170, 503, 175">
<area href="state_search.cfm?state=NC" shape="polygon" coords="547, 174, 558, 168, 562, 162, 558, 158, 564, 151, 556, 151, 561, 144, 514, 155, 493, 175, 521, 169, 533, 169">
<area href="state_search.cfm?state=VA" shape="polygon" coords="559, 141, 555, 131, 549, 123, 539, 119, 536, 118, 531, 123, 526, 129, 525, 136, 525, 140, 519, 144, 513, 147, 508, 147, 503, 153, 503, 154, 511, 153">
<area href="state_search.cfm?state=WV" shape="polygon" coords="503, 134, 510, 122, 514, 111, 518, 114, 521, 114, 525, 116, 533, 117, 529, 121, 523, 139, 509, 145">
<area href="state_search.cfm?state=KY" shape="polygon" coords="481, 134, 490, 136, 498, 132, 503, 136, 505, 146, 504, 152, 500, 154, 450, 162, 449, 160, 453, 158, 459, 151, 464, 147, 473, 147, 475, 142">
<area href="state_search.cfm?state=OR" shape="polygon" coords="230, 54, 222, 96, 166, 86, 166, 76, 174, 63, 182, 41, 192, 43, 193, 48">
<area href="state_search.cfm?state=WA" shape="polygon" coords="239, 22, 231, 51, 197, 48, 193, 42, 181, 39, 184, 29, 183, 22, 185, 13, 197, 22, 193, 29, 202, 24, 200, 13">
<area href="state_search.cfm?state=ID" shape="polygon" coords="270, 77, 256, 75, 251, 56, 244, 37, 245, 23, 240, 23, 225, 94, 268, 105">
<area href="state_search.cfm?state=MT" shape="polygon" coords="248, 21, 273, 27, 301, 32, 329, 33, 326, 74, 276, 73, 259, 72, 246, 36">
<area href="state_search.cfm?state=WY" shape="polygon" coords="325, 100, 325, 117, 269, 114, 273, 75, 327, 77">
<area href="state_search.cfm?state=ND" shape="polygon" coords="374, 33, 331, 31, 328, 66, 381, 66, 381, 51">
<area href="state_search.cfm?state=SD" shape="polygon" coords="383, 108, 381, 68, 328, 67, 329, 99, 366, 98, 374, 103, 377, 101">
<area href="state_search.cfm?state=NE" shape="polygon" coords="393, 132, 386, 109, 376, 107, 368, 103, 328, 103, 328, 117, 343, 118, 344, 132">
<area href="state_search.cfm?state=KS" shape="polygon" coords="395, 134, 404, 163, 342, 163, 344, 136">
<area href="state_search.cfm?state=MN" shape="polygon" coords="388, 30, 393, 24, 397, 26, 399, 33, 411, 33, 421, 36, 431, 37, 422, 47, 411, 62, 411, 75, 413, 79, 422, 89, 386, 93, 383, 69, 384, 49, 376, 34">
<area href="state_search.cfm?state=IA" shape="polygon" coords="431, 102, 431, 108, 427, 111, 425, 124, 415, 123, 393, 126, 387, 106, 386, 96, 421, 92, 426, 99">
<area href="state_search.cfm?state=MO" shape="polygon" coords="430, 134, 436, 140, 439, 152, 448, 160, 443, 171, 438, 166, 407, 165, 395, 129, 423, 125">
<area href="state_search.cfm?state=WI" shape="polygon" coords="430, 59, 444, 63, 448, 74, 453, 69, 452, 93, 452, 98, 432, 100, 426, 91, 424, 87, 416, 78, 413, 70, 416, 63, 420, 57">
<area href="state_search.cfm?state=MI" shape="polygon" coords="463, 104, 489, 99, 493, 85, 487, 75, 481, 64, 466, 48, 453, 48, 441, 48, 427, 56, 450, 69, 456, 100">
<area href="state_search.cfm?state=IL" shape="polygon" coords="456, 113, 461, 138, 458, 149, 449, 157, 441, 151, 437, 140, 427, 126, 427, 114, 432, 110, 436, 102, 453, 102">
<area href="state_search.cfm?state=IN" shape="polygon" coords="479, 119, 482, 133, 474, 144, 460, 148, 465, 133, 458, 109, 474, 104">
<area href="state_search.cfm?state=OH" shape="polygon" coords="500, 100, 510, 91, 511, 111, 503, 132, 486, 132, 478, 106">
<area href="state_search.cfm?state=PA" shape="polygon" coords="512, 90, 519, 90, 551, 80, 556, 86, 559, 97, 556, 104, 524, 114, 514, 108">
<area href="state_search.cfm?state=NY" shape="polygon" coords="519, 73, 515, 85, 517, 90, 552, 77, 562, 87, 571, 86, 565, 84, 560, 65, 555, 48, 543, 46, 535, 62, 530, 72">
<area href="state_search.cfm?state=ME" shape="polygon" coords="580, 55, 572, 35, 578, 7, 583, 5, 596, 16, 601, 24, 599, 31, 590, 37">
<area href="state_search.cfm?state=NH" shape="rect" coords="512, 7, 535, 20">
<area href="state_search.cfm?state=VT" shape="rect" coords="510, 21, 536, 41">
<area href="state_search.cfm?state=MA" shape="rect" coords="599, 56, 621, 69">
<area href="state_search.cfm?state=CT" shape="rect" coords="598, 69, 620, 84">
<area href="state_search.cfm?state=RI" shape="rect" coords="598, 88, 618, 98">
<area href="state_search.cfm?state=NJ" shape="rect" coords="596, 101, 620, 113">
<area href="state_search.cfm?state=DE" shape="rect" coords="597, 117, 622, 127">
<area href="state_search.cfm?state=MD" shape="rect" coords="596, 131, 623, 142"></map><img border="0" src="images/rv_search_map.gif" usemap="#FPMap1" width="640" height="293"></td>
</tr>
</table></td></tr>
</table></td>
</tr>
<tr>
<td> </td>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<th scope="col"><B><FONT size="4">-OR- Search By Association</FONT></B></th>
</tr>
<tr>
<td><img src="images/Associations.jpg" width="800" height="100" border="0" usemap="#Map">
<map name="Map">
<area shape="rect" coords="7,6,81,90" href="asso_search.cfm?franchise=ARVC">
<area shape="rect" coords="89,6,149,95" href="asso_search.cfm?franchise=Yogi%20Bear">
<area shape="rect" coords="160,6,225,93" href="asso_search.cfm?franchise=koa">
<area shape="rect" coords="230,16,411,79" href="asso_search.cfm?franchise=Coast%20to%20Coast">
<area shape="rect" coords="417,16,556,82" href="asso_search.cfm?franchise=good%20sam">
<area shape="rect" coords="564,17,649,82" href="asso_search.cfm?franchise=encore">
<area shape="rect" coords="653,18,796,84" href="asso_search.cfm?franchise=Trav-L-Park">
</map></td>
</tr>
</table></td>
</tr>
<!-- InstanceEndEditable -->
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="5">
<tr>
<th scope="col"><a href="[URL unfurl="true"]http://www.rvingusa.com"[/URL] class="style5">Home</a> | <a href="main_search.cfm">Search</a> | <a href="main/submit.html">Submission</a> | <a href="[URL unfurl="true"]http://www.sepub.com"[/URL] target="_blank"><img src="images/SE-Color-Logo.gif" width="200" height="25" border="0"></a><br>
All Rights Reserved - Southeast Publications USA, inc. - webmaster@sepub.com</th>
</tr>
<tr>
<th scope="col"><!-- InstanceBeginEditable name="bottomheader" --><!-- InstanceEndEditable -->
</th>
</tr>
</table>
</th>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>