Hi :)
The function which will help u out is NVL. Do like this.
Select field1,field2,field3
from mytable
where field1 = nvl(myinput1,field1) and
field2 = nvl(myinput2,field2) and
field3 = nvl(myinput3,field3)
------------------------------------------
Now what will happen is that when the input vairable is null then field will
be matched with field and if the input vairable is not null then field will
be matched with input varaible.
Hope this gets u started.
In article <35e4b4d6.88482811_at_news.earthlink.net>,
beverett_at_remove_this.usa.net (Brian Everett) wrote:
>
> Greetings All.
>
> I have a table of zip codes and a web form that attempts to query
> the table based on three fields on the form. The user can provide as
> little or as much information in these three fields as they would
> like. Problem: I do not know in advance which fields will be entered.
> How do I structure the select statement (cursor (Oracle)) so that
> fields not entered will not restrict the returned records but field
> which are entered will restrict the output. I've tried a number of
> approaches and some work well but not in every scenario. Since
> there are three fields then there are 8 possible ways inputs can be
> anticipated. I hope I haven't confused anyone. I used to do something
> in Access like this...
> ...where myfield = myinput or myfield is null;
>
> Oracle needs something else it would appear.
>
> Thanks
> Brian
>
> Good Luck! Brian_RestonVA
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Aug 29 1998 - 08:09:26 CDT
