Mike, BasicGuide-630.pdf Page:613 " field ID:1005 field name:Query Bar field use: Contains the contents of the Advanced Search Bar. Data Type: Character Length: Unlimited "
Add the above field to the form if it is not already on the form. Add an active link firing on Search that sets a value(Set Field action) to the 'Query Bar' field based on the value supplied in the field. (Example: 'fieldDB_name' = "$fieldDB_name$" ) Note you might actually need two active links, one to just set the 'Query Bar' when it is null and another to append to the 'Query Bar' a value starting in "AND" or "OR" depending on the logic your after for the user. Also if the user leaves the field blank then you might need a different single/set of active links to enter the right value if the user leaves it blank too. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/9/06, Lyons, Michael (USAEOUSA) <[EMAIL PROTECTED]> wrote:
** ARES 6.3 P18 Mid-Tier 6.3 P18 Windows Server 2003 SPA MS SQL 200 SPA Has anyone built a Boolean type search, I have one field that I need to search on, similar to the advance search bar, yet I need to build the query punctuate it and pass it the query bar and have the user submit the query by using the form action Query this is to used on the web with Mid-Tier 6.3 I am desperate for some direction, I am not a programmer, I administer, yet like many of us we are the DBA, developer, and administrator. Any guidance or help would sincerely be appreciated………………. Mike Lyons Remedy Admin
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
