5 Apr
2014
5 Apr
'14
6:32 p.m.
Hi,
When using sql_xquery() like this:
sql_xquery("ca", "SELECT * FROM gateways", "gateways");
... what's a good way to check if any rows were returned? Since one does
not have a $dbr(gateways=>rows) value in this scenario, what should one do?
- is_avp_set("$xavp(gateways=>id)")) does not appear to operate on
XAVPs, or at least, the fixup functions reject them:
ERROR: avpops [avpops.c:935]: fixup_is_avp_set(): bad attribute name
<$xavp(gateways=>id)>
- the 'defined' operator does not appear to return a negative condition
here:
if(!defined $xavp(gateways=>id))
This condition evaluates to true.
Much appreciated!
-- Alex
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
5 Apr
5 Apr
6:41 p.m.
Hello,
I withdraw this question on grounds of idiocy. My query was returning a
row when I thought it wasn't.
In actual fact,
if(!defined $xavp(gateways=>id))
works just fine, because the xavp list is null in that case.
On 04/05/2014 11:32 AM, Alex Balashov wrote:
Hi,
When using sql_xquery() like this:
sql_xquery("ca", "SELECT * FROM gateways",
"gateways");
... what's a good way to check if any rows were returned? Since one does
not have a $dbr(gateways=>rows) value in this scenario, what should one do?
- is_avp_set("$xavp(gateways=>id)")) does not appear to operate on
XAVPs, or at least, the fixup functions reject them:
ERROR: avpops [avpops.c:935]: fixup_is_avp_set(): bad attribute name
<$xavp(gateways=>id)>
- the 'defined' operator does not appear to return a negative condition
here:
if(!defined $xavp(gateways=>id))
This condition evaluates to true.
Much appreciated!
-- Alex
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
6:42 p.m.
When I use xquery, I generally use it with a stored procedure that
returns a value if not matched... so I always return at least one row
with a variable of 'fail', -1, etc. to evaluate.
I like this for a variety of reasons (ie changing sql without changing
the config)... but that being said...
Wouldn't this still work for you:
if($dbr(gateways=>rows)>0) { }
Fred Posner
The Palner Group, Inc.
503-914-0999 (direct)
954-472-2896 (fax)
On 04/05/2014 11:32 AM, Alex Balashov wrote:
Hi,
When using sql_xquery() like this:
sql_xquery("ca", "SELECT * FROM gateways",
"gateways");
... what's a good way to check if any rows were returned? Since one does
not have a $dbr(gateways=>rows) value in this scenario, what should one do?
- is_avp_set("$xavp(gateways=>id)")) does not appear to operate on
XAVPs, or at least, the fixup functions reject them:
ERROR: avpops [avpops.c:935]: fixup_is_avp_set(): bad attribute name
<$xavp(gateways=>id)>
- the 'defined' operator does not appear to return a negative condition
here:
if(!defined $xavp(gateways=>id))
This condition evaluates to true.
Much appreciated!
-- Alex
6:45 p.m.
On 04/05/2014 11:42 AM, Fred Posner wrote:
When I use xquery, I generally use it with a stored
procedure that
returns a value if not matched... so I always return at least one row
with a variable of 'fail', -1, etc. to evaluate.
I actually do that too in many cases, but only because I often need to
pass back additional data about what went wrong (for logging) if no row
was found, so returning a row regardless, with a status column (with a
value like -1) and hijacking another column for some kind of
human-readable explanation.
I like this for a variety of reasons (ie changing sql
without changing
the config)... but that being said...
Wouldn't this still work for you:
if($dbr(gateways=>rows)>0) { }
I don't think so. As I understood the documentation, at least, $dbr
doesn't get populated in this case; the rows just go straight to an xavp
list. I suppose I should verify that.
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
7:14 p.m.
I don't think so. As I understood the
documentation, at least, $dbr
doesn't get populated in this case; the rows just go straight to an
xavp list. I suppose I should verify that.
Looks like you're right.
Tested various methods.
Fred Posner
The Palner Group, Inc.
503-914-0999 (direct)
954-472-2896 (fax)
On 04/05/2014 11:45 AM, Alex Balashov wrote:
On 04/05/2014 11:42 AM, Fred Posner wrote:
When I use xquery, I generally use it with a
stored procedure that
returns a value if not matched... so I always return at least one row
with a variable of 'fail', -1, etc. to evaluate.
I actually do that too in many cases, but only because I often need to
pass back additional data about what went wrong (for logging) if no row
was found, so returning a row regardless, with a status column (with a
value like -1) and hijacking another column for some kind of
human-readable explanation.
I like this for a variety of reasons (ie changing
sql without changing
the config)... but that being said...
Wouldn't this still work for you:
if($dbr(gateways=>rows)>0) { }
I don't think so. As I understood the documentation, at least, $dbr
doesn't get populated in this case; the rows just go straight to an xavp
list. I suppose I should verify that.
7:15 p.m.
On 04/05/2014 12:14 PM, Fred Posner wrote:
This does make me wonder if there is a "leak" of result handles here,
since sql_result_free() is not possible, but presumably there's an
internal result handle still getting allocated. Or maybe that was for
the memory allocated to the $dbr(...) data only and independent of the
underlying DB API.
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
I don't
think so. As I understood the documentation, at least, $dbr
doesn't get populated in this case; the rows just go straight to an
xavp list. I suppose I should verify that.
Looks like you're right.
Tested various methods. 
6 Apr
6 Apr
3:14 a.m.
dunno if this helps but i use $sqlrows(ca) to check whether there are rows
returned
Kelvin Chua
On Sat, Apr 5, 2014 at 9:15 AM, Alex Balashov <abalashov(a)evaristesys.com>wrote;wrote:
On 04/05/2014 12:14 PM, Fred Posner wrote:
This does make me wonder if there is a "leak" of result handles here,
since sql_result_free() is not possible, but presumably there's an internal
result handle still getting allocated. Or maybe that was for the memory
allocated to the $dbr(...) data only and independent of the underlying DB
API.
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
I
don't think so. As I understood the documentation, at least, $dbr
doesn't get populated in this case; the rows just go straight to an
xavp list. I suppose I should verify that.
Looks like you're right.
Tested various methods.
4:01 a.m.
Does that work for SELECT queries? The documentation says it's only for INSERT, UPDATE
and DELETE.
On 6 April 2014 02:14:24 CEST, Kelvin Chua <kelchy(a)gmail.com> wrote:
dunno if this helps but i use $sqlrows(ca) to check
whether there are
rows
returned
Kelvin Chua
On Sat, Apr 5, 2014 at 9:15 AM, Alex Balashov
<abalashov(a)evaristesys.com>wrote;wrote:
This does make me wonder if there is a "leak" of result handles here,
since sql_result_free() is not possible, but presumably there's an internal
--
Sent from my mobile, and thus lacking in the refinement one might expect from a fully
fledged keyboard.
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0671
Web: http://www.evaristesys.com/, http://www.alexbalashov.com
On 04/05/2014 12:14 PM, Fred Posner wrote:
> > I don't think so. As I understood the documentation, at least,
$dbr
> > doesn't get populated in this case;
the rows just go straight to
an
xavp list. I suppose I should verify that.
Looks like you're right.
Tested various methods.
result handle still getting allocated. Or maybe
that was for the
memory
allocated to the $dbr(...) data only and
independent of the
underlying DB
API.
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
------------------------------------------------------------------------
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
4:16 a.m.
On 04/05/2014 09:01 PM, Alex Balashov wrote:
Does that work for SELECT queries? The documentation
says it's only for
INSERT, UPDATE and DELETE.
It did not during my test this afternoon.
--fred
On 6 April 2014 02:14:24 CEST, Kelvin Chua
<kelchy(a)gmail.com> wrote:
dunno if this helps but i use $sqlrows(ca) to check whether there
are rows returned
Kelvin Chua
On Sat, Apr 5, 2014 at 9:15 AM, Alex Balashov
<abalashov(a)evaristesys.com <mailto:abalashov@evaristesys.com>> wrote:
On 04/05/2014 12:14 PM, Fred Posner wrote:
I don't think so. As I understood the
documentation, at
least, $dbr
doesn't get populated in this case; the rows
just go
straight to an
xavp list. I suppose I should verify that.
Looks like you're right.
Tested various methods.
This does make me wonder if there is a "leak" of result handles
here, since sql_result_free() is not possible, but presumably
there's an internal result handle still getting allocated. Or
maybe that was for the memory allocated to the $dbr(...) data
only and independent of the underlying DB API.
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670 <tel:%2B1-678-954-0670>
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
_________________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list
sr-users(a)lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/__cgi-bin/mailman/listinfo/sr-__users
<http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
------------------------------------------------------------------------
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Sent from my mobile, and thus lacking in the refinement one might expect
from a fully fledged keyboard.
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0671
Web: http://www.evaristesys.com/, http://www.alexbalashov.com
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
7:37 a.m.
no, it's not for SELECT.
$dbr for SELECTs
Kelvin Chua
On Sat, Apr 5, 2014 at 6:16 PM, Fred Posner <fred(a)palner.com> wrote:
On 04/05/2014 09:01 PM, Alex Balashov wrote:
Does that work for SELECT queries? The
documentation says it's only for
INSERT, UPDATE and DELETE.
It did not during my test this afternoon.
--fred
On 6 April 2014 02:14:24 CEST, Kelvin Chua <kelchy(a)gmail.com> wrote:
dunno if this helps but i use $sqlrows(ca) to check whether there
are rows returned
Kelvin Chua
On Sat, Apr 5, 2014 at 9:15 AM, Alex Balashov
<abalashov(a)evaristesys.com <mailto:abalashov@evaristesys.com>> wrote:
On 04/05/2014 12:14 PM, Fred Posner wrote:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
I don't think so. As I understood the
documentation, at
least, $dbr
doesn't get populated in this case; the rows
just go
straight to an
xavp list. I suppose I should verify that.
Looks like you're right.
Tested various methods.
This does make me wonder if there is a "leak" of result handles
here, since sql_result_free() is not possible, but presumably
there's an internal result handle still getting allocated. Or
maybe that was for the memory allocated to the $dbr(...) data
only and independent of the underlying DB API.
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670 <tel:%2B1-678-954-0670>
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
_________________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list
sr-users(a)lists.sip-router.org <mailto:sr-users@lists.sip-
router.org>
http://lists.sip-router.org/__cgi-bin/mailman/listinfo/sr-__users<
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
------------------------------------------------------------
------------
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Sent from my mobile, and thus lacking in the refinement one might expect
from a fully fledged keyboard.
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0671
Web: http://www.evaristesys.com/, http://www.alexbalashov.com
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
9:37 p.m.
On 04/06/2014 12:37 AM, Kelvin Chua wrote:
$dbr for SELECTs
Unless it's not, because you're using sql_xquery(). :-)
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
7 Apr
7 Apr
3:57 p.m.
Have you tried something like...
if (sql_xquery("ca", "SELECT * FROM gateways", "gateways")
== 1) {
#do stuff
} else {
#dang nabbit
}
Fred Posner
The Palner Group, Inc.
503-914-0999 (direct)
954-472-2896 (fax)
On 04/06/2014 02:37 PM, Alex Balashov wrote:
On 04/06/2014 12:37 AM, Kelvin Chua wrote:
$dbr for SELECTs
Unless it's not, because you're using sql_xquery(). :-)
4:02 p.m.
On 04/07/2014 08:57 AM, Fred Posner wrote:
Have you tried something like...
if (sql_xquery("ca", "SELECT * FROM gateways", "gateways")
== 1) {
#do stuff
} else {
#dang nabbit
}
I haven't, but I've been satisfied with this as a solution:
sql_xquery("ca", "SELECT * FROM gateways", "gateways");
if(!defined $xavp(gateways)) {
# dang nabbit
}
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
8 Apr
8 Apr
10:45 a.m.
On Saturday 05 April 2014 17:32:18 Alex Balashov wrote:
When using sql_xquery() like this:
sql_xquery("ca", "SELECT * FROM gateways",
"gateways");
... what's a good way to check if any rows were returned? Since one does
not have a $dbr(gateways=>rows) value in this scenario, what should one do?
All sqlops query functions have (undocumented) return values:
-1: error in parameters or query execution
1: query successful, at least one row in resultset (for SELECTs)
2: query successful, no rows returned
It might be useful to extend $sqlrows() to return the number of rows in the
resultset.
--
Alex Hermann
11:10 a.m.
On 04/08/2014 03:45 AM, Alex Hermann wrote:
All sqlops query functions have (undocumented) return
values:
-1: error in parameters or query execution
1: query successful, at least one row in resultset (for SELECTs)
2: query successful, no rows returned
Ah, right! I forgot to check the undocumented return values. :-)
Thanks!
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
3911
days inactive
3914
days old
14 comments
4 participants
participants (4)
-
Alex Balashov -
Alex Hermann -
Fred Posner -
Kelvin Chua