DMXzone Database Updater ASP Support Product Page


Why isn't my insert working?

Reported 24 Jul 2014 00:23:11
have this problem
24 Jul 2014 00:23:11 Steve Skinner posted:
Test page

1. I have created my page with the form fields for adding a record
2. I have created my db action for adding a record
3. I have created my db executor using the action from #2
4. I have a button, which has an onclick behavior to run the executor

I have a behavior tied to the db executor so that when the action has completed successfully, it should redirect to list.asp of the same directory.

Nothing happens when I click the button. What am I missing?


Replied 24 Jul 2014 06:34:14
24 Jul 2014 06:34:14 Teodor Kuduschiev replied:
Hi Steve,
I think the error is caused by the fact databindings js file is after the updater js:
<script type="text/javascript" src="ScriptLibrary/dmxDatabaseAction.js"></script><script type="text/javascript" src="ScriptLibrary/dmxDataBindings.js"></script>

Please move the databindings js file before dmxDatabaseAction js.
Replied 24 Jul 2014 14:39:43
24 Jul 2014 14:39:43 Steve Skinner replied:
Yes, that was the problem.

I don't manipulate the part of the header that is created by the extensions, so it would appear that you must create your database actions AFTER you've setup the HTML5 Data Bindings stuff on the page. Otherwise, the extensions end up structuring the code incorrectly.
Replied 11 Nov 2014 03:21:25
11 Nov 2014 03:21:25 George Mann replied:
I am having the same problem. I have tried the above solution and it isn't working either.

Test page:
Replied 11 Nov 2014 09:08:33
11 Nov 2014 09:08:33 Teodor Kuduschiev replied:
Hi George.
The error on your page is that the following file is not uploaded to the server:

This is the actual error message from your server:
Quoterequire_once(): Failed opening required '/homepages/17/d232054809/htdocs/comhub2/dmxDatabaseActions/../ScriptLibrary/dmxDatabaseConnector/sqlBuilderEx.php' (include_path='.:/usr/lib/php5.4')

Replied 11 Nov 2014 12:34:52
11 Nov 2014 12:34:52 George Mann replied:
Thanks for the quick response. Where do I get that file? I have sqlBuilder.php that the extension adds, but I don't have the sqlBuilderEx.php file on my local test server either.

UPDATE: I searched my hard drive and found the file in a Dreamweaver extension directory. Everything is working now. None of the extensions (HTML5 Data Bindings, DMXZone Database Connector, and DMXZone Database Updater) added that file to my test server.
This reply was removed on 11/11/2014 12:49:25 PM.
See the changelog
Replied 11 Nov 2014 13:01:36
11 Nov 2014 13:01:36 Teodor Kuduschiev replied:
Hi George,
If the file was not added in your local site configuration in the ScriptLibrary/dmxDatabaseConnector/ folder, try restarting DW and open the test.php page in DW again. It should add the missing file in the folder.
Replied 12 Dec 2014 09:28:09
12 Dec 2014 09:28:09 Greta Garberini replied:
Same problem here: sqlBuilderEx.php is missing, no matter how often I restart Dreamweaver. It simply is not there.

I uninstalled and re-installed the Updater (PHP version in my case) and after restarting Dreamweaver it was transferred to the correct location. Works fine now.

Reply to this topic