Solved

Add additional text to a field

Posted on 2007-11-28
2
133 Views
Last Modified: 2013-12-24
I have a query insert that I am using to copy a record. Is there a way in ColdFusion that I can add additional text to a field. For example I have a description field and I would like to add "Copy of" at the head of this field.
0
Comment
Question by:usky1
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 300 total points
Comment Utility
You could modify your query to append the value.  The exact syntax may be database dependent

<cfquery ...>
    INSERT INTO YourTable ( ColumnA, DescriptionColumn)
   SELECT   ColumnA,  'Copy of'+ DescriptionColumn
   FROM      YourTable
   WHERE    ID =   #IDOfOriginalRecord#
</cfquery>

0
 

Author Comment

by:usky1
Comment Utility
Works great. Thanks.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now