yoshismokey
Programmer
I have a field "notes" that I would like to allow the users to add to without overwriting the last note added. Is there an easy way to do this in SQL?
Here is the code I have so far:
<cfquery name="UpdateApproval" datasource=#MM_connproducts_DSN# username=#MM_connproducts_USERNAME# password=#MM_connproducts_PASSWORD# debug="yes">
UPDATE APPROVALS Set OTI_VP_Name = '#form.OTI_VP_Name#', OTI_VP_Email='#form.OTI_VP_Email#' ,CS_Name='#form.CS_Name#', CS_Email='#form.CS_Email#', Updated_Date='#today#', AddedNotes= '#form.Notes#'
Where Transaction_Number = '#form.Transaction_Number#'
</cfquery>
Thanks in advance.
Here is the code I have so far:
<cfquery name="UpdateApproval" datasource=#MM_connproducts_DSN# username=#MM_connproducts_USERNAME# password=#MM_connproducts_PASSWORD# debug="yes">
UPDATE APPROVALS Set OTI_VP_Name = '#form.OTI_VP_Name#', OTI_VP_Email='#form.OTI_VP_Email#' ,CS_Name='#form.CS_Name#', CS_Email='#form.CS_Email#', Updated_Date='#today#', AddedNotes= '#form.Notes#'
Where Transaction_Number = '#form.Transaction_Number#'
</cfquery>
Thanks in advance.