Question

I want to search a form for data like a database with a "WHERE" clause. I have a field called "Algorithm" on my "SubmitCodeForm". I have a value on one of the forms called "MyNewAlgorithm" which should be the only result of the search. I tried using the search below (among many others):

I added a Z because otherwise it was rendering the search!

ZSEARCH{ "[S]ubmitCodeForm.[A]lgorithm = "MyNewAlgorithm"" scope="text" regex="on" nosearch="on" nototal="on" format="| $formfield(Algorithm) |" }%

Environment

-- OmarMussa - 29 Jul 2005

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Might be worth trying this out:

%SEARCH{ "[Algorithm].*value\=.*MyNewAlgorithm" scope="text" regex="on" nosearch="on" format="| [[$topic]] |" }%

Enclosing code in verbatim tags will get you out of the problem of having to use a z creatively.

-- SueLocke - 29 Jul 2005

Thanks!! This really helped. I redid my search to now return the field data using:

%SEARCH{ "[Algorithm].*value\=.*MyNewAlgorithm" scope="text" regex="on" nosearch="on" format= "| $formfield(Algorithm) |"}%

-- OmarMussa - 29 Jul 2005