All pastes #233411 Raw Edit

Stuff

public text v1 · immutable
·published 2006-11-01 22:53 UTC
rendered paste body
                IDbCommand cmd = conn.CreateCommand ();
                cmd.CommandText = @"
                                    SELECT devices.lastmountpoint,
                                           tags.url,
                                           tags.title,
                                           artist.name,
                                           genre.name,
                                           album.name,
                                           year.name,
                                           tags.track,
                                           tags.length
                                     FROM  tags,
                                           devices,
                                           artist,
                                           album,
                                           genre,
                                           year
                                     WHERE tags.deviceid = devices.id
                                       AND tags.artist = artist.id
                                       AND tags.album = album.id
                                       AND tags.genre = genre.id
                                       AND tags.year = year.id";

                 IDataReader reader = cmd.ExecuteReader ();