"INSERT INTO" dropping slashes from strings

[Steve Pugh]

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]