The backslash (\) is an escape character
(http://dev.mysql.com/doc/mysql/en/String_syntax.html).
So to enter a backslash into a text field, you would have to say:
txtSceneFile = "C:\\Data\\test\\foo\\bar.lws".
Lou
----- Original Message -----
From: "Steve Pugh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 04, 2004 6:02 PM
Subject: "INSERT INTO" dropping slashes from strings
> Every time I think I've got it, I am reminded that....I don't got it.
>
> Hello all, once again! Can anyone tell me why the following takes
> place? In my VB app I am adding records to the table "Jobs" with this
> code (trimmed way down - my actual INSERT statement populates about 20
> fields):
>
> sqlstr = "INSERT INTO Jobs VALUES(" & _
> Chr(34) & txtSceneFile & Chr(34) & ")"
>
> adocn.execute sqlstr
>
> Now, let's say that my txtSceneFile contains
> "C:\Data\test\foo\bar.lws". My Jobs table will show the following for
> the applicable data field: "C: Data". This, my frields, is a new one
> to me, to be sure! Any ideas?
>
> Many thanks,
> Steve
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
