I have multiple query based verity indexes setup on a server. Unfortunately if I don't use verity the return time on a straight query is ridiculous because of the amount of info being searched. Below are several pieces of code ... the first block works fine and the second block doesn't. If I hardcode the state into the second query (the one that doesn't work with verity) it returns the expected results (after much twiddling of thumbs). The information that I hardcode into the query is exactly what comes across on the url. I've tried everything I can think of to fix the problem but am at my wits end. If anyone can help it would be greatly appreciated. Thanks ____________________________________________________ This works: ----- Refresh the Index ----- <cfquery name="Last_Name" datasource="iMIS_Prod"> SELECT ID, LAST_NAME FROM iMIS.Name WHERE (status = 'A')</cfquery> <cfindex action="Refresh" collection="MemberSearch_LastName" key="ID" type="CUSTOM" title="ID" query="LAST_NAME" body="LAST_NAME" language="English"> ----- Search based on form submitted with get ----- <CFSEARCH NAME="DoSearch" COLLECTION="MemberSearch_LastName" TYPE="Simple" CRITERIA="#url.LastName#"> ____________________________________________________ This Does not work: ----- Refresh the Index ----- <cfquery name="STATE_PROVINCE" datasource="iMIS_Prod"> SELECT ID, STATE_PROVINCE FROM iMIS.Name WHERE (status = 'A')</cfquery> <cfindex action="Refresh" collection="MemberSearch_StateProvince" key="ID" type="CUSTOM" title="ID" query="STATE_PROVINCE" body="STATE_PROVINCE" language="English"> ----- Search based on form submitted with get ----- <CFSEARCH NAME="DoSearch" COLLECTION="MemberSearch_StateProvince" TYPE="Simple" CRITERIA="#url.state_province#"> ____________________________________________________ But this does: <cfquery name="STATE_PROVINCE" datasource="iMIS_Prod"> SELECT ID, STATE_PROVINCE FROM iMIS.Name WHERE (status = 'A') and state_province='AK'</cfquery> ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
