Ray,
PROBLEM SOLVED!!!! Here's how I ended up doing it:
First, I had to store my 'modifiedDate' value in custom1 with an identifier
(since I was already using custom1 and custom2 for other values), so it looks
like this:
custom1= "identifier|mm/dd/yyyy|"
Then, before my CFSEARCH, I created 7 variables with the last 7 days in them
respectively formatted like this:
Day0 = |08/19/2005|
Day1 = |08/18/2005|
Day2 = |08/17/2005|
and so on...
Then, my <CFSEARCH tag ended up looking like this:
<cfsearch collection="#TheCollection#"
name="getSearchResults"
type="explicit"
criteria='(<MANY><STEM>#UCase(url.criteria)#) AND
((cf_custom1 <SUBSTRING> #day0#) OR
(cf_custom1 <SUBSTRING> #day1#) OR
(cf_custom1 <SUBSTRING> #day2#) OR
(cf_custom1 <SUBSTRING> #day3#) OR
(cf_custom1 <SUBSTRING> #day4#) OR
(cf_custom1 <SUBSTRING> #day5#) OR
(cf_custom1 <SUBSTRING> #day6#) OR
(cf_custom1 <SUBSTRING> #day7#)
)'>
And finally...it works.. I need no Query of Queries anymore and I avoided
creating two separate collections.
The keys to this solution were twofold. One, you have to use 'cf_' prefixed to
your cfsearch results field (i.e. cf_custom1, cf_title) to search it. I found
this FINALLY in the docs, and of course the other was figuring out how to store
the date in a field that was already occupied, and by using the pipes, I can
properly identify the date now.
Dave
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 9:46 AM
To: CF-Talk
Subject: Re: cfindex/cfsearch help with dates
Actually, you can use the CUSTOM1 field instead. The only difference
is how you run your cfsearch.
******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215795
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
