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).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
