Hi Guys, With the CFSearch/CFCollection engine, Lucene, is it possible to have more than 4 custom fields? I'm creating a search engine for car ads and it works, but I want to ad some more defined sorting elements.
With my current setup, price, date, and postal all have their own custom fields, and it is easy to sort by these columns. I could use a comma seperated list in a single custom field, but then processing needs to be done on every row to search for a match, and I'm afraid it would have severe effects on the efficiency. Here is the CFINDEX update statement as I have it now. Is there any way to add more custom fields, aka custom5, custom6, etc. ?? <cfindex action="update" collection="vehicles" type="custom" key="#CID#" title="#index_ad_core.title#" URLpath="#index_ad_core.thumbnail_url#/ xs_#index_ad_core.thumbnail_file#" body="#index_ad_description.description#, #index_ad_core.summary_a#, #index_ad_core.summary_b#, #index_ad_core.summary_c#, #index_ad_core.price#, #index_ad_core.currency#, #index_address_lookup.city#, #index_address_lookup.state#, #index_address_lookup.country#" category ="#index_category_lookup.category_name#" custom1 = "#index_ad_core.created#" custom2 = "#index_ad_core.price#" custom3 = "#index_zip_lookup.postal#" custom4 = "#index_address_lookup.city#, #index_address_lookup.state# - posted by #user_name#" > -- tag/function ref: http://www.openbluedragon.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en Get to Texas in Feb for OpenCFSummit http://www.opencfsummit.org/
