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 > 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]