RE: xPLMediaNet sql stuff

["Tony Tofts" <tony@xxxxxxxxxx>]

Hi Tom,

> select name
> from artist
> where not ((name >= 'a' and name <=
> 'zzzzzzzzzzzzzzzzzzzzzzzzzz') or (name >= 'A' and name <=
> 'ZZZZZZZZZZZZZZZZZZZZZZZZ'))
>
> It works for Access and SQLServer.

Will give it a go thanks

> How do you connect to the databases ?  Using ADO ?

Oledb?

In vb.net I'm doing a global dbconnect and then

Adodb.openrecordset("my sql string", dbs, etc)

> 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.

Could you elaborate if the above will work with my example please?

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