Home » Developer & Programmer » Forms » Query
Query [message #205240] Fri, 24 November 2006 00:53 Go to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi,
There is a query like this.
These are some order details. Every person will have a unique order id,telephone and customer id.

select * from orders where order_id=11 and telephone=2323234 and customer_id=123451;

I am using omniportlet and simple parameter form...Simple parameter form to pass the parameters and omniportlet to display the data.
I want my query to work like this.
In my simple parameter form, I can select all the 3 parameters and get the result ie 1 row for that particular sale. Or I will just enter any one of the parameter values and get the result.
How should I frame my query.

Re: Query [message #205391 is a reply to message #205240] Fri, 24 November 2006 07:43 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi,

if you can tell me what is 'omniportlet' then i might help you ...

Bye
Ashu
Re: Query [message #205624 is a reply to message #205240] Sun, 26 November 2006 21:18 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have an 'omniportlet' manual? Are there any examples in it? Does Forms know about the directory in which you have placed the 'omniportlet' code?

David
Previous Topic: PLSQL-Webservice
Next Topic: calling forms using parameters
Goto Forum:
  


Current Time: Tue Dec 06 02:42:45 CST 2016

Total time taken to generate the page: 0.22975 seconds