I'm attempting to search a CFINDEX against three different criteria -
keywords, date range, and category. Here's the index.
-----------------------------------------------
<cfquery name="q_articles"
datasource="#application.db_dsn#"
dbtype="#application.db_dbtype#">
select * from articles a
where a.published = 1
order by a.date_entered, a.section_id
</cfquery>
<cfindex action="update"
type="CUSTOM"
title="Articles"
query="q_articles"
collection="articles"
custom1 = "date_entered"
custom2 = "section_id"
key="article_id"
body="synopsis, article_title, article_body">
-----------------------------------------------
Now, the user has three fields to enter criteria from: a text box for
keywords, a drop down to specify a date range (values = 1, 2, 3, 6, 12),
and a drop down to specify a category. Here's the search I'm trying to
perform.
-----------------------------------------------
<cfset dateRestriction = DateAdd( "m", "-" & #self.date_check#, now() )>
<cfsearch collection="articles"
name="article_search"
type="EXPLICIT"
criteria="#self.keywords# AND (custom1 > #dateRestriction#)">
-----------------------------------------------
As soon as I add the custom1 > #dateRestriction#, I get zero results. If
I leave that out, I get a valid resultset. Perhaps I'm not understanding
the VSQL. Is that date check statement valid?? Also, the dateRestiction
field is working correctly, here's an example value of it: {ts
'2001-03-08 09:57:25'}
Hoping that someone has performed advanced Verity searches like this
before. Any help would be immensely appreciated.
================================
Steven R. Brownlee
Lead Technologist
Mind Over Media
200 First Street
Pittsburgh, PA 15222
P: 412.471.9590
F: 412:471.9591
E: [EMAIL PROTECTED]
W: http://www.momknows.com/
================================
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
