<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#3366ff" bgcolor="#ffffff">
I am looking forward for a short example on how to store a SQL query
to a variable which can be used in next condition in UNLANG. <br>
<br>
I have no knowledge of unlang but i got a fair amount of idea with
the condition checks , just need a little insight on the result
stores .<br>
<br>
For Ex.<br>
<br>
result1 = {some sql query}<br>
<br>
result2 = {some sql query}<br>
<br>
update control <br>
<br>
Session-Timeout := Result1 - Result 2<br>
<br>
Thanks in advance<br>
Suman<br>
<br>
<br>
On 3/16/2011 4:09 PM, Alan DeKok wrote:
<blockquote cite="mid:4D80937A.5010808@deployingradius.com"
type="cite">
<pre wrap="">Suman Dash wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> Hi Alan,
Did you managed to look into the issue ?
</pre>
</blockquote>
<pre wrap="">
No.
</pre>
<blockquote type="cite">
<pre wrap="">or maybe any hints on how to use DATETIME in Expiration instead of String ?
</pre>
</blockquote>
<pre wrap="">
Honestly, in 2.1.10, you can just write SELECT statements directly in
"unlang".
update reply {
Session-Timeout := "%{sql: SELECT ...}"
}
Couple that with a few other things, and you should be able to replace
the sqlcounter module entirely.
i.e. I don't use that module, and I know little or nothing about it.
I have little time to do anything with it.
Alan DeKok.
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5924 (20110303) __________
The message was checked by ESET NOD32 Antivirus.
<a class="moz-txt-link-freetext" href="http://www.eset.com">http://www.eset.com</a>
</pre>
</blockquote>
</body>
</html>