Hi,
I found this quote in the docs for MX 6.1 under 'composing search expressions':
"if a document field named DATE is defined, you can search for documents dated
prior to and including December 31, 1999 by entering DATE <= 12-31-99 in your
search."
Now, if this is true, theoretically I could return a query with a date I want
to search by, and when I do my cfindex, I would specify it like this?
<cfindex query="query"
collection="collection"
action="update"
type="custom"
key="key"
title="title"
body="body,date"
custom1="custom1"
custom2="custom2"
>
Then, when I search on this index, i could say search for: "stuff AND DATE >=
01-01-05" This would return only the documents which have a 'date' greater
than Jan. 1 of this year AND have the word 'stuff' in them.
Now, here's my problem...it seems that Oracle won't allow me to alias a column
in the table I'm getting the query from as 'DATE'. So, I tried this with the
actual date field, call it 'DateField' and did my index like this:
<cfindex query="query"
collection="collection"
action="update"
type="custom"
key="key"
title="title"
body="body,DateField"
custom1="custom1"
custom2="custom2"
>
So, then I tried the query but used DateField >= instead of DATE >= and it
still doesn't work.
So now I'm beginning to wonder if there is there a way to query a collection by
a date field. If so, what am I doing wrong?
Thanks,
Dave
******************************************************************************************
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215672
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
