On the page that processes just send over the Unique identifier/primary key - and all the variables. use the <cfupdate tag to update database records. If updating multiple tables - On small forms - I just set a cfupdate tag for each table and enter the values to be updated. Here is an example using access - which I assume since you didn't state any other db
<cfupdate datasource="datasource" tablename="UsersInfo" dbtype="ODBC" formfields="UserName, Location, Email, Address1, Address2, Flr, City, State, Zip, Tele, Fax, CareOf, SpecialInst, PPQuestion, PPAnswer, AirportCode"> <cfupdate datasource="datasource" tablename="Users" dbtype="ODBC" formfields="UserName, Password"> hope this is what you were looking for. jay miller Terry wrote: > Hi-- > > I have a form that displays multiple records populated from the database. Something >like this: > > Department > EmployeeName Add1(text input) Add2(text input) City (text input) > EmployeeName Add1(text input) Add2(text input) City (text input) > . > . > Department > EmployeeName Add1(text input) Add2(text input) City (text input) > EmployeeName Add1(text input) Add2(text input) City (text input) > . > . > etc. > > The question is how to I process this? It passes multiple EmployeeID's (from hidden >field), but only the text input fields if they are populated (they aren't required). > > I think I've done it before, but I'm brain dead today. > > TIA > > Terry > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
