Are you meaning UPDATE the data base?
KM
Interent Gold Coast Properties wrote:
> 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.
------------------------------------------------------------------------------
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.
