Inserting "\" character into a field

Inserting "\" character into a field

Postby Gary » Thu 29 Jun 2006 18:41

If I enter "e:/abc/def/ghi/xxx.jpg" into a field of a record I am inserting it works fine. But if I enter "e:\abc\def\ghi\xxx.jpg" it will only write "e:abc" into that field. Apparently it doesn't like "\" character, I tried a few things to get around it with no success. Whats the trick?
Gary
 
Posts: 2
Joined: Tue 27 Jun 2006 16:35

Postby Alexey » Fri 30 Jun 2006 10:39

You should escape '\ characters like this:
"e:\abc\def\ghi\xxx.jpg"
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Thanks

Postby Gary » Fri 30 Jun 2006 15:05

That was it!!
Gary
 
Posts: 2
Joined: Tue 27 Jun 2006 16:35


Return to dotConnect for MySQL