I am in the process of creating a web-based database running on FM server 5.5 on a Mac (if that makes a difference).

Guest users will be allowed to search through the database (having registered a username/password programmatically).

My question is this: does anyone know a good way to log what searches they perform in a separate database so that i can see which queries are most popular - so that for instance I could hardcode those searches for a 'quick search' page.

Thanks in advance.

Graeme

No problem, you can log all reply pages with single line of Inline tags. It was already discussed here...

Thanks, but I can't find it in the archives. Could you give me an idea when the discussion took place etc. so I can gain from the previous chats.

Thanks a bunch.

Graeme

The search engine found 70 inline threads.

Oh well, my code is:

code:

---

[FMP-InlineAction: -db=prtzlog.fp5, klic={CurrentToken: 3}, TZnSz=AKS, -New] [/FMP-InlineAction]

---

That will create new record in prtzlog.fp5 and populate fields klic and TZnSz vith variable {CurrentToken: 3} and with static value AKS. The record have autoenter creation date/time.

Thanks, but I was not clear in my original query. Yes Anatoli, that is how you use inline to create a record in a separate database, but how do I capture the search criteria being deployed as it may be embedded inside the URL or have been passed to FM via a form?

I'm sure it's got something to do with the way that html is sent to the servier (or something) but I'm no web expert.

Graeme

code:

---

Repeats the HTML between [FMP-CurrentFind] and [/FMP-CurrentFind] for each find criteria that was part of the request that created this page.

---

Will this be OK (it is from CDML database)?

Brilliant Anatoli!

I saw it in the reference database a while ago but it did not stay in my head

Thanks a bunch!

Graeme

BTW, I was living in London for 11 years so I owe something to you all Londoners! Beautiful City!

Hey, straight back to you: I was taken to Prague for my 30th birthday and it's a fabulous, beautiful city.

Graeme

BTW I've just thought of another way which I'll share:

[FMP-Link: drlsmkta]

This creates a string starting with 'FMPro?' and followed by the find criteria in URL format. So it is a simple job to shove that in a logging database with minimal back-end processing.

Graeme

quote:

---

Originally posted by graemeaustin:

Hey, straight back to you: I was taken to Prague for my 30th birthday and it's a fabulous, beautiful city.

Graeme

---

But you wouldn’t like to live here 11 years on Czech terms and salaries