I'm not sure about the first part of your question but the second part goes
something like this:
<CFQUERY NAME="Get" DATASOURCE="#DSN#">
SELECT YourField
FROM YourTable
ORDER BY YourPrimaryKey
</CFQUERY>
<CFOUTPUT QUERY=GET>
<CFSET NewVal = ListChangeDelims(Get.YourField, "," , chr(013)chr(010))>
<CFQUERY NAME="Put" DATASOURCE="#DSN#">
UPDATE YourTable
SET (YourField=#NewVal#)
</CFQUERY>
</CFOUTPUT>
This should do it.
Have fun
Chris
-----Original Message-----
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 1:17 PM
To: CF-Talk
Subject: replacing carriage-returns in a db field with commas?
'afternoon everyone,
We are storing meta-tag Description and Keyword information for many of our
documents in a database (MS-Access 2000), so the meta information can be
maintained without having to make changes to a static page. The problem I
am running into is that the individual who entered in the Keywords delimited
them by hitting the Enter key rather than putting a comma in between...will
search engines recognize this? (is it as effective?)
If commas are the recommended route, is there a way in SQL (MS Access) to do
a global replace on that field and replace all the carriage returns with the
normal comma+space delim.? Any pointers would be greatly appreciated!
Cheers,
David
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
