*shrugs* Obviously, you've got something more complicated than what I'm
seeing in my head.
What I was imagining is something more like my situation, where there's
essentially the same information being returned, but from selectable
sources.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: Jeff [mailto:[EMAIL PROTECTED]
: Sent: Friday, August 22, 2003 11:54 AM
: To: CF-Talk
: Subject: Re: Arrrgh, this is driving me crazy, and I know it's so simple
: to do...
:
:
: on 8/22/03 11:38 AM, Ben Doom at [EMAIL PROTECTED] wrote:
:
: > Maybe I'm missing something. I currently have code up in CF 5 as such:
: >
: > <CFSEARCH name="results" collection="#request.collections#"
: > criteria="#request.searchstring#">
: >
: > where request.collections can contain more than one collection, and it
: > searches all of them. I just tested this and it works fine.
: >
: > Has something changed in MX or RedSky? Or is this just a
: problem of habit
: > making people look for complicated solutions?
:
: There's nothing wrong with what you're doing. It's just that each of these
: collections contain WILDLY different data that will determine
: which page the
: results are displayed on. I was following Dave Watts' Solution, but the
: Union of Queries seems like the best one so far, and it's working
: perfectly.
: See, each collection is a Collection on a Query, and I'm assigning "Key,
: Title, Body, Custom1, Custom2" wildly different values. I'm assigning
: custom2 a value when the index is created to flag which table it's coming
: from, then I'm using the key value, the title, and the custom2 to pass
: combined results to a "redirect" page which will perform
: additional queries
: (if necessary, some may be able to simply be passed on with the
: information
: they contain, others may have to have additional queries run to get
: additional information that's required to display that particular
: information).
:
: I was just planning on putting it in a switch statement that will do the
: appropriate redirecting to the appropriate display page.
:
: See, I'm hip to what you're saying, and I *hope* I'm not making it more
: complicated than it needs to be, but I'm indexing about ten
: collections that
: will all contain wildly different information contained in tables
: that will
: need to almost all be displayed differently, but need to be
: searched from a
: single, common interface.
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
