On Sep 4, 2007, at 9:04 AM, Andrew Stirling wrote:
> Just starting to play around with mysql
> if I send
> ? sqlexec(lnhandle, [update COMPDET SET lydata = 'C:\calcpay\pay'
> where
> cname= 'Stirling Clan' ])
> When I then look at the data I find 'C:calcpaypay'
> Why & what can I do about it?
Ah, you've run into that amazing Microsoft "innovation": using the
universal escape symbol as its directory separator. All the rest of
the world uses '/', but Bill in his Infinite Wisdom couldn't resist
"innovating" and used the backslash instead.
The solution, praise to Bill, is to escape the backslash itself with
another backslash. IOW:
sqlexec(lnhandle, [update COMPDET SET lydata = 'C:\\calcpay\\pay'
where
cname= 'Stirling Clan' ])
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
