There is a way to 'OR' fields in the Studio. Even though the Wizard displays
a dropdown list of fields to select from, you can actually type in left
parenthesis in front of a field. Note, that you have to enclose your 'OR'
expression in parenthesizes.
You can also have a 'IN' expression. Just type 'in' instead of selecting
from the dropdown list of operators.
Hope this helps,
Oleg Fonarev.
-----Original Message-----
From: Mathew, Aby [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 10, 1999 10:15 PM
To: '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'
Subject: Re: [ND] How to OR fields on search page?
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]
_________________________________________________________________________
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]
