Have you tried just using "*" as your search term? This will always return
an object (that is, if everything is working properly)
L.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Spectra-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 1:07 PM
Subject: Antwort: RE: search and replace
>
>
> hi raymond,
>
> that's the problem. i've tried cfa_contentobjectfind and this one:
>
> <cfa_typesearch
> datasource="odbc1"
> typeid="0006A8A0-D535-19AB-A5D380C32AB6FCB0"
> searchterms="href"
> bdistinctobject="No"
> bactiveonly="No"
> r_qresults="myQResults"
> r_stresults="myStResults">
>
> there must be hundreds of matches. but return value is empty. can you see
what'r wrong with this?
>
> guido franz
> germany
>
>
>
>
>
>
> "Raymond Camden" <[EMAIL PROTECTED]> am 23.03.2001 14:57:20
>
> Bitte antworten an [EMAIL PROTECTED]
> Telefonnummer f�r R�ckfragen:
>
> An: Spectra-Talk <[EMAIL PROTECTED]>
> Kopie:
> Thema: RE: search and replace
>
>
>
> Well, normally you don't want to write your own SQL. What you should do is
> use ContentObjectFind to get the obs you want, loop through the results,
> and
> then use contentObjectData to update the objects.
>
>
>
======================================================================Raymon
d Camden, Principal Spectra Compliance Engineer for Macromedia
>
> Email : [EMAIL PROTECTED]
> ICQ UIN : 3679482
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 23, 2001 8:45 AM
> > To: Spectra-Talk
> > Subject: search and replace
> >
> >
> >
> > Hello,
> >
> > I want to replace strings in spectra objects. Therefore I need a
> > SELECT and
> > UPDATE statement, but I don't know the database model. Can anyone tell
me
> > table and field names, where I can find all relevant (text)
> > object content?
> >
> > Thanks,
> > Guido Franz
> >
> >
> > Internet communications are not secure and therefore MERCK FINCK &
> > CO does not accept legal responsibility for the contents of this
message.
> > Any views or opinions presented are solely those of the author and do
> > not necessarily represent those of MERCK FINCK & CO unless
> > specifically stated.
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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.
