At 12:01 AM 1/15/2004, Andres wrote:
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@iptel.org;tag=76ff7a07-c091-4192-84a0-d56e91fe104f
I don't see how I can use this variable for an SQL query.
use text processing utils such as awk, sed, whatever you like better. That's not so difficult, is it?
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?
you need to do it yourself. There is infitnitely many interesting elemenents in a sip message and it makes little sense to break all of them in separate variables.
-jiri