Re: How to modify automatic queries created by FormBuilder

>Hi,
>
>I have created a Form using FormBuilder. Everything works fine, but now
>I'd like to implement a special query:
>When you enter for example '100' in the field PRICE and you press the
>'Query'-button, all matching entries in the database are found.
>Now I'd like to display those data too whose PRICE equals '-100' (and
>vice versa).
>To sum it up:
>I want to modify the original query created by formbuilder
>(something like: select * from table where table.price = 100)
>into
>(select * from table where abs(table.price) = 100).
>But how can I do this?
>
>Thanks

By using the PRE-QUERY trigger, you can change the query constructed, either by adding/values to field items, or by modifying the block property DEFAULT_WHERE

Dan Hekimian-Williams Received on Tue Aug 08 2000 - 00:00:00 CEST