There is an error in your SQL syntax.

Hello
I'm doing working on an update form. I've reviewed it, deleted it, done it again from 0, and every time I finish it and try it, it gives me an error: "There is an error in your SQL syntax."

In CRUD it works well Create (write correctly in the database) and Read. I'm missing the Update and Delete.

I review it comparing it with a previous form made with the WA tools and I do not find the differences or errors.

I searched the forum and found that it is recommended to review a rsobj.php file located in the mysqli folder that is inside the webassist folder. But I do not understand what can be done with it to find the error.

I attach the file of my update.

Can someone help me please? Thank you

You can open the rsobj.php file and the queryobj.php file and change the Debug = false; line to Debug = true;

That should give you a more detailed error message. If you want me to look into it, I would need FTP access and steps to reproduce (a url and what to click).

Hello
I changed the value on line 12 of rsobj.php.

$ this-> Debug = false;
to
$ this-> Debug = true;

I've also tried it the other way around and I still get the same result by clicking the Submit button on my form:

"There is an error in your SQL syntax".

My version of rsobj.php is 2.19

Thank you

Try updating it in the queryobj.php file as well... maybe the error is in the update and not the recordset.

Oh, thanks, Ray ... but I do not understand how I could update this file: it's one that WA automatically creates and saves in my site folder. Where do I find that file? How do I update it?

Just open it in dreamweaver and edit it in code view.

Well, that's what I think I've done: I opened the file rsobj.php and changed, on line 12
$ this-> Debug = false;
to
$ this-> Debug = true;

And the result has been the same: when clicking the submit button of my form, the application window remains blank with the message:

There is an error in your SQL syntax.

Thank you

Open the queryobj.php file and make the same update and see if that helps.

Thanks Ray. I do not know if I explained clearly. I have opened and modified the rsobj.php file several times and changed line 12 of:

$ this-> Debug = false;
to
$ this-> Debug = true;

and backwards. That is to say:

$ this-> Debug = true;
to
$ this-> Debug = false;


And the result has been the same: when clicking the submit button of my form, the application window remains blank with the message:

There is an error in your SQL syntax.

Thank you

I understand.... what I'm saying is open up the queryobj.php file (you say you have done it to the rsobj.php file, I'm saying make this change in both files).

You should be changing BOTH files to have:

$ this-> Debug = true;