Hey Bob, I'm using an Access DB right now, and the projected amount of data could be up to 2048 characters. At least thats were I have the limit set right now. Yes, the users would probably be adding to the record with notes about the account, but probably not on a regular base.
Your suggestion seems like that would probably work. I'll play around with it and let you know how it goes. Thanks!!!! >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:2060 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
