by pokeefe0001 » Wed Feb 08, 2023 2:48 pm
I mistakenly posted a question in the "Need Help? (MMW4)"
viewtopic.php?t=103686 when it should have been posted here, so this is a multiple posting. Sorry.
I have a script that accesses the entire Songs table my first selecting Music in the media tree, performing whatever sort I wish, and running the script containing
I would rather do the sort in the script so the correct sort gets performed regardless of what has been in the media tree. I suspect there is a standard SQLite call to do this, but I'm not fluent in SQLite access from VBS (or from anywhere else for that matter). How do I programmatically perform a sorted extraction of data from the database?
I mistakenly posted a question in the "Need Help? (MMW4)"[url]https://www.mediamonkey.com/forum/viewtopic.php?t=103686[/url] when it should have been posted here, so this is a multiple posting. Sorry.
I have a script that accesses the entire Songs table my first selecting Music in the media tree, performing whatever sort I wish, and running the script containing
[code]Set list = SDB.AllVisibleSongList[/code]
I would rather do the sort in the script so the correct sort gets performed regardless of what has been in the media tree. I suspect there is a standard SQLite call to do this, but I'm not fluent in SQLite access from VBS (or from anywhere else for that matter). How do I programmatically perform a sorted extraction of data from the database?
