Norman,sunkara,raviprakash sunkara
avp_db_query() can do deleted and stored procedure
ex:
insert into new data in table
avp_write("$ru/username", "$avp(i:55)");
avp_write("$ru/domain", "$avp(i:54)");
avp_db_query("insert into contact (username,domain) values
('$avp(i:55)','$avp(i:54)')")
Callee uri save in contact(table name).
Thank you for your help very much
Chungyu
Chungyu,
Perhaps the following will work for you:
avp_db_query("DELETE FROM usr_preferences WHERE (username = 'bob') AND
(number = '1')");
Using the above as an example, you should be able to INSERT into a table
with avp_db_query();
Regards,
Norm
chungyu wrote:
Dear all:
Avpops module' exported function avp_db_delete() can do delete one
record?
example:
I use "test" as default table that has two fields.
username | number
-------------------
bob | 1
alice | 1
bob | 2
my configuration:
modparam("avpops", "avp_url", "mysql://ser:[EMAIL PROTECTED]/ser")
modparam("avpops", "avp_table", "test")
modparam("avpops", "username_column", "username")
modparam("avpops", "avp_aliases", "num=i:55")
modparam("avpops", "db_scheme",
"number_scheme:table=test;value_col=number;value_type=string")
if (method=="INVITE"){
avp_db_load("$from/username", "$num/$number_scheme"); //load from
table "test" ,number column as string value into AVP name '$num'
avp_db_delete("$from/username", "s:test") //delete all bob' record
};
if bob calling then bob'record has deleted
username | number
--------------------
alice | 1
But i want delete a record.
ex: delete number value is 1 for bob
username | number
--------------------
alice | 1
---------------------
bob | 2
avp_db_delete() can do delete one record?
Another question is avp_db_store() can do insert new data in table?
ex: insert into test (username,number) values ("mary","3")
username | number
-------------------
alice | 1
-------------------
bob | 2
-------------------
mary | 3
avp_db_store() can do it?
sorry,I still can't understand what it mean about avp_db_store() and
avp_db_delete().
Can tell me?
Thanks a lot in advance
Chungyu
------------------------------------------------------------------------
_______________________________________________
Users mailing list
[EMAIL PROTECTED]
http://openser.org/cgi-bin/mailman/listinfo/users
