Question
Multiple record update extension issue (felixone
I just purchased the Multiple Records at Once Extension by
Felixone. I have put it to good use but have noticed an issue with
it. PHP MySQL.
I am using Dreamweaver 8 with the Repeat Region behaviour, and the Recordset Navigation Bar, along with the extension to update multiple values at once from a recordset.
If there are more records than can be displayed on the first page of navigation. E.g. Showing records 1-10 of 15, when doing a multiple table update (in this case changing a single value from 0 to 1 and vice versa) a MYSQL error comes up. The operation is still completed but it doesn't go to the page specified after the update in the extension, but stays on the current page with the following error at the top:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
In the mean time, to overcome the issue, I am able to display all records on a single page, however once the records build up it won't be acceptable to have a potentialy very long list of records when I would like to display only 15 at a time.
Has anyone had any experience of this, and if so would you be willing to help me. I have emailed felixone but I need this sorting out ASAP.
Notice I have changed the show results to 5000, as going into the repeat region behaviour and saying 'show all' would not do anything. It always put it back to ten.
I am using Dreamweaver 8 with the Repeat Region behaviour, and the Recordset Navigation Bar, along with the extension to update multiple values at once from a recordset.
If there are more records than can be displayed on the first page of navigation. E.g. Showing records 1-10 of 15, when doing a multiple table update (in this case changing a single value from 0 to 1 and vice versa) a MYSQL error comes up. The operation is still completed but it doesn't go to the page specified after the update in the extension, but stays on the current page with the following error at the top:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
In the mean time, to overcome the issue, I am able to display all records on a single page, however once the records build up it won't be acceptable to have a potentialy very long list of records when I would like to display only 15 at a time.
Has anyone had any experience of this, and if so would you be willing to help me. I have emailed felixone but I need this sorting out ASAP.
Notice I have changed the show results to 5000, as going into the repeat region behaviour and saying 'show all' would not do anything. It always put it back to ten.
AdChoices