Search found 2 matches

by dpreuss
Fri Apr 29, 2011 12:17 am
Forum: Vienna
Topic: Vienna & GeekTool
Replies: 9
Views: 6029

Re: Vienna & GeekTool

TA99 wrote:For some reason, I kept getting this error message:
SQL error near line 2: near "order" syntax error
Take a look at the Usage section again. You need to enter a valid folder (feed) number.
by dpreuss
Fri Apr 22, 2011 2:21 am
Forum: Vienna
Topic: Vienna & GeekTool
Replies: 9
Views: 6029

Re: Vienna & GeekTool

Here is a script I used to use that queries the sqlite database Vienna uses: #!/bin/bash if [ $1 == "summary" ]; then sqlite3 ~/Library/Application\ Support/Vienna/messages.db <<SQL_ENTRY_TAG_1 select foldername,'(' || unread_count || ')' from folders where folder_id = $2; SQL_ENTRY_TAG_1 ...