What I'm after is trying to check the value that is coming from the query for the value "McsalProjNumb" that you're using in your form in the input:
<input type="text" name="McsalProjNumb" id="UPMcsalProjNumb" size="15" value="#McsalProjNumb#"> Isn't that the line you said the error message is referencing? Also, put <cfabort> right after the <cfdump...> to prevent the rest of the page from running and see what the McsalProjNumb value is returned as in the query. Rick -----Original Message----- From: Brett MacDonald [mailto:[email protected]] Sent: Friday, January 29, 2010 12:38 PM To: cf-newbie Subject: Re: error in posting form? Adding that code right after the 5th line of my code made it print out the entire array. My code then popped out the array again (so it was on the page twice) only with the text fields for updating the one row as well. When I hit update i get the error and it never makes it to the next page. Running the page again it dumps the array again and no values have changed so I'm pretty sure it's never even making it past the form. Thanks for the help by the way! >If you do run: > ><cfdump var="#Project_Info#"> > >right after your run your query, does all the data look correct? > >Rick > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4963 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
