RicherD

Hi Unable, I've duplicated my database and loaded it with your samaple data above, and ran the same queries as you. Searching for DFG i get : Your query returned 4 models. DFG1100 34DFG100 12-DFG1100 DFG-100 Searching for DGF i get : Your query returned 2 models. DGF2100 DGF100 Plus, adding a extra record "DXXGXXF100" and searching for DGF : Your query returned 3 models. DGF2100 DGF100 DXXGXXF100 I can't replicate those last results via CDML without using javascript, but i'd be very interested in a purely-filemaker solution. I'm using Filemaker 6 which may be the difference, if you're interested i will PM you a URL to my dev machine and you can try it yourself. All the best

Hi Guys, The search term submitted does have an asterix at the start, ie. *D*F*G*1*0*0* You'll see it set in the javascript when the variable is declared : var newtext = "*"; I hadn't thought about the leading character issue, I can see the logic where Filemaker *could* consider it invalid... but yes, it seems to work just fine. Thanks again for the responses, you've been most helpful

Good job you're *not* a betting person then Unable I've got it working as desired using a simple javascript hack. The visitor enters the model number in a form input field, which is then processed via javascript on submit to include '*' before and after each character. A hidden field called 'model' (the database field) is then allocated the new search string, and the form submitted (thus hiding the '*'s from the end user). Tested in ie / opera / mac ie / safari and works seamlessly... so fingers crossed. Thanks for all the suggestions guys

Hmmm, thinking more about your post Garry, i think a simple javascript could be answer. Inserting a '*' before and after each character on the form should do the trick... Ie. 'DFG100' would become '*D*F*G*1*0*0*' That would find the matching records. Think i may have it cracked now, thanks again guys

Thanks for the responses guys Looking back it seems i got my example muddled up (it was late ) it should have read : So, 'DFG100' would return: DFG-100, DFGQ100, DFG1100 but not DGF100 The basic rule is to find results with matching characters in consecutive order. Using a calculation to create all possible combinations seems a good idea, i will definately try this. The product codes are around 6-8 characters in length, with a minimum search length of 3 chars there will be a lot of combinations to create!

Hi all, A client has requested a 'intelligent' search feature for their website which has me slightly stumped. The theory is this: Customer enters product code in search box, the web site returns all results with matching characters in consequtive order... without necessarily being the same string. So, 'DFG100' would return: DGF-100, DFGQ100, DFG1100 but not DGF100 I've been thinking of performing a 'findall' request then sending the search term to the results page as a token, then displaying the valid hits using a pattern count if statement / inline action... although i'm not sure this is feasable / efficient. Anyone out there with experience of this problem? I've been looking for some kind of plugin / code but not had much luck... Any advice greatfully received, thanks