DLR with field_dst not supported in Mysql/Pgsql

"Vincent CHAVANIS" <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <0a0901c62358$2f6b1940$9600a8c0@vince>
Dear,

I'd like to put again on the table the problem on DLR.
Actually, kannel is on an unstable situation, on one hand if you're using Oracle the dst_field is used.

    sql = octstr_format("UPDATE %S SET %S=:1 WHERE %S=:2 AND %S=:3 AND %S=:4 AND ROWNUM < 2",
                        fields->table, fields->field_status,
                        fields->field_smsc, fields->field_ts, fields->field_dst);

On the other hand, Mysql/Pgsql do not use dst_field due to Alexander's veto.

    sql = octstr_format("UPDATE %s SET %s=%d WHERE %s='%s' AND %s='%s' LIMIT 1;",
                        octstr_get_cstr(fields->table),
                        octstr_get_cstr(fields->field_status), status,
                        octstr_get_cstr(fields->field_smsc), octstr_get_cstr(smsc),
                        octstr_get_cstr(fields->field_ts), octstr_get_cstr(ts));

I understant each point of view (particularly Alexander), and i'm really concerned about avoiding to break existing installations.
But we need to clarify this in order to get it work for all of us.

regards

Vincent

--
Telemaque - NICE
Service Technique
Tel : +33 4 93 97 71 64 (fax 68)
[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.