Re: can't update 'c:\windows'

Guard,

First, this kind of beginner question is more appropriate for the NOVICE
list.

> IF update table set field='c:\windows'
> but
> 
> c:\windows -> c:windows

That's because "\" is the Unix escape character.  If I were to want to
save "O'Reilly", for example, I could:
UPDATE table SET name = 'O\'Reilly';

Since you want to save an actual backslash, do this:

UPDATE table SET field = 'C:\\windows';

In your interface code, you may which to add a function that doubles
your backslashes.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco