Re: "INSERT INTO" dropping slashes from strings

[Daniel Clark]

Check the table sturcture for required fields and EXACT field names.  
mysql is case sensitive.

> 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.
>
> It's just so....odd!!
>
> Daniel Clark wrote:
>
>>I think you want chr(39) (single quote).