Re: Please Help Need Search Stored Proc
Either in PHP or in the sproc, you need to write logic which assembles the query's WHERE clause, eg skip args whose submitted value is NULL, add WHERE subclauses for non-NULL values.
PB
http://www.artfulsoftware.com
Subject
Views
Written By
Posted
3562
March 11, 2009 11:13AM
2058
March 11, 2009 02:16PM
2010
March 11, 2009 06:39PM
1978
March 12, 2009 01:53PM
Re: Please Help Need Search Stored Proc
1903
March 12, 2009 03:05PM
1874
March 15, 2009 09:56AM
1897
March 15, 2009 12:07PM
1908
March 16, 2009 09:46AM
1977
March 16, 2009 12:47PM
1940
March 17, 2009 07:41AM
1856
March 17, 2009 09:48AM
1860
March 17, 2009 10:57AM
1871
March 17, 2009 10:21PM
1907
March 18, 2009 09:36AM
1944
March 18, 2009 09:49AM
1937
March 18, 2009 01:04PM
1915
March 18, 2009 01:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.