Hi Maureen,
Thank you so much for your help, this was it! when I changed it to
have value instead of the id everything wotked:)
Now I have another problem.
in the form I am using
<cfform action="update_action.cfm" method="Post">
in the update_action.cfm file I am using cfupdate, but I get the error:
The UPDATE fieldname cannot be found in the Artists table.
The error occurred in /Library/WebServer/Documents/Testing/Art/
update_action.cfm: line 11
9 : <body>
10 : You have updated the following information in the in the Artist
database for:</p>
11 : <cfupdate datasource="CF8introArtgallery" tablename="Artists">
12 : The following information was updated
13 : <cfoutput><br />
Now I think that CF is looking for a DB field name of Update, but I
was thinking that cfupdate updated the information already in the
database, so I am confused to why this is happening.
<!--- update_action.cfm--->
You have updated the following information in the in the Artist
database for:</p>
<cfupdate datasource="CF8introArtgallery" tablename="Artists">
The following information was updated
<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>
Thanks so much,
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4505
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
