[SR-Users] db_extra fields cannot be integer

[Benoit Panizzon]

Hi

> I haven't checked the code, nor remember why the developer did it like
> that, but probably it is still the case. It can be changed, should
> anyone needs it and want to work on it.

I also stumbled over that issue but circumvented it by converting the
integers to a string.

MySQL als Database then converts the string containing a valid
representation of an integer, back to an integer.

Use-case: Counting Call-Legs with same $ci:

Initialize the dialog var you will be using as a string:

$dlg_var(legcounter) = "1";

Put call in a DLG Profile:

set_dlg_profile("legcounter","$ci");

Pull Integer Variable containing number of calls:

get_profile_size("legcounter","$ci","$var(legcounter)");

$var(legcounter) is an integer now but when you assign it to a string dlg_var it is being converted to string:

$dlg_var(legcounter) = $var(legcounter);

Or to forcefully convert an integer to a string you could always do:

$dlg_var(legcounter) = "" + $var(legcounter);

PS: this was determined by try and error. So maybe there are better
solutions out there.

Mit freundlichen Grüssen

-Benoît Panizzon-
-- 
I m p r o W a r e   A G    -    Leiter Commerce Kunden
______________________________________________________

Zurlindenstrasse 29             Tel  +41 61 826 93 00
CH-4133 Pratteln                Fax  +41 61 826 93 01
Schweiz                         Web  http://www.imp.ch
______________________________________________________