Active Topics
-
Porting apps to Leste (29)
to Maemo 7 / Leste by Arno_11 - 2 days, 3 hrs ago -
Install Fonts in N900 (68)
to Maemo 5 / Fremantle by teroyk - 3 days, 7 hrs ago - more...
| The Following User Says Thank You to Ilew For This Useful Post: | ||
|
2013-10-19
, 05:16
|
|
Posts: 76 |
Thanked: 44 times |
Joined on Apr 2011
@ India
|
#12
|
Originally Posted by Ilew
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.
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"
|
|
2013-10-19
, 05:26
|
|
Posts: 2,225 |
Thanked: 3,822 times |
Joined on Jun 2010
@ Florida
|
#13
|
Originally Posted by kraker_abhy
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.
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.
| The Following User Says Thank You to Mentalist Traceur For This Useful Post: | ||
 |
| Tags |
| missed call, number, terminal |
«
Previous Thread
|
Next Thread
»
|
All times are GMT. The time now is 23:59.
Btw expanding upon the previous sql.
This will get the last 5 missed calls and when they tried to call.