older - it might work
just fine.
Thanks again for this - nice work.
Richard Scales
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of SilverRS8
Sent: 01 January 2008 10:35
To: discuss@lists.slimdevices.com
Subject: Re: [slim] Announce: Album Catalog C
Looking good! Main problems I am having:
- I have many albums with multiple genres and if I ask it to print
genres it only prints one of the genres seemingly at random
- I can't get it to exclude a genre - probably linked to issue above
- I have multiple hard drives and it doesn't find a second f
Thx for your reaction and testing.
Rick B.;253139 Wrote:
> I have many albums with multiple genres and if I ask it to print genres
> it only prints one of the genres seemingly at random
So what you actually would like is an option to display the genre of
each track instead of album based? Order
Just downloaded beta 3 and I do not see the Start or Help buttons. The
font of the GUI is bigger, but no where to click to start the process.
--
tamanaco
tamanaco's Profile: http://forums.slimdevices.com/member.php?userid=
tamanaco;253149 Wrote:
> Just downloaded beta 3 and I do not see the Start or Help buttons. The
> font of the GUI is bigger, but no where to click to start the process.
>
> Edit: Never mind... I was able to resize the window and see the missing
> buttons. But there's still something wrong with t
Richard Scales;253115 Wrote:
> I must confess that I have not got a specific folder for compilations so
> I
> did not specify one. Neither had I specified a starting folder though
> for
> testing purposes I can see that it might help as running it against my
> entire collection takes a while!
Th
SilverRS8;253142 Wrote:
> Thx for your reaction and testing.
>
>
>
> So what you actually would like is an option to display the genre of
> each track instead of album based? Ordering multiple multi genre albums
> based on genre is not possible i think (how would you like to output to
> look?)
Rick B.;253420 Wrote:
> Fistly, I have multiple genres only at the album level, not song level.
> All I meant was that you have an option to include genre in the
> printout but it only prints out one genre at random. I have a max of 3
> genres per album.
>
> Secondly, if I have albums in a direc
I'm really interested in this app - would it be possible to modify it to
pick up artwork that SS has added from embedded tags, rather than
folder.jpg?
I think it's possible, because Emmisary's app
(http://forums.slimdevices.com/showthread.php?t=28457&page=13) did just
that when I ran it under 6.5
...and another thought; presumeably it picks up the "Artist" field from
the db when it runs? Can it be tweaked to use whatever SS calls
"Artist Sort"?
--
moley6knipe
moley6knipe's Profile: http://forums.slimdevices.com/me
moley6knipe;253454 Wrote:
> I'm really interested in this app - would it be possible to modify it to
> pick up artwork that SS has added from embedded tags, rather than
> folder.jpg?
>
> I think it's possible, because Emmisary's app
> (http://forums.slimdevices.com/showthread.php?t=28457&page=13
n
Richard
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of SilverRS8
Sent: 02 January 2008 09:54
To: discuss@lists.slimdevices.com
Subject: Re: [slim] Announce: Album Catalog Creator for SlimServer
Richard Scales;253115 Wrote:
> I must confess that I have not g
SilverRS8;253014 Wrote:
> Sorry, looked at it again and the script only works when SS is installed
> on the same Windows machine.
>
> Frank
Ah, that won't work for me then. No worries, I'm sure many will find
this useful.
--
Fifer
--
Thanks Frank! I wonder why SS translates sorting to UPPERCASE? Again,
I'm only just starting to learn SQL so I'm a long way off yet! Sorry.
I'm one of those strange people who's learning it for fun ;-)
--
moley6knipe
m
moley6knipe;253506 Wrote:
> Thanks Frank! I wonder why SS translates sorting to UPPERCASE? Again,
> I'm only just starting to learn SQL so I'm a long way off yet! Sorry.
> I'm one of those strange people who's learning it for fun ;-)
My guess is that making everything uppercase removes weird
Thanks for putting this together 'SilverRS8'
Unfortunately I can't even get it to install...Once the first install
window starts I get the message
" a scrpt on this page is causing internet explorer to run slowly if
it continues to run your computer may become unresponsive".
Is it something I
webrits;253561 Wrote:
> Thanks for putting this together 'SilverRS8'
>
> Unfortunately I can't even get it to install...Once the first install
> window starts I get the message
> " a scrpt on this page is causing internet explorer to run slowly if
> it continues to run your computer may beco
webrits;253561 Wrote:
> Thanks for putting this together 'SilverRS8'
>
> Unfortunately I can't even get it to install...Once the first install
> window starts I get the message
> " a scrpt on this page is causing internet explorer to run slowly if
> it continues to run your computer may beco
Hi,
I am running SS 6.5.1 - 10879, Windows XP SP2, .Net 1.1 and 2.0, IE 6
(upgraded to IE7) and beta 4 of the catalog creator.
I am getting this error message: A script on this page is causing
Internet Explorer to run slowly. If it continues to run, your computer
may become unresponsive.
I tried
Hi,
Well I have got the connection to SC on Linux to work now. Needed
the following changes ...
Edit the server.prefs file and change 3 lines, all close together. Look
for the bindAddress. Change from 127.0.0.1 to your servers IP. Also add
the server ip to the allowedHosts line.
Change the hostnam
I created a beta4 version with some bug fixes which apparently causes
the script to run slowly for some :-(
I restored beta3 so if you download it again i guess the 'run slowly'
problems should be gone.
I will take a close look into the problem this afternoon.
Thx for the responses!
Frank
--
Thanks for the script!
One issue I didn't see mentioned here: I get question marks instead of
all non-latin characters (cyrillic, hebrew) in song titles, album
titles and genres. Any hope?
--
ymilner
ymilner's Profile: htt
SilverRS8;253709 Wrote:
> I created a beta4 version with some bug fixes which apparently causes
> the script to run slowly for some :-(
> I restored beta3 so if you download it again i guess the 'run slowly'
> problems should be gone.
>
> I will take a close look into the problem this afternoon.
Phil Leigh;253791 Wrote:
> Yes Frank - that fixed the "a script is running slowly" problem.
> Now I get a "an error occurred while connection to the database" error
> Error Number 0
>
> The ODBC connector is installed so I guess it must be something to do
> with the connect string?
> Regards
> P
SilverRS8;253795 Wrote:
> Thx Phil for the update regarding the running slow problem.
>
> Some things to know regarding the connection string:
> - The SlimServer database is default configured to accept only local
> connections. Is SlimServer installed on the same machine as the one you
> run t
SilverRS8;253795 Wrote:
> I haven't tested it yet on SqueezeCenter because it is still in Beta.
> Which version do you use?
>
> Frank
Hmmm, so SC 6.x is a limitation. That's what I thought when I first
read the help file. Oh well, I guess I'll have to wait for an SC 7.0
version too.
--
tam
Siduhe;253826 Wrote:
> I haven't been able to get beta v3 up and running on SC7, but it works
> fine with my 6.5.5 installation.
Thank you very much for testing this and clearing this up !!
Then either the Database structure of SC is different or field
names/types have chached in relation to SS
Secret Squirrel;253830 Wrote:
> I installed and ran it on SqueezeCenter 7.0 and it ran fine. The only
> isse I had was that it listed all artists as "Various Artists", but I
> noticed further up in the thread that happens when you don't enter a
> compilation directory which I didn't. I hope to sp
SS - many thanks!
Phil
--
Phil Leigh
You want to see the signal path BEFORE it gets onto a CD/vinyl...it
ain't what you'd call minimal...SB3+Stontronics PSU - Altmann
JISCO/UPCI - TACT RCS 2.2X with Good Vibrations S/W - MF X-DAC
V3/X-PSU/X-10 buffer (Audiocomm full mods)- Linn 5103 - Linn A
I'll be glad to...when I get home this evening! (10:15 EST here now)
I'm afraid I don't even know which of Frank's versions I am running at
the moment either. Sorry!
SS
Phil Leigh;253836 Wrote:
> SS - can you post the contents of your my.cnf file in
> C:\Documents and Settings\All Users\Applic
Interesting - I had also assumed it was just an SC7 issue.
Two things to mention: I'm currently running SC7 on a virtual machine,
which may have something to do with it. Also, the VM is running XP
Home (rather than XP Pro which is my normal OS).
I'll play around a bit more to see if either
I wonder if the ODBC 3.5.1 driver is not compatible with the MySQL in
ss7?
The connect strings look fine (and identical) to me...
--
Phil Leigh
You want to see the signal path BEFORE it gets onto a CD/vinyl...it
ain't what you'd call minimal...SB3+Stontronics PSU - Altmann
JISCO/UPCI - TACT R
I haven't been able to get beta v3 up and running on SC7, but it works
fine with my 6.5.5 installation.
--
Siduhe
Siduhe's Profile: http://forums.slimdevices.com/member.php?userid=723
View this thread: http://forums.slimde
tamanaco;253816 Wrote:
> Hmmm, so SC 6.x is a limitation. That's what I thought when I first
> read the help file. Oh well, I guess I'll have to wait for an SC 7.0
> version too.
I haven't tested it on SC. If the database structure and UID and PWD
haven't change I guess it should work. Maybe ot
I installed and ran it on SqueezeCenter 7.0 and it ran fine. The only
isse I had was that it listed all artists as "Various Artists", but I
noticed further up in the thread that happens when you don't enter a
compilation directory which I didn't. I hope to spend some time on the
script to see a wo
Just alittle more information (very little). I am running SC 7.0 on
Windoze XP Pro...non-VM machine. I'm also running on the latest FireFox
version 2. My guess is that I am running Frank's version 3 because of
the Various Artist bug.
I will post all of my information this evening. then I'll downl
SilverRS8;253834 Wrote:
> Thank you very much for testing this and clearing this up !!
> Then either the Database structure of SC is different or field
> names/types have chached in relation to SS. I'm installing SC right now
> on my laptop just to see what the differences actually are.
>
> Whe
Secret Squirrel;253839 Wrote:
> I'll be glad to...when I get home this evening! (10:15 EST here now)
>
> I'm afraid I don't even know which of Frank's versions I am running at
> the moment either. Sorry!
>
> SS
It's in the title bar of the AlbumCatalogCreator window.
Frank
--
SilverRS8
---
Secret Squirrel;253830 Wrote:
> I installed and ran it on SqueezeCenter 7.0 and it ran fine. The only
> isse I had was that it listed all artists as "Various Artists", but I
> noticed further up in the thread that happens when you don't enter a
> compilation directory which I didn't. I hope to sp
A little more info...the ODBC driver works OK in Control Panel - I can
configure it and connect to the slimserver database OK using the same
info as is in the connectstring in the script...very odd.
--
Phil Leigh
You want to see the signal path BEFORE it gets onto a CD/vinyl...it
ain't what yo
tamanaco;253853 Wrote:
> On SC 7.0 beta, for me, is not a DB connection issue. The main issue I'm
> experiencing is with some albums not displaying the covers. (All the
> tracks are listed) I think this issue "might" be related to special
> characters in the name of the folder when the script is
I created a webpage for ACC releases.
See: http://www.vanholt.nl/acc/acc.htm
Frank
--
SilverRS8
SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818
View this thread: http://forums.slimdevices.com/s
Frank
I just stuck this code into your script (where you talk to the database
for the first time)
Set cnn = New ADODB.Connection
cnn.ConnectionString = ConnectString
cnn.Open
and it works (ie the connection opens fine) so the problem I have isn't
with the string or the ODBC drivers...
I get a
Just to confirm I have the same problem as Phil - XP Pro and SC7 (latest
nightly).
Is the user still slimserver in SC7, I would imagine it is now
squeezecenter?
--
Siduhe
Siduhe's Profile: http://forums.slimdevices.com/me
Siduhe;253918 Wrote:
> Just to confirm I have the same problem as Phil - XP Pro and SC7 (latest
> nightly).
>
> Is the user still slimserver in SC7, I would imagine it is now
> squeezecenter?
I think it still "slimserver" - or at least that opens a connection to
the database...
--
Phil Leigh
It works for me if I change the script UID to "squeezecenter" - all
other variables stay the same. In particular, database is still
Slimserver.
--
Siduhe
Siduhe's Profile: http://forums.slimdevices.com/member.php?userid=72
Siduhe;253922 Wrote:
> It works for me if I change the script UID to "squeezecenter" - all
> other variables stay the same. In particular, database is still
> Slimserver.
Rats! - It still doesn't work for me and that would have been such a
simple and logical fix :o)
--
Phil Leigh
You want to
Aw shucks, and just when I was feeling the warm glow of success.
If it helps, my set up is as follows:
Create System DSN in ODBC Source Adminstrator as follows:
DAta Source Name - Squeezecenter
User - squeezecenter
Port - 9092
Test and OK
Change script using Edit Pad Pro as follows:
'MySQL co
Siduhe;253924 Wrote:
> Aw shucks, and just when I was feeling the warm glow of success.
>
> If it helps, my set up is as follows:
>
> Create System DSN in ODBC Source Adminstrator as follows:
>
> DAta Source Name - Squeezecenter
> User - squeezecenter
> Port - 9092
> Test and OK
>
> Change sc
Phil Leigh;253836 Wrote:
> SS - can you post the contents of your my.cnf file in
> C:\Documents and Settings\All Users\Application
> Data\SqueezeCenter\Cache
>
> please?
> thanks
> Phil
Phil,
I didn't find a my.cnf but just a "my" file with no extension. I have
attached it here as my.txt. I ho
Silly me the update didn't work the first time so I edited the message.
Sorry,
SS
Secret Squirrel;254007 Wrote:
> Phil,
>
> I didn't find a my.cnf but just a "my" file with no extension. I have
> attached it here as my.txt. I hope it has some information for you!
>
> Here's some more informa
Thanks for this great utility. I love it.
I have found one thing though that may need to be looked into. I am
describing it here for others to try and see if they come up with the
same issue.
Background:
1) two computer running windows XP SP2 latest updates
2) computer one runs SS 6.5 latest r
I just posted Beta 4 on http://www.vanholt.nl/acc/acc.htm
The following changes are made:
FIXED: Album cover not displayed if album path name contains non alpha
numeric chars
FIXED: Script hangs when an album path containing non alpha numeric
chars was selected as starting folder
FIXED: Very last
Hi,
thanks for the "new" beta 4 - I am not getting the error anymore
regarding the script that slows down my computer.
Great work - and lots of opportunities for additional features :)
--
sellars
sellars's Profile: http:/
I downloaded and installed the MySQL connector into my Vista machine.
When trying to run the script, the GUI comes up, when I pressed Start,
I got the error:
-
"An error occured while connection to the database, the error data is
printed below:
Error Number: 0
Erro
agentsmith;254371 Wrote:
> I downloaded and installed the MySQL connector into my Vista machine.
>
> When trying to run the script, the GUI comes up, when I pressed Start,
> I got the error:
> -
> "An error occured while connection to the database, the error data
anuary 2008 19:48
To: discuss@lists.slimdevices.com
Subject: Re: [slim] Announce: Album Catalog Creator for SlimServer
I just posted Beta 4 on http://www.vanholt.nl/acc/acc.htm
The following changes are made:
FIXED: Album cover not displayed if album path name contains non alpha
numeric chars
FIXED:
Richard Scales;254403 Wrote:
> Just tried the latest version - superb - thanks again for all the hard
> work.
>
> Please could you confirm the operation of the 'Various Artists'
> function?
>
> Would I be right in thinking that if I collated all my 'Various
> Artist'
> style albums into one fol
Fantastic utility - it's just what I've been looking for! Beta 4 solves
all the problems I was having with album art but one problem remains.
My SS database contains both MP3 and WMA files which SS handles
perfectly well in terms of displaying Tag details, however ACC will not
display the Artist
agentsmith;254371 Wrote:
> I downloaded and installed the MySQL connector into my Vista machine.
>
> When trying to run the script, the GUI comes up, when I pressed Start,
> I got the error:
> -
> "An error occured while connection to the database, the error data
Chautara;254430 Wrote:
> Fantastic utility - it's just what I've been looking for! Beta 4 solves
> all the problems I was having with album art but one problem remains.
>
> My SS database contains both MP3 and WMA files which SS handles
> perfectly well in terms of displaying Tag details, howeve
agentsmith;254371 Wrote:
> I downloaded and installed the MySQL connector into my Vista machine.
>
> When trying to run the script, the GUI comes up, when I pressed Start,
> I got the error:
> -
> "An error occured while connection to the database, the error data
Ive just tried it again using acc-v1-b4 and the script now runs for 20
Seconds before I get the announcement.
Stop running this script?
" a script on this page is causing internet explorer to run slowly if
it continues to run your computer may become unresponsive
SlimServer Version: 6.5.4 - 12
Some encouraging progress:
Using Beta 4, I uninstalled the MS MDAC components and reinstalled. The
script is now working! Obviously the ODBC drivers were not registered
properly for some reason on my system.
However, it does take a VERY long time to run...I can hear the hard
disk thrashing. (2500
Phil Leigh;254552 Wrote:
> Some encouraging progress:
> Using Beta 4, I uninstalled the MS MDAC components and reinstalled. The
> script is now working! Obviously the ODBC drivers were not registered
> properly for some reason on my system.
> However, it does take a VERY long time to run...I can
Sorry - that was a stupid observation by me...of course it is the C:\
drive that is being thrashed because that is where the SlimServer
database is - doh!
--
Phil Leigh
You want to see the signal path BEFORE it gets onto a CD/vinyl...it
ain't what you'd call minimal...SB3+Stontronics PSU - Alt
SilverRS8;254563 Wrote:
> I will create additional debug logging in the next Beta to see which
> function is causing the delay. If you can send me that logfile I hope I
> can solve the problem. But again SC is not supported yet so I won't get
> into that much deeper until the debugging on SS has
Chewie;254509 Wrote:
> Ive just tried it again using acc-v1-b4 and the script now runs for 20
> Seconds before I get the announcement.
>
> Stop running this script?
>
> " a script on this page is causing internet explorer to run slowly if
> it continues to run your computer may become unrespon
Chautara;254430 Wrote:
> Fantastic utility - it's just what I've been looking for! Beta 4 solves
> all the problems I was having with album art but one problem remains.
>
> My SS database contains both MP3 and WMA files which SS handles
> perfectly well in terms of displaying Tag details, howeve
Phil Leigh;254566 Wrote:
> Frank,
> Happy to supply you with the log file once that Beta is available.
>
> Yes I have 3 drives (E:\ F:\ G:\), all referenced by a single folder on
> C:\ (C:\music) which has the three necessary shortcuts. This works fine
> under SC7 (never worked properly under 6.
!)Now I get a "an error occurred while connection to the database" error
Error Number 0
The ODBC connector is installed so I guess it must be something to do
with the connect string?
Regards
Phil
(PS Really looking forward to getting this running!)
I would really like to get this working as it
SilverRS8;254619 Wrote:
> I just posted Beta 5 on http://www.vanholt.nl/acc/acc.htm which has a
> fix for the WMA problem. Please let me know the outcome of your test.
>
> Frank
Frank
I've just run a test with Beta 5 and at first glance everything looks
great. Thanks for a great piece of work
SilverRS8;254663 Wrote:
> What version do you use? SlimServer 6.5 or SqueezeCenter? The latter is
> not supported yet because problems with the current version need to be
> resolved first. It will be supported in the very near future.
>
> It should be enough to just install the mySQL ODBC connec
RalphO;254657 Wrote:
>
> I would really like to get this working as it is something that I have
> wanted for a long time. I am getting the same message Error Number 0.
> I am afraid that I do not have the knowledge to set up an ODBC connector
> or know if it is installed properly. I did downl
Hello - good news!
I realised my own stupid mistake which was to leave tracing enabled on
the ODBC connector...so the disk access I was experiencing was in fact
Windows writing to the log file!.
Now tracing is off and the script does indeed work quickly.
Further good news...because the script acc
Phil Leigh;254920 Wrote:
> Hello - good news!
> I realised my own stupid mistake which was to leave tracing enabled on
> the ODBC connector...so the disk access I was experiencing was in fact
> Windows writing to the log file!.
> Now tracing is off and the script does indeed work quickly.
>
> Fu
SilverRS8;254930 Wrote:
> Thx Phil for the update and good to hear everything works. Database
> Tracing can indeed have a high impact! Is the output also good?
> I'm currently installing SC in a VM and if I like the current state I
> will move to SC also and then start making ACC compatible with
Wow! This looks great! Any way to get a complete tutorial on getting
this to work with SB 6.5*? Phil, is your post (8:02 today) fairly
complete on everything that needs to be done?
--
Kyle
Kyle's Profile: http://forums.
Kyle;254969 Wrote:
> Wow! This looks great! Any way to get a complete tutorial on getting
> this to work with SB 6.5*? Phil, is your post (8:02 today) fairly
> complete on everything that needs to be done?
Kyle - to be honest I'm not sure and I'm no expert on this!
My post was related to SC7
Frank,
I just downloaded and ran beta 5 on SC 7.0 with no problems. The
results are fantastic in my opinion as I only have a straight vanilla
database. I really wanted a printed catalog for family and friends.
Thanks for all the good work, amazingly fast turn-around on
changes/corrections, and f
Phil Leigh;254962 Wrote:
> Frank - yes the output is excellent - many thanks for all of your hard
> work.
> I've made a couple of tweaks...
> 1) For compilations - but not normal albums it's nice to have the
> artist next to the track
> 2) for the durations, I've removed the leading zero which ma
Frank - I don't think you can do this directly within the SQL query. You
would have to parse the result set to strip out the leading "noise"
words and then re-sort.
Regards
Phil
--
Phil Leigh
You want to see the signal path BEFORE it gets onto a CD/vinyl...it
ain't what you'd call minimal..
Phil Leigh;254920 Wrote:
>
>
> To Ralph...
>
> To be honest I'm not sure what I did to get things working.
> i did install this:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
>
>
> and then re-installed the mysql odbc connector
I can report that I have managed to get the ODBC connection to work. I
fiddled around a bit and what finally worked was that I ttok out the ip
address of my server and just left it blank (I guess that it uses the
default. Anyway that gave me the wonderful message "success a
connection was made".
RalphO;255071 Wrote:
> I can report that I have managed to get the ODBC connection to work. I
> fiddled around a bit and what finally worked was that I ttok out the ip
> address of my server and just left it blank (I guess that it uses the
> default. Anyway that gave me the wonderful message "s
RalphO;255071 Wrote:
> I can report that I have managed to get the ODBC connection to work. I
> fiddled around a bit and what finally worked was that I ttok out the ip
> address of my server and just left it blank (I guess that it uses the
> default. Anyway that gave me the wonderful message "s
Frank - this might be the basis for solving the "The " problem...
SELECT
IF ( LEFT( title, 4)='The ', SUBSTRING(artist FROM 4), artist ) AS
artist_sort_name
FROM
ORDER BY artist_sort_name
or something like that...
I'll try it later - my MySql is not strong.
regards
Phil
--
Phil Leigh
You
I also had the error "0" return, after setting up mysql successfuly. I
ran the album catalogue program in it's original zipped format from my
desktop and it worked. Maybe that is a clue as to the real problem.
--
Mongo
Mo
Would it be possible to extend the functionality to include the ability
to use album artist/band tag where the album is a compilation - in a
similar way how SS does it right now?
thks
--
slimkid
The sound stage will open up, bass will tighten and the imaging will
improve. DVD performance will
Kyle;254969 Wrote:
> Wow! This looks great! Any way to get a complete tutorial on getting
> this to work with SB 6.5*? Phil, is your post (8:02 today) fairly
> complete on everything that needs to be done?
It should really be that easy as installing the ODBC driver and than
run the script. Fo
slimkid;255560 Wrote:
> Would it be possible to extend the functionality to include the ability
> to use album artist/band tag where the album is a compilation - in a
> similar way how SS does it right now?
>
> thks
Sure. That is the change that Phil (with code snippet) has done and how
it shou
Frank - cracked the "The " problem...
two blocks of code changes:
1):
sQBase = "select IF ( LEFT( contributors.name, 4)='The ',
SUBSTRING(contributors.name FROM 5), contributors.name) AS sort_name, "
&_
"CONVERT(contributors.name USING utf8) as
artist,CONVERT(albums.title USING utf8) as album,
slimkid;255560 Wrote:
> Would it be possible to extend the functionality to include the ability
> to use album artist/band tag where the album is a compilation - in a
> similar way how SS does it right now?
>
> thks
I just posted Release candidate 1 on http://www.vanholt.nl/acc/acc.htm
(i think
Phil Leigh;255590 Wrote:
> Frank - cracked the "The " problem...
> two blocks of code changes:
> 1):
> sQBase = "select IF ( LEFT( contributors.name, 4)='The ',
> SUBSTRING(contributors.name FROM 5), contributors.name) AS sort_name, "
> &_
> "CONVERT(contributors.name USING utf8) as
> artist,CON
SilverRS8;255628 Wrote:
> Hi Phil,
>
> Very good job done!! I look into it later and do some testing but very
> good to know that it can be done in a query. Personally i'm still
> strugling if I like 'The' to be stripped or not when sorting because I
> think I will look for bands at the 'T' when
SilverRS8;255628 Wrote:
> Personally i'm still strugling if I like 'The' to be stripped or not
> when sorting because I think I will look for bands at the 'T' when
> searching for e.g. 'The Killers'. Maybe other thread readers can give
> their opinion on this too?
Caveat - I have a lot of compil
Siduhe;255676 Wrote:
> Caveat - I have a lot of compilation albums (>60%) so I rarely sort by
> artist. However, I've got quite a few albums that begin with "The". I
> have SC set to ignore "The" when sorting, but I actually think I would
> like Album Catalogue Creator to follow the precise for
SilverRS8,
Thanks for all the great work over the week end on this.
Phil, Siduhe,
Thanks for all the work you guys have done also.
"THE" I feel should be user selection for the artist not the Album
title. But then again what about "THE THE". As Phil has stated it will
always be a problem. I
SilverRS8;255182 Wrote:
> The server should be specified and can either be 127.0.0.1 or
> localhost.
>
> What you can also do is try to connect using the mySQL query browser at
> http://dev.mysql.com/downloads/gui-tools/5.0.html
>
> You can use this to connect to the mySQL DB using a more ituit
Lots of changes around here. I was gone for a couple days and we got the
Duet and ACC is up to beta 5!
I just tested beta 5 and I'm still having issues with album art not
showing up for albums whose Genre, Artist or Album name have extended
characters in their path. For example all of the Albums
301 - 400 of 484 matches
Mail list logo
