<div dir="ltr">Is this really what we want?<div>perhaps something like this would make more sense</div><div><br></div><div><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial"><span style="color:rgb(0,74,67)">diff --git a/modules/avpops/avpops_db.c b/modules/avpops/avpops_db.c</span>
<span style="color:rgb(7,71,38)">index 78acee3..79ea087 100644</span>
<span style="color:rgb(0,121,151)">--- a/modules/avpops/avpops_db.c</span>
<span style="color:rgb(0,121,151)">+++ b/modules/avpops/avpops_db.c</span>
<span style="color:rgb(227,74,220)">@@ -502,7 +502,7 @@ int db_query_avp_print_results(struct sip_msg *msg, const db_res_t *db_res,</span>
                                        avp_val.s.s=
                                                (char*)RES_ROWS(db_res)[i].values[j].val.string_val;
                                        avp_val.s.len=strlen(avp_val.s.s);
<span style="color:rgb(15,105,255)">-                                       if(avp_val.s.len&lt;=0)</span>
<span style="color:rgb(0,0,230)">+                                       if(avp_val.s.len&lt;0)</span>
                                                goto next_avp;
                                break;
                                case DB_STR:
<span style="color:rgb(227,74,220)">@@ -511,7 +511,7 @@ int db_query_avp_print_results(struct sip_msg *msg, const db_res_t *db_res,</span>
                                                RES_ROWS(db_res)[i].values[j].val.str_val.len;
                                        avp_val.s.s=
                                                (char*)RES_ROWS(db_res)[i].values[j].val.str_val.s;
<span style="color:rgb(15,105,255)">-                                       if(avp_val.s.len&lt;=0)</span>
<span style="color:rgb(0,0,230)">+                                       if(avp_val.s.len&lt;0)</span>
                                                goto next_avp;
                                break;
                                case DB_BLOB:
<span style="color:rgb(227,74,220)">@@ -520,7 +520,7 @@ int db_query_avp_print_results(struct sip_msg *msg, const db_res_t *db_res,</span>
                                                RES_ROWS(db_res)[i].values[j].val.blob_val.len;
                                        avp_val.s.s=
                                                (char*)RES_ROWS(db_res)[i].values[j].val.blob_val.s;
<span style="color:rgb(15,105,255)">-                                       if(avp_val.s.len&lt;=0)</span>
<span style="color:rgb(0,0,230)">+                                       if(avp_val.s.len&lt;0)</span>
                                                goto next_avp;
                                break;
                                case DB_INT:</pre></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 13, 2015 at 4:10 PM, Podrigal, Aron <span dir="ltr">&lt;<a href="mailto:aronp@guaranteedplus.com" target="_blank">aronp@guaranteedplus.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi there,<div><br></div><div>I noticed some unexpected behavior with <font face="monospace, monospace">avp_db_query </font>which is, if a varchar column has a empty string the avp value will be NULL. </div><div><br></div><div>Has anyone experienced such behavior or a workaround. </div><div>I use db_mysql driver. <br></div><div><br></div><div><br></div><div>Regards</div><span class="HOEnZb"><font color="#888888"><div><br></div><div><div>-- <br><div><div dir="ltr"><div><div dir="ltr">Aron Podrigal<div>-</div><div>&#39;1000001&#39;, &#39;1110010&#39;, &#39;1101111&#39;, &#39;1101110&#39;   &#39;1010000&#39;, &#39;1101111&#39;, &#39;1100100&#39;, &#39;1110010&#39;, &#39;1101001&#39;, &#39;1100111&#39;, &#39;1100001&#39;, &#39;1101100&#39;</div><div><br></div><div>P: &#39;2b&#39;, &#39;31&#39;, &#39;33&#39;, &#39;34&#39;, &#39;37&#39;, &#39;34&#39;, &#39;35&#39;, &#39;38&#39;, &#39;36&#39;, &#39;30&#39;, &#39;39&#39;, &#39;39&#39;<br></div><div><br></div></div></div></div></div>
</div></div></font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr">Aron Podrigal<div>-</div><div>&#39;1000001&#39;, &#39;1110010&#39;, &#39;1101111&#39;, &#39;1101110&#39;   &#39;1010000&#39;, &#39;1101111&#39;, &#39;1100100&#39;, &#39;1110010&#39;, &#39;1101001&#39;, &#39;1100111&#39;, &#39;1100001&#39;, &#39;1101100&#39;</div><div><br></div><div>P: &#39;2b&#39;, &#39;31&#39;, &#39;33&#39;, &#39;34&#39;, &#39;37&#39;, &#39;34&#39;, &#39;35&#39;, &#39;38&#39;, &#39;36&#39;, &#39;30&#39;, &#39;39&#39;, &#39;39&#39;<br></div><div><br></div></div></div></div></div>
</div>