How to Sort MM database table within a script

[pokeefe0001]

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

Code: Select all

Set list = SDB.AllVisibleSongList

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?