Re: [slim] Listing All Songs Starting With The Same Letter

2017-10-30 Thread steve-g 

Yes that's what I found it did which is not what I'm looking for - gives
you too big a list. I really only whant tracks where the first letter of
the title matches - will try sqlite as soon as I get a few minutes free.



steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057
View this thread: http://forums.slimdevices.com/showthread.php?t=108194

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss

Re: [slim] Listing All Songs Starting With The Same Letter

2017-10-29 Thread DJanGo 

steve-g wrote: 
> Thanks DJanGo - I was hoping to avoid having to use sqlite but it looks
> like thats the only way to do it - so thanks for the info on how to do
> it.

Yapp - maybe Michael is smarter than me, cause i just found the extended
search (using title "p%" ) also finds Tracks where any part in the
tracknahme starts with P - not only the Track itself.

> 
> Ennio Morricone and Others - Western Graffiti - 114 - 100 000 Dollari
> *p*er Ringo (Bruno Nicolai)
> Crystal Waters - Ben Liebrand Grandmix 90s Edition - 122 - 100% *P*ure
> Love
> Yello - Solid Pleasure - 10 - 10 Coast To *P*olka 

But using sqlite is quite simple.



DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread: http://forums.slimdevices.com/showthread.php?t=108194

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss

Re: [slim] Listing All Songs Starting With The Same Letter

2017-10-29 Thread steve-g 

Thanks DJanGo - I was hoping to avoid having to use sqlite but it looks
like thats the only way to do it - so thanks for the info on how to do
it.



steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057
View this thread: http://forums.slimdevices.com/showthread.php?t=108194

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss

Re: [slim] Listing All Songs Starting With The Same Letter

2017-10-29 Thread DJanGo 

steve-g wrote: 
> I'm putting together a quiz for which I need to select some songs whose
> title begins with a particular letter.
> 
> I was hoping to do a simple search for say 'P' and get a list of all
> titles starting with P - but this doesn't work.
> 
> Can anyone give me any help on how this can be done
> 
> Thanks
> 
> Steve

If you use sqlite its quite easy..


Code:

select titlesort from tracks where title like 'P%%';


> ..out put tooo long to fit here...



DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread: http://forums.slimdevices.com/showthread.php?t=108194

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss

[slim] Listing All Songs Starting With The Same Letter

2017-10-29 Thread steve-g 

I'm putting together a quiz for which I need to select some songs whose
title begins with a particular letter.

I was hoping to do a simple search for say 'P' and get a list of all
titles starting with P - but this doesn't work.

Can anyone give me any help on how this can be done

Thanks

Steve



steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057
View this thread: http://forums.slimdevices.com/showthread.php?t=108194

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss