Page 1 of 1
get_switch_codes.pl
Posted:
Fri Nov 27, 2009 6:51 pmby gmcust3
I have downloaded a file from Mantis.
get_switch_codes.pl
Now, I want to run a query
update vicidial_list set status='INVAL' where left(phone_number,6) not in ( select npanxx from nanpa_codes where ocn!='');
After my lead has been loaded.
How to do that ?
Posted:
Sat Nov 28, 2009 9:31 amby williamconley
1 Mysql command line version
- Code: Select all
mysql -pPASSWORD
use asterisk;
SQL STATEMENT(S) TO EXECUTE
exit
2 phpmyadmin
3 webmin
Posted:
Sat Nov 28, 2009 2:03 pmby gmcust3
How to use it with new_listloader_superL.php ?
Posted:
Sat Nov 28, 2009 4:31 pmby williamconley
don't. run it separately (after).
Posted:
Sat Nov 28, 2009 8:21 pmby gmcust3
Any reason for DONT ?
Posted:
Sat Nov 28, 2009 9:11 pmby williamconley
if you know how, do. if you don't, do it separately. it's not like there's a requirement of some sort.
Posted:
Tue Dec 01, 2009 12:39 pmby gmcust3
Trying this :
CREATE TRIGGER List_Invalid_Check
AFTER insert ON vicidial_list
FOR EACH ROW
BEGIN
update vicidial_list set status='INVAL' where left(phone_number,6) not in ( select npanxx from nanpa_codes where ocn!='');
END