On 8/25/11 7:11 PM, Paul B. Gallagher wrote: > nr wrote: > >> I'm trying to write an SQLite3 program to delete history older than 3 >> days and was hoping some folks here might be able to help with a few >> items I can't figure out. I haven't found complete documentation for >> the product. >> >> 1. What is the syntax to tell the program which database to use >> (places.sqlite)? On mainframes and minis this is referred to as file >> allocation or file definition. >> >> 2. What is the best way to compare the current date to the dates in >> the table? >> >> If I can get this to work, I'll be happy to post it here for anyone >> who wants to copy and use; it will run from a .bat file. >> >> Any other ideas or suggestions are welcome. >> >> Thanks for any assistance. > > One of the top items on my personal wish list is a much better toolkit > for managing the history in the program itself: > > 1) There's no way to select and delete multiple items (standard Windows > shortcuts such as CTRL-click for discontinuous items, SHIFT-click for a > range don't work). If you want to delete more than one, you have to keep > hitting Del, Del, Del, ... > > 2) If you select and delete a website from one part of your history > (say, last Thursday), the program stupidly deletes all occurrences of > that website anywhere in your history. If you want to just delete last > Thursday's history for that site, you have to expand it and delete them > manually one... at... a... time.
See bug #660543 at <https://bugzilla.mozilla.org/show_bug.cgi?id=660543>. > 3) There's no longer an option to autodelete history items older than nn > days ("remember visited sites for up to nn days"). There's a button in > the prefs to "Clear history," but that's all or nothing. See bug #660646 at <https://bugzilla.mozilla.org/show_bug.cgi?id=660646>. -- David E. Ross <http://www.rossde.com/> On occasion, I might filter and ignore all newsgroup messages posted through GoogleGroups via Google's G2/1.0 user agent because of spam from that source. _______________________________________________ support-seamonkey mailing list [email protected] https://lists.mozilla.org/listinfo/support-seamonkey
