close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

There is an error in your SQL syntax.

Thread began 10/22/2018 11:48 am by María Luisa | Last modified 10/23/2018 3:40 pm by Ray Borduin | 139 views | 13 replies |

María Luisa

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

Sign in to reply to this post

Ray BorduinWebAssist

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).

Sign in to reply to this post

María Luisa

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

María Luisa

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?

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

María Luisa

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

María Luisa

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

Sign in to reply to this post

Ray BorduinWebAssist

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;

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...