BlastRadius
Programmer
This is a simple question but I am having a problem with the syntax for the SQL update command. I have an example code which will update all records where say a = c to update c to d. Which is great but I am wanting to update every field here is the code. Below is the code I used on my last attemp to get this to work. Normally I use the recordset to update, create, delete when I am using an access database but this doesn't seem to work properly with mySQL. Thanks in advance for any help offered.
"UPDATE Events SET EName= '" & strEvent & "'" & "EDesc ='" & strDetails & "'" & "SDate ='" & strSdate & "'" & "EDate ='" & strEDate & "'" & "Ministry = '" & strMinistry & "'" & "Flag = '"&strFlag&"'" & "Contact = '" & strContact & "'" & "URL = '" & strURL & "'" & "WHERE ID = '" & recordID & "'"
"UPDATE Events SET EName= '" & strEvent & "'" & "EDesc ='" & strDetails & "'" & "SDate ='" & strSdate & "'" & "EDate ='" & strEDate & "'" & "Ministry = '" & strMinistry & "'" & "Flag = '"&strFlag&"'" & "Contact = '" & strContact & "'" & "URL = '" & strURL & "'" & "WHERE ID = '" & recordID & "'"