Hi Răzvan, 

 

I will test that, many thanks

 

Regards

 

De : <users-boun...@lists.opensips.org> au nom de Răzvan Crainea 
<raz...@opensips.org>
Répondre à : OpenSIPS users mailling list <users@lists.opensips.org>
Date : mercredi 9 novembre 2016 à 16:39
À : <users@lists.opensips.org>
Objet : Re: [OpenSIPS-Users] Migrating form 1.11.5 to 1.11.9

 

Hi, Alain!

Somewhere between 1.11.5 and 1.11.9 we figured out a problem related to mysql 
queries: if your database entry is NULL, we can't just simply set a NULL value 
to an AVP, because that just deletes the previous value. So you end up in a 
very inconsistent state. That's why we decided to set the value "<null>" to all 
the fields that are NULL in the database (this token is used in serveral other 
scenarios, that's why we picked this name).

Therefore, in order to properly test if a column is provisioned NULL in the 
database is:
if ($avp(redirect) != "<null>") {
}

Let us know how this goes.

Best regards,

Răzvan Crainea
OpenSIPS Solutions
www.opensips-solutions.com
On 11/09/2016 05:06 PM, Alain Bieuzent wrote:

Hi All,

 

I’m trying to migrate form 1.11.5 to 1.11.9 and i have a problem to test the 
value of a mysql query when the reseult is null.

 

In 1.11.5 this test « if (!$avp(redirect) == NULL) » works, but doesn’t work in 
1.11.9.

 

Is there a change in code ?

What is the corect way to test a null value from avp ?

 

Regards

 

Alain.




_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list 
Users@lists.opensips.org 
http://lists.opensips.org/cgi-bin/mailman/listinfo/users 

_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to