You are setting the id's of the form fields to the data you are retrieving instead of the value.
example: <cfinput type="Text" name="FirstName" id="#FirstName#" size="50"> Should be <cfinput type="Text" name="FirstName" value="#FirstName#" size="50"> On Fri, Apr 10, 2009 at 12:29 AM, John Barrett <[email protected]> wrote: > > I am having a issue with a cffform trying to update a db. When I did this > with an html form there was no problem, and I can't figure out why I can get > the ID, but not the rest of the data. > > Any help is greatly appreciated, > Thanks so much > John > > <!---index.cfm---> > <cfquery name="GetArtists" datasource="CF8introArtgallery"> > SELECT ArtistID, FirstName, LastName > FROM Artists > ORDER BY ArtistID ASC > </cfquery> > > <table> > <tr> > <th>Artists ID</th> > <th>First Name</th> > <th>Last Name </th> > <th>Action</th> > </tr> > <cfoutput query="GetArtists"> > <tr> > <td>#ArtistID#</td> > <td>#firstname#</td> > <td>#lastname#</td> > <td><a href="updateform.cfm?ArtistID=#ArtistID#">Update</a> | > <a href="deleteform.cfm?ArtistID=#ArtistID#">Delete</a></td> > > </tr> > </cfoutput> > <tr> > <td><a href="insert_form.cfm">Add a new record</a></td> > </tr> > </table> > > <!---updateform.cfm---> > <cfquery name="qGetArtists" datasource="CF8introArtGallery"> > SELECT * > FROM Artists > WHERE ArtistID = #URL.ArtistID# > </cfquery> > > <table> > <cfoutput query="qGetArtists"> > <cfform action="update_action.cfm" method="Post"> > > > <tr> > <td width="93">Artists ID</td> > <td width="286"><cfinput name="ArtistID" type="text" value="#ArtistID#" > size="25"></td> > </tr> > <tr> > <td>First Name </td> > <td><cfinput type="Text" name="FirstName" id="#FirstName#" size="50"></td> > > </tr> > > <tr> > <td width="111">Last Name </td> > <td width="457"> <cfinput type="Text" name="LastName" id="#LastName#" > size="50"></td> > </tr> > <tr> > <td>Address</td> > <td> <cfinput type="Text" name="Address" id="#Address#" size="50"></td> > </tr> > <tr> > <td width="111">City </td> > <td width="457"> <cfinput type="Text" name="city" id="#city#" > size="50"></td> > </tr> > <tr> > <td>State</td> > <td> <cfinput type="Text" name="state" id="#state#" size="50"></td> > </tr> > > <tr> > <td>Postal Code</td> > <td> <cfinput type="Text" name="PostalCode" id="#PostalCode#" > size="50"></td> > </tr> > > <tr> > <td>Email</td> > <td> <cfinput type="Text" name="Email" id="#Email#" size="50"></td> > </tr> > > <tr> > <td>Phone</td> > <td> <cfinput type="Text" name="Phone" id="#Phone#" size="50"></td> > </tr> > > <tr> > <td>Fax</td> > <td> <cfinput type="Text" name="Fax" id="#Fax#" size="50"></td> > </tr> > > <tr> > <td>Password</td> > <td> <cfinput type="Text" name="thepassword" id="#thepassword#" > size="50"></td> > </tr> > > <tr> > <td> </td> > <td><cfinput type = "submit" name="update" class="button" value = > "Update"></td> > </tr> > </cfform> > </table> > > </cfoutput> > > <!--- update_action.cfm---> > <cfupdate datasource="CF8introArtgallery" tablename="artists"> > > <!--- display the tip that was entered into the database---> > The following information was written to the Database > <cfoutput><br /> > FirstName - # FirstName# <br /> > LastName - #LastName# <br /> > Address - #Address# <br /> > City - #City# <br /> > State - #State# <br /> > Postal Code - #PostalCode# <br /> > Email - #Email# <br /> > Phone - #Phone# <br /> > Fax - #Fax# <br /> > password - #thepassword# <br /> > </cfoutput> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4501 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
