Search found 3 matches

by GbMedusa
Sun May 12, 2019 6:20 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2415
Views: 756073

Adding Artist Comment to Magic Nodes field selector

I have a Magic Node with the following SQL query to match (or not match) Artist Comments with a certain string. <Group|Name:Comments>\Artist Comment doesn't start with "Sorted Name: "|Filter:Songs.ID NOT IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND A...
by GbMedusa
Thu May 02, 2019 12:17 pm
Forum: Need Help? (mmw)
Topic: Saving Artist-related data
Replies: 4
Views: 2565

Re: Saving Artist-related data

I've gotten this far but keep getting a syntax error. dim strSN : strSN = "Sorted Artist Name: " SQL = "UPDATE Artists SET Artists.Comment = '" & strSN & "' WHERE Artists.Artist = '" & itm.Artist.Name & "'" SDB.database.execSQL(SQL) Any suggestions? I'm trying to write to the Artist's Comment (field...
by GbMedusa
Mon Apr 29, 2019 1:12 pm
Forum: Need Help? (mmw)
Topic: Saving Artist-related data
Replies: 4
Views: 2565

Saving Artist-related data

Is it possible to attach a property to an artist? I want to track whether an artist's name should be reformatted for sorting (firstname lastname > lastname, first name). I am trying to clean up my library with a script I am working on (self-made). One of the first things is checking whether I want t...