Frank,
Just to be sure, the line I commented out was the rs.close as shown
in the following code fragment:
' ====== FUNCTION
==============================================================
' Execute query and fill Album array
'
==============================================================================
Function fnPerformQuery(iType)
oLogfile.writeline "STATUS : fnPerformQuery(" & iType &
"):ENTER:" & Time()
On Error Resume Next
' rs.close
err.clear
rs.Open sql
Unfortunately, the resultant error appears the same:
ACC Version : 1.0 Release Candidate 3
STARTED : 1/27/2008 --- 5:14:24 PM
STATUS : fnStart():ENTER:5:14:27 PM
OPTION SELEC: Display Tracks = False
OPTION SELEC: Cover art size = True
OPTION SELEC: Display Genre = True
OPTION SELEC: Sort by = Artist
OPTION SELEC: GenreIncludeExclude = Include
OPTION SELEC: Sort Year Descending = True
OPTION SELEC: AutoPrintPageSep = True
OPTION SELEC: Filter: Starting folder = E:\Archived Music
OPTION SELEC: Filter: Genres entered =
STATUS : fnStart():LEAVE:5:14:27 PM
STATUS : fnStart2():ENTER:5:14:27 PM
STATUS : fnQueryLogic():ENTER:5:14:27 PM
STATUS : fnPreProcessing():ENTER:5:14:29 PM
STATUS : fnPreProcessing():sql(1):Create table ACC SELECT
CONVERT(album_artist.name USING UTF8) AS
'AlbumArtist',CONVERT(albums.title USING UTF8) AS 'AlbumName',Albums.id
AS 'AlbumID',CONVERT(tracks.title USING UTF8) AS
'Title',CONVERT(tracks.disc USING UTF8) AS
'Disc',CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as 'Duration',albums.year
AS 'AlbumYear',tracks.url AS 'path',tracks.tracknum AS
'TrackNum',genres.namesort AS 'Genre',CONVERT(track_artist.name USING
UTF8) AS 'TrackArtist' FROM albums join contributors AS album_artist on
albums.contributor=album_artist.id left join tracks on
tracks.album=albums.id left join genre_track on
genre_track.track=tracks.id left join genres on
genre_track.genre=genres.id join contributor_track ON tracks.id =
contributor_track.track and (contributor_track.role in (1) or
contributor_track.role in (5)) join contributors AS track_artist on
contributor_track.contributor = track_artist.id WHERE
INSTR(UCASE(tracks.url), 'FILE:///E:/Archived%20Music') ORDER BY
album_artist.namesort, albums.titlesort, tracks.disc, tracks.tracknum,
track_artist.name, tracks.url;
STATUS : fnPreProcessing():LEAVE:5:14:29 PM
STATUS : fnCreateSQLQuery(0):ENTER:5:14:29 PM
STATUS : fnCreateSQLQuery(0):SELECT * FROM acc a Where AlbumArtist
!= 'Various Artists' order by AlbumArtist,AlbumYear
DESC,AlbumName,Disc,Tracknum;
STATUS : fnCreateSQLQuery(0):LEAVE:5:14:29 PM
STATUS : fnPerformQuery(0):ENTER:5:14:29 PM
ERROR : fnPerformQuery():An error occured while connection to the
database. Error number: 3709 -- Error description: The connection cannot
be used to perform this operation. It is either closed or invalid in
this context.
STATUS : fnPerformQuery(0):Recordset opened:5:14:29 PM
--
terry
------------------------------------------------------------------------
terry's Profile: http://forums.slimdevices.com/member.php?userid=14150
View this thread: http://forums.slimdevices.com/showthread.php?t=41597
_______________________________________________
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/discuss
