After rereading your post, I believe the doc is referring to the indexing of files, like Word docs, that have a date property. I don't believe you can do this with custom indexes.
On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215701 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
