Well, there are several ways this could be done. Here are just a couple:
get the existing database value and add to it as follows:
<cfset updatedList = myquery.fielddata & "delimiter-of-your-choice" & #form.additions#>
then do an update to the table, setting table.fieldname = '#updatedList#'
or plop the existing data into a list or array and append to it using the ListAppend
or ArrayAppend function, then update the table field with the updated list/array.
I'm sure there are other ways, and I don't know which of the two above will process
more quickly - sorry I can't be of more help.
Brenda
Jamie Symonds wrote:
> This is a multi-part message in MIME format.
> --------------0744F58F5C26C4A7D1D9CDD6
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hello everyone - thanks for provind an interesting list to
> read. I have now summoned the courage to make a posting,
> here's my question:
>
> I have a web application where a user can enter information
> (mainly from their CV) into a form where it is then inserted
> into a table in my database. The user (plans are for a
> yearly update where it's a CV we're dealing with) can return
> to the web site anytime in the future and make additions to
> her/his data. I have accomplished this (using VALUE=, etc.)
> with my text input fields and text areas (still a little
> trouble showing a checked radio button from the query but
> that will come in time). My trouble is that while I want
> the user to add info to that info currently on file, I do
> not want to user to be able to edit the information
> currently on file - I simply want the new data appended to
> the top of the exisiting information (for example, there's a
> "publications" field - they could see the publications from
> previous years, and add this years' to the top of that
> textarea without being able to edit the old data). I'm sure
> that there is a simple and easy solution to this?
>
> this years' info + info currently on file = updated field in
> database
>
> Thanks in advance for any assistance offered.
>
> Jamie
>
> --------------0744F58F5C26C4A7D1D9CDD6
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Symonds, James A.
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: James A. Symonds
> n: Symonds;James A.
> org: Comp&Tech Crdntr, StFX Students' Union; Intern w/Prof. Blackwell;
>Intern w/Acdmc Fndng & Rsrch; TSG Lab Assistant
> adr: Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada
> email;internet: [EMAIL PROTECTED]
> title: Bachelor of Info Sys, Major (student)
> x-mozilla-cpt: ;0
> x-mozilla-html: TRUE
> version: 2.1
> end: vcard
>
> --------------0744F58F5C26C4A7D1D9CDD6--
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
