The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

RE: xPLMediaNet sql stuff


  • Subject: RE: xPLMediaNet sql stuff
  • From: "Tony Tofts" <tony@xxxxxxxxxx>
  • Date: Tue, 29 Mar 2005 16:51:55 +0100


Hi all,

Just thought of one sql question that's still a problem

A few people have asked to have an option on the web index to list all
items
not starting A-Z

Can anyone tell me a LIKE statement syntax for list everything that
doesn't's start A-Z please (and works in access, sql and mysql) please?

I think the fact that the new web will be paged get's around this to some
extent though (i.e. all won't list 30k+ tracks on a single page)?

Many thanks
Tony



xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx

xPL Main Index | xPL Thread Index | xPL Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.