by almo9004 » Sun Sep 10, 2006 4:57 am
Hi, I'm back.
My Internet connection has been offline for a few days, sorry for making you wait.
I've come to realize that if i'm gonna be able to accomplish a script that creates playlists with say, 30% rock, 40% techno and 30% classical (as mentioned), i will have to know SQL. So, i started searching and observing scipts with even the tiniest line of SQL and came up with that some people use QuerySongs() and some openSQL() or even execSQL. So now, my questions:
1. Which should I use, QuerySongs(), openSQL or execSQL()?
2. Why does the line QuerySongs("AND Artists.Artist = 'Beatles'") work and QuerySongs("AND Genres.Genre = 'Pop'") does not?!
3. Where can I learn EVERYTHING about SQL in MediaMonkey?
4. Can I accomplish my above mentioned script without SQL?
Hope I'm not too nooby...
Hi, I'm back.
My Internet connection has been offline for a few days, sorry for making you wait.
I've come to realize that if i'm gonna be able to accomplish a script that creates playlists with say, 30% rock, 40% techno and 30% classical (as mentioned), i will have to know SQL. So, i started searching and observing scipts with even the tiniest line of SQL and came up with that some people use QuerySongs() and some openSQL() or even execSQL. So now, my questions:
1. Which should I use, QuerySongs(), openSQL or execSQL()?
2. Why does the line QuerySongs("AND Artists.Artist = 'Beatles'") work and QuerySongs("AND Genres.Genre = 'Pop'") does not?!
3. Where can I learn EVERYTHING about SQL in MediaMonkey?
4. Can I accomplish my above mentioned script without SQL?
Hope I'm not too nooby... :P :)