No...they would want to be able to do all things at once. SO the form would have to look like
Equipment Type Hours -------------------------------------- [combo box] [txthours] [combo box] [txthours] [combo box] [txthours] [combo box] [txthours] [combo box] [txthours] [combo box] [txthours] [Submit][Reset] And now from the database..we could have Equipment Type Hours ------------------------------------- Bulldozer 5 Crane 6 [combo box] [txthours] [combo box] [txthours] [combo box] [txthours] [combo box] [txthours] [Submit][Reset] And you see the rest can be blank. And they might want to Delete BullDozer with 5 hours totally.. Or insert say Digger with 6 hours. While aso changing the 6 hours for Crane to 3 hours because they made a mistake. And then click ONE button and SUBMIT their changes....all from one form :-\ You see? -Gel -----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:58 PM To: CF-Talk Subject: Re: Editing, deleting, and inserting values on form. Why not just put 3 buttons on your page and give them different values. I hope I understood your question correctly. IE: <input type="button" name="action" value="Add"> <input type="button" name="action" value="Update"> <input type="button" name="action" value="Delete"> Then on the processing page, just do <CFIF isDefined("url.action")> <CFIF (url.action) EQ "add"> Run an insert query <CFELSEIF (url.action) EQ "delete"> Run a delete query <CFELSEIF (url.action) EQ "update"> Run an update query </CFIF> ----- Original Message ----- From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 11:24 AM Subject: Editing, deleting, and inserting values on form. > Ok boys and girls, > > I've got a little question for you. > > I have one table, called Equipment..that has EquipID, Equipment > Type,and Hours. > > Now...someone can have equipment entered previously. > OR they might want to insert new equipment, or delete existing > equipment. > > I can't use a grid, because the form requires a Combo box that is > pulled from a database. > > What is the logic behind this..some sort of pseudocode..algorithm or > something. > > I just can't get my head around a simple way to do this. Everything > I'm thinking of seems overly complicated. > > -Gel > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
