Storing a web find request

[eguzman]

Perhaps sounds something crazy...

Is there a way to store a web find request and put it in a field in the database been used :

Thanks

[Garry Claridge]

If you have a field named "find_url" you could use:

<input type="hidden" name="find_url" value="[FMP-Link: ]">

<input type="hidden" name="-recid" value="[FMp-CurrentRecID]">

<input type="submit" name="-edit" value="Update Record">

</form>

Hope this helps.

Garry

[eguzman]

The objective at the end is to highlight the query in the result page (results.html)

This is part of the code I have (in search.html) :

Title :<INPUT TYPE="text" NAME="title" SIZE="30">

Content :<INPUT TYPE="text" NAME="note" SIZE="30">TYPE="submit" NAME="-find" VALUE="FIND"><INPUT TYPE="reset" VALUE="CLEAR">at I want to do is to store the find request that searches the "note" field (<INPUT TYPE="text" NAME="note" SIZE="30"> named "store_note" in the database.

Any work around?

Thanks

[Garry Claridge]

You can use the [FMP-Link: ] tag in your results.html page and it will show the url used to call the results.html page. For example:

<b>Results from [FMP-Link: ]</b><br>

Good Luck.

Garry

[Vaughan]

You want the search word made bold in the returned text, right? I've not done this, but here's a method that might work...

The process would be to perform the find, then (somehow) insert the search word into a global field: the global field is used in a calculation field that uses Substitute[] function to parse the data int he text fields and add <b> and</b> tags either side of the word. The results of this calc field are then returned to the web user.

The challenge is that this could be a two- or three-step process because it involves a find and an -edit action, and they cannot be done simultaneously. Meta-refresh or JavaScript alternatives could solve this.

I could see it going something like this: user types word and clicks SUBMIT button to perform -Find action. Web Companion processes find and returns results, meta-refresh then edits global field... ******* it's not going to work because there is no guarantee that the state of the database won't change between the steps. Between the return of the -find and the meta-refresh there could be a dozen other -finds.

I think this is one time where a script will be necessary. <shudder> In this case the process would be different: the submitted search word edits the global field and runs the script, the script performs the find based on the global field, then the data from the calculation field is returned. this all happens in one hit so it'll be robust. But I hate relying on scripts over the web.

As I said first up. I've never done this -- partly because it has always seemed to me that it's very difficult to do and (at least in FMP) not very elegant over the web.

[eguzman]

Thanks for your tips.

the steps I have are something like you mention, but the tricky part is the first one, storing the find request and put it in a global field, I tried various methods with CDML but none of them work.

It seems that the answer is in the October 99 issue of the FileMaker advisor magazine, an article from Chris Moyer, clearly states : "Highlight a CDML find request"

I have the option of buy that years compilation of articles, but I want to dry out my/your brains before doing so.

Thanks