Thanks a lot...... Effectively i did not know "grep"... marco
-----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoy� : vendredi 15 avril 2005 16:32 � : [EMAIL PROTECTED] Cc : [email protected] Objet : Re: SQL "SELECT DLR" "JML" <kannel-smsc 'at' com-et.fr> writes: > Hi all, > Does someone know where to find the SQL statement that looks for mysql > DLR in kannel source ? I'd say that `grep' would be a good start. Don't you know grep? [EMAIL PROTECTED] ~/src/gateway] grep -rw SELECT . ./gw/dlr_mysql.c: sql = octstr_format("SELECT %s, %s, %s, %s, %s, %s FROM %s WHERE %s='%s' AND %s='%s';", ./gw/dlr_mysql.c: sql = octstr_format("SELECT count(*) FROM %s;", octstr_get_cstr(fields->table)); ./gw/dlr_oracle.c: sql = octstr_format("SELECT count(*) FROM %S", fields->table); ./gw/dlr_oracle.c: sql = octstr_format("SELECT %S, %S, %S, %S, %S, %S FROM %S WHERE %S=:1 AND %S=:2 AND %S=:3 AND ROWNUM < 2", ./gw/dlr_sdb.c: sql = octstr_format("SELECT %s, %s, %s, %s, %s, %s FROM %s WHERE %s='%s' AND %s='%s' %s", ./gw/dlr_sdb.c: (SELECT oid FROM %s WHERE %s='%s' AND %s='%s' LIMIT 1)", ./gw/dlr_sdb.c: sql = octstr_format("SELECT count(*) FROM %s", octstr_get_cstr(fields->table)); ./gw/dlr_pgsql.c: sql = octstr_format("SELECT %s, %s, %s, %s, %s, %s FROM %s WHERE %s='%s' AND %s='%s' LIMIT 1;", ./gw/dlr_pgsql.c: sql = octstr_format("DELETE FROM %s WHERE oid = (SELECT oid FROM %s WHERE %s='%s' AND %s='%s' LIMIT 1);", ./gw/dlr_pgsql.c: sql = octstr_format("UPDATE %s SET %s=%d WHERE oid = (SELECT oid FROM %s WHERE %s='%s' AND %s='%s' LIMIT 1);", ./gw/dlr_pgsql.c: sql = octstr_format("SELECT count(*) FROM %s;", octstr_get_cstr(fields->table)); ./gwlib/dbpool_oracle.c: sql = octstr_create("SELECT 1 FROM DUAL"); -- Guillaume Cottenceau
