Re: xPLMediaNet sql stuff

[Tom Van den Panhuyzen <tomvdp@xxxxxxxxx>]

Hi Tony,

It is not beautiful, but I think it will work for all databases:

select name
from artist
where not ((name >= 'a' and name <= 'zzzzzzzzzzzzzzzzzzzzzzzzzz') or
(name >= 'A' and name <= 'ZZZZZZZZZZZZZZZZZZZZZZZZ'))

It works for Access and SQLServer.

How do you connect to the databases ?  Using ADO ?  If so, have you
consider using parameter objects to pass strings (and dates) ?  That
way you don't have to "escape" strings (characters like \ and ').
Also date formats are no problem that way.

hth,
Tom


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