Here's a completely non-COAPI way of doing it. You would need to do the
same code against the extendeddata table as well.
<!--- This code section replaces /frbatlanta/ with / to reflect new
webroot in object table --->
<cfquery name="GetObjects" datasource="Objects">
select objectid, objectdata
from objects
where objectdata like '%whatever%'
</cfquery>
Start - Replace /frbatlanta/<br>
<cfset counter = 0>
<cfif GetObjects.RecordCount GT 0>
<cfoutput query="GetObjects">
<cfset temp_objectdata = ReplaceNoCase(objectdata,
"whatever", "" , "ALL")>
<cfquery name="UpdateObject" datasource="Objects">
UPDATE objects
SET objectdata = '#temp_objectdata#'
WHERE objectid = '#objectid#'
</cfquery>
<cfset counter = counter + 1>
<cfif counter EQ 10>
10 Objects Processed<br>
<cfflush>
<cfset counter = 0>
</cfif>
</cfoutput>
</cfif>
Finished - Replace /whatever/ -
<cfoutput>#GetObjects.Recordcount#</cfoutput> objects processed<br>
"Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
11/25/2002 09:26 AM
Please respond to spectra-talk
To: Spectra-Talk <[EMAIL PROTECTED]>
cc:
Subject: RE: How would I write SQL to get a Spectra object?
to add, it shouldnt be that difficult as long as you know the properties
(especially embedded objects) for each Object.
N
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 25 November 2002 14:21
To: Spectra-Talk
Subject: RE: How would I write SQL to get a Spectra object?
why cant you use the COAPI tags?
-----Original Message-----
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: 25 November 2002 14:23
To: Spectra-Talk
Subject: How would I write SQL to get a Spectra object?
Hi,
I need to write a process that will open up every content object in our
CODB, do something to it (replacing text in the main content area), and
then
save that object. Is there an example of how to do this in the
documentation or online?
Using Spectra 1.51, Win2K Server, Oracle 8.1.7
Yes, I know this is dangerous, and yes, I know I need to be careful.
Thanks
Pete
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
