523     CleanupClosePushL( attributes );

   523     CleanupClosePushL( attributes );

   524 

   524 

   525     attributes.AppendL(KMPXMediaGeneralType);

   525     attributes.AppendL(KMPXMediaGeneralType);

   526     attributes.AppendL(KMPXMediaGeneralCategory);

   526     attributes.AppendL(KMPXMediaGeneralCategory);

   527     attributes.AppendL(KMPXMediaGeneralId);

   527     attributes.AppendL(KMPXMediaGeneralId);

   529     // cannot execute a joined query to the music table

   529     // cannot execute a joined query to the music table

   530     // because the song records in the music table may be on a different drive

   530     // because the song records in the music table may be on a different drive

   531     ExecuteMediaQueryL(attributes.Array(), aMediaArray, KQueryPlaylistSongsGetSongs, aPlaylistId);

   531     ExecuteMediaQueryL(attributes.Array(), aMediaArray, KQueryPlaylistSongsGetSongs, aPlaylistId);

   532 

   532 

   533     CleanupStack::PopAndDestroy(&attributes);

   533     CleanupStack::PopAndDestroy(&attributes);

   544     const TArray<TMPXAttribute>& aAttrs,

   544     const TArray<TMPXAttribute>& aAttrs,

   545     CMPXMediaArray& aMediaArray)

   545     CMPXMediaArray& aMediaArray)

   546     {

   546     {

   547     MPX_DEBUG2("-->CMPXDbPlaylistSongs::GetSongsL(playlist 0x%x)", aPlaylistId);

   547     MPX_DEBUG2("-->CMPXDbPlaylistSongs::GetSongsL(playlist 0x%x)", aPlaylistId);

   548     TBool valid(EFalse);

   548     TBool valid(EFalse);

   550     RSqlStatement recordset(iDbManager.ExecuteSelectQueryL(KQueryPlaylistSongsGetSongsInfo,

   550     RSqlStatement recordset(iDbManager.ExecuteSelectQueryL(KQueryPlaylistSongsGetSongsInfo,

   551     		aPlaylistId));

   551     		aPlaylistId));

   552     CleanupClosePushL(recordset);

   552     CleanupClosePushL(recordset);

   553 

   553 

   554     TInt err(KErrNone);

   554     TInt err(KErrNone);