The only option seems to be to do things manually. Unbind those
fields, construct that part of the Where clause with 'OR' or 'IN' and do
addDynamicStrCriterion();
Aby
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 10, 1999 8:47 PM
> To: [EMAIL PROTECTED]
> Subject: [ND] How to OR fields on search page?
>
> I want to have several text boxes on a search page, and the
> values used as ORed items against one db column - ie:
> tbNAME1 tbNAME2 tbNAME3 [SEARCHbutton] [RESETbutton]
> and the results set should contain any records with
> NAME1 OR NAME2 OR NAME3 in the NAME column.
> I have bound text boxes to the NAME column on a search form,
> but they will only AND the text box items (which results in
> nothing being returned).
>
> What is the recommened method for setting up this "OR"
> relationship in an ND search page?
>
> Thanks in advance,
>
> Graham Tipper
>
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
