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]