Re: My First Function

Okay, thanks for that.

I'm getting far enough with my SQL to be able to read and understand that 
one, but how do I put that into a plsql function and how do I call it.

Lets asume I've changed the relationship so that there is only one person per 
position, so only one integer should be returned.  How do I get that integer 
returned to my perl/php script, and how do I return -1 if the result of the 
query is empty?

Gary

On Sunday 01 July 2001  5:39 pm, omid omoomi wrote:
> >I want to be able to pass a member ID and a function ID and return the
> >highest permission for the two.  The cut-down schema is:
>
> Hello ,
> Perhaps this SQL works for you:
>
> select PPID,Max(PPERM)
> from permtable
> where
> PFID = 'FUNCTION_ID'
> and
> PPID in ( select HPID from holdertable where HMID='MEMBER_ID' )
> group by PPID;
>
> You will face some problems returning more than one value from this SQL if
> using it in a function.
> Though,I believe if you are going to use a PHP script it can easilly be
> handled with it.
>
> Hope that helps
> Omid Omoomi
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000