How can I search for only exact match?

[Qbaze]

Hi

I have a db where we (my company) input items in need for repair/service....mobile phones, computers, pda etc. In the db we change the status of the service as we handle the service-item. ie if its: Registred, Repair in progress, Shiped for external service, Finished etc.

I now want the customer to be able to check over internet if theire item are ready. Each post(Service-item) automaticly gets a 7-digit service-number,and I want the customer to search for only that number.

I have got the web companion to wrk and made an own deseigned searchpage but, when I search for only the first number in the servicenumber I get a result (the first post in my db). I only want to get a result when I search for the complete servicenumber. Is that possible? I'm not yet so good with if-statement and other variables on the web. (Within Filemaker I have not such problems)

I had another idea, to put a 4-digit code on each service, so when the customer will search for his item he would have to search in two fields, for the service number AND the 4-digit code, and they both have to match.....otherwise; No result. ....Is that possible to do?

All help and tips are very welcome!

Have a nice day!

Best regards

Andreas from Sweden

[Justin Grewe]

Hi,

What language are you using to publish the search page on the web? Most likely just stick a "==" sign in the search query.

[Garry Claridge]

Try this:

<input type="hidden" name="-op" value="eq">

Enter Service Number: <input type="text" name="servicenumber" value="">

or

<input type="hidden" name="servicenumber" value="==">

Enter Service Number: <input type="text" name="servicenumber" value="">

See which one of these suits your needs.

Good Luck.

Garry

[Qbaze]

Hi

Thanks a bunch for fast replyes!!!

I will try this tomorrow when I get home and see if it works!

Thanks again!

/Andreas

[Steve T.]

Looks like Justin and Garry have already given you what you need, but if you want to read more about it...

http://www.filemaker.com/ti/104829.html

(listed below for the clicking impaired)

Exact Match Finds in Custom Web Publishing

------------------------------------------------------------------------

To perform an exact match find (for example, find Joe Smith but not Joe Smithson) using CDML, use the following pair of tags in your form:

In this example the search field is "Name":

<input type=

[Qbaze]

Hi

Thank you for solving my problem. All is great now. I now made a webpage where customers have to enter their 7-digit servicenumber AND a 4-digit code before they can see the status of their service-item.

I just found this forum a couple of days ago, and I think its so great with people who has the knowledge and that passes it on to others in need.

Next goal is to find out how secure the Filemaker webserver is, and how to get the most secure config.

Thanks!

/Andreas

[Steve T.]

Hi, Qbaze! Yeah, I was really, really happy when I found this site w/such knowledgeable and helpful folks who did not blast people for asking basic questions. I learned most of what I know about FileMaker's Custom Web Publishing and CDML right here in the forums.

Unfortunately, CDML has been dropped from FM7 so many of us will probably have to adapt or see our knowledge fade away. FMP web service has security (both Access Privileges and the Web Security Database) but "how secure it is" is a debatable issue with no end. It's probably better to ask, "is it secure enough for my purposes?" since it is all relative, eh? I had a BIG FileMaker web project I worked on/off for years but I've started to re-write it for php/mysql because I could not get FM security to where I wanted it to be for that particular project, but we still run about 9 different FM web solutions and are happy w/them.

Welcome!

--ST