Hi everyone!
Here is my simple query for data with which to refresh my collection:
<CFQUERY NAME="GetData" DATASOURCE="MyDatasource">
SELECT PERSON_ID, FIRST_NAME, LAST_NAME
FROM TBL_PERSON
</CFQUERY>
<CFINDEX
COLLECTION="Directory"
ACTION="refresh"
TYPE="Custom"
BODY="PERSON_FIRST_NAME, PERSON_LAST_NAME"
KEY="PERSON_ID"
QUERY="GetData">
And here is the search
<CFSEARCH COLLECTION="Directory"
NAME="SearchDirectory"
CRITERIA="%#Criteria#%">
...all pretty straightforward - and searching is fine. I can search for
John Doe, John, Doe, John AND Doe, John OR Mary, etc...
But for some reason, I cannot search for %ohn or Jo*
Anybody know if I am missing something?
Thanks!
-J
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
