Page 2 of 2 1 2
Reply
Thread Tools
Ilew is offline Ilew
2013-10-18 , 22:22
Posts: 75 | Thanked: 269 times | Joined on Aug 2012
#11
Originally Posted by kraker_abhy View Post
Thanks for the code but i get this error "SQL error: no such table" events"

Can anyone help with it please?
Does the db file exist in "/home/user/.rtcom-eventlogger/el-v1.db" ?

Btw expanding upon the previous sql.
This will get the last 5 missed calls and when they tried to call.
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select datetime(start_time, 'unixepoch'), remote_uid from events where event_type_id = 2 order by id desc limit 5"
 

The Following User Says Thank You to Ilew For This Useful Post:
kraker_abhy is offline kraker_abhy
2013-10-19 , 05:16
Posts: 76 | Thanked: 44 times | Joined on Apr 2011 @ India
#12
Originally Posted by Ilew View Post
Does the db file exist in "/home/user/.rtcom-eventlogger/el-v1.db" ?

Btw expanding upon the previous sql.
This will get the last 5 missed calls and when they tried to call.
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "select datetime(start_time, 'unixepoch'), remote_uid from events where event_type_id = 2 order by id desc limit 5"
Thank you so much, I was doing mistake between l and 1 for database name, hence i was getting error. This code seems promising. Thanks again for helping out so fast.
 
Mentalist Traceur is offline Mentalist Traceur
2013-10-19 , 05:26
Posts: 2,225 | Thanked: 3,822 times | Joined on Jun 2010 @ Florida
#13
Originally Posted by kraker_abhy View Post
Thank you so much, I was doing mistake between l and 1 for database name, hence i was getting error. This code seems promising. Thanks again for helping out so fast.
I could've sworn I made a post in this thread recommending that you check the spelling in the el-v1.db filename. I guess not. But I am glad you figured it out anyway.
 

The Following User Says Thank You to Mentalist Traceur For This Useful Post:
Reply
Page 2 of 2 1 2

Tags
missed call, number, terminal

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 09:53.

Contact Us - Home - Archive - Top