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]

Reply via email to