Hmm...darn. That makes sense...
Thanks a lot dude! -Gel -----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Well, I would say that you would need to do this on the processing page. 1. Check to see if the value of the equipmentID exists in your DB and if it does not do an insert of the equipment type and hours. 2. If the value exists then do an update of the equipmentID and hours 3. If I understand correctly they can remove the amount of hours from the txthours field and that should also remove the equipment type for that specific equipmentID <cfquery datasource="yourDsn" name="yourQueryName"> select equipmentID,hours from equipment where equipmentID = '#equipmentID# </cfquery> <CFIF yourQueryName.recordcount EQ 0> Insert the equipment into the table <CFELSE> Update the equipment table </CFIF> <CFIF isDefined("form.hours")> <CFIF (form.hours) EQ ""> Delete the equipment from the table </CFIF> </CFIF> Hope this makes sense Doug ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
