[Serusers] Question on Exec Module

[Andres]

On Wednesday 14 January 2004 17:02, Jiri Kuthan wrote:
> see http://www.iptel.org/ser/doc/seruser/seruser.html#USINGEXEC
>
> SIP_HF_FROM="alice"
> <sip:alice at iptel.org>;tag=76ff7a07-c091-4192-84a0-d56e91fe104f
I don't see how I can use this variable for an SQL query.  On the other hand 
the SIP_OUSER variable can be used like this:

         QUERY="select email_address from subscriber 
                where user=\"$SIP_OUSER\"";
        EMAIL=`mysql  -Bsuser -pheslo -e "$QUERY" ser`;

I want the same type of query but for the originating user.  Is there any way 
to take apart the SIP_HF_FROM and extract just the username?

Andres.


>
> -jiri
>
> At 10:36 PM 1/14/2004, Andres wrote:
> >Hi,
> >
> >The exec module has a nice variable that holds the destination user of an
> > URI request  ($SIP_OUSER).
> >
> >Is there a variable that holds the originating user as well?
> >
> >Basically we want to perform a mysql lookup of a custom table where the
> >username resides.
> >
> >Regards,
> >Andres
> >
> >_______________________________________________
> >Serusers mailing list
> >serusers at lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers