VB mysql_escape_string Equivalent

[aogail]

Hello,

Does a VisualBasic equivalent to the PHP function mysql_escape_string() exist? Preferably one that takes care of characters special according to MS SQL Server 2K.

Through my searching I found one function that takes care of single quotes, but nothing else.

Thanks!

 

[xlbo]

what does that function do ??

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[aogail]

From

http://us4.php.net/manual/en/function.mysql-real-escape-string.php:

[tt]mysql_real_escape_string -- Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection.[/tt]

It's written with MySQL in mind. I'm specifically looking for a VB version written with SQL Server in mind.

 

[xlbo]

VB or VBA - this is a VBA forum and I'm afraid I still don't understand what it does

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244