I think you want chr(39) (single quote).
> 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: http://lists.mysql.com/mysql?unsub=1