I am wanting to select all records in a database with a specific suburb name
and then update those records with the region name however for some reason
it does not update them
any ideas
<cfquery name="SuburbDropDown" datasource="australianaccomm">
Select Distinct Suburb
FROM properties
Order By Suburb
</cfquery>
<cfquery name="RegionDropDown" datasource="australianaccomm">
Select Distinct Region
FROM Regions
Order By Region
</cfquery>
<html>
<head>
<title>Queensland</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" background="map/mapwallpaper.jpg" topmargin=0
leftmargin=0 right margin=0 font size="+0">
<center><table width=95%>
<td align=center width="38%" valign=top>
<cfform action="multiupdateresults.cfm" method="POST">
<table border="0">
<td><center>
<font size="+1" color="#000099">Add To Multiple
Records</font>
</center></td><tr>
<td><b>Suburb</b><br>
<cfselect name="Suburb" value="SuburbDropDown.Suburb"
size="1">
<option></option>
<cfoutput query="SuburbDropDown">
<option>#Suburb#</option>
</cfoutput>
</cfselect>
</td>
</tr>
<tr>
<td><b>Area / Regions</b><br>
<cfselect name="Region" value="RegionDropDown.Region"
size="1"><option></option>
<cfoutput query="RegionDropDown">
<option>#Region#</option>
</cfoutput>
</cfselect>
</td>
</tr>
<td>
<input type="submit" value="Search"
name="submit">
<input type="reset" value="Clear Form" name="reset">
</td>
</table>
</cfform>
</td>
</table>
</center>
</body>
</html>
<body bgcolor="#FFFFFF" background="map/mapwallpaper.jpg"
bgproperties="fixed" topmargin=0>
<cfupdate datasource="australianaccomm" tablename="properties">
properties
Set region = '#form.region#'
Where suburb='#form.suburb#'
</cfquery>
<meta http-equiv="refresh" content="0;URL=multiupdateform.cfm">
Kind Regards
Claude Raiola
E-Mail: [EMAIL PROTECTED]
Website: www.internetgoldcoastproperties.com.au
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
