Line 14: var selectLocationString = "Select ConcertLocations.locationID, ConcertLocations.locationName, Concerts.concertID, Concerts.locationID FROM ConcertLocations INNER JOIN Concerts ON Concerts.locationID = ConcertLocations.locationID WHERE concertID = " + param;
Line 15: var location = db.QuerySingle(selectLocationString, param);
Line 16: var conLoc = location.locationName;
Line 17: var gig = db.Query("SELECT * FROM Concerts WHERE concertID = " + param);
Line 18: var listSql = "SELECT Playlists.concertID, Playlists.musicID, Playlists.sequence, Repertoire.musicID AS Expr1, Repertoire.name FROM Playlists INNER JOIN Repertoire ON Playlists.musicID = Repertoire.musicID WHERE Playlists.concertID = "+param+ " ORDER BY sequence";
|