robeh
Posts: 17
|
| Posted: 11/20/2005, 4:54 AM |
|
I have a search form with three fields. Any one or two could be null. The ones that are not null should be and'ed together. How do I construct the query for this? Can it be done with Visual Query Builder? Using 3.0.
Thanks.
Robert
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 11/20/2005, 5:33 AM |
|
robeh,
Maybe this link will be helpful.
http://docs.codecharge.com/studio3/html/UserGuide/Build...rchBuilder.html
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/20/2005, 12:30 PM |
|
Robert,
I think that this is automatic if you add the three search parameters into your query in VQB. You should only leave the "Default Value" field blank for each of those parameters.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
