• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 129
  • Last Modified:

Adding information to a field

I have a field that I want to be able to add information to.
i.e. a complaint is entered with specific information on a subject, and the person realizes that they forgot an important piece of information.  I want them to be able to go back to the field and add to the end of it without overwriting the data that is in it.
0
wilnat
Asked:
wilnat
  • 4
  • 2
  • 2
1 Solution
 
bigbadbCommented:
do you want to display the orginal information in the field or do you want a new field which is initally empty
0
 
cookmysterCommented:
have another section.. draw the info out of the database.. and have an update button, and the just run a sql statement.. that will update the info... that is the easiest way to do it
0
 
wilnatAuthor Commented:
I post the information and then take the next input and combine them and store them back to the original field.

i.e.

you last note.
(data)

your update.
(data)
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
wilnatAuthor Commented:
When I tried the SQL it would take the

OldNotes (you last note)

NewNotes (your update)

and either give
the info in "OldNotes" and then NewNotes.

or Oldnotes and then the info in "NewNotes"

Not the info in "OldNotes" and the info in "NewNotes"
0
 
wilnatAuthor Commented:
When I tried the SQL it would take the

OldNotes (you last note)

NewNotes (your update)

and either give
the info in "OldNotes" and then NewNotes.

or Oldnotes and then the info in "NewNotes"

Not the info in "OldNotes" and the info in "NewNotes"
0
 
cookmysterCommented:
????????????????????
0
 
wilnatAuthor Commented:
I got the information from one field and then the field name stored.  Not the information from both fields.
0
 
bigbadbCommented:
can you just cancantenate the values is cf
<cfquery name="query1" ....>
select * from table where rec_id = theoneyouwant

</cfquery>
<cfset total_message = #query1.oldnotes# & #query1.newnotes#>




0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now