The backslash (\) is an escape character
So to enter a backslash into a text field, you would have to say:
txtSceneFile = "C:\\Data\\test\\foo\\bar.lws".
----- Original Message -----
From: "Steve Pugh" <spugh@stripped>
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
> 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,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: