How about: (I reversed on set of quotes) sqlstr = "INSERT INTO Jobs VALUES('" & txtSceneFile & "')"
> Err...what I meant to say here was "ascii code equivalent (chr(39)" (I > tried single *and* double quotes). Sorry about that. > > Steve Pugh wrote: > >> Hi Daniel, >> >> I tried that to no avail (I had actually had the code set initially to >> use single quotes thusly: >> >> sqlstr = "INSERT INTO Jobs VALUES("' & _ >> txtSceneFile & "')" >> >> but it generated the same erroneous string. Using the ascii-code >> equivalent (Chr(34) does the same. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]