Mark, First a question or two on your db and the projected amount of data being inserted, are you using access/mysql/mssql or what? Is this something you'll be adding to on a regular basis? I'm thinking off the top of my head maybe doing a query first to pull the existing data, then dump it into a variable, then append your form data to that before your insert? It may be that the best way would be to add a separate entry for each since you mentioned adding date/time to each entry to track them. This way you could pull and display according to date/time and sort the output?
Bob -----Original Message----- From: Mark Brown [mailto:[EMAIL PROTECTED] Sent: Sunday, September 17, 2006 8:45 PM To: CF-Newbie Subject: Append Data to a DB question Hello, First time poster, long time view here. This is probably a very easy question maybe bordering on a dumb question, but I'll ask it anyway because I'm kinda lost at this point. I've got a notes field that I want to update/append too. I'm using regular html forms, to talk to a page that does the cfupdate to the database for the fields. The notes field is a bit different in that it is a text area to type in, were as the all the other fields are just text fields. When ever I type in it and click my update button it wipes out the text that was orginally in the database record and writes the new text in that record. I'm trying to get it to just append the new text to the end of the notes column in the datbase, not replace it. I would also like to date/time stamp the update so the user can see when the notes were added, but that a question for another day, unless it's really easy to do. Any help you all could lend would be muchly appreciated. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2059 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
