xPLMediaNet sql stuff

["Tony Tofts" <tony@xxxxxxxxxx>]

Hi all,

A couple of sql issues:

Can anyone please confirm that (like ms access) both mssql and mysql are
happy with both:

Select * from music where artist like "blondie%"

And

Select * from music where artist like 'blondie%'

i.e. can use either " or ' to indicate a string?

Also, I want to do away with the trapping of ", [, ] into //0, //1,
//2 in
strings (working in vb with sql there are issues with using these
characters)

So I want to use " to denote strings (as per the issue above) and in
the
code when reading/storing the characters always convert " to ' (or
should
that be '') and [, ] to (, ).

This saves having to keep converting strings back, and means the databases
are readable by outside applications if required

Any thoughts/comments 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