Insertion probs with MySQL

I am trying to insert a directory location using mappath.

e.g - Server.Mappath("myfile.aspx") =
C:\inetpub\wwwroot\mysite\myfile.aspx

The problem I am having is that mysql does not accept
the "\" character so the field ends up
with "C:inetpubwwwrootmysitemyfile.aspx".

Can anyone help ?

I think you need to do a replace of \ by \\

MySQL sees the \ as an escape sequence or something end doesn't store it.

Hope this helps :-)

and don't forget to undo the \\ to \ when extracting it back out.....