DMXzone Database Updater ASP Support Product Page

Solved

Why isn't my insert working?

Reported 10 years ago
3
have this problem
10 years ago Steve Skinner posted:
Test page
testdmxzone.scriptsource.com/add.asp

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?

Replies

Replied 10 years ago
10 years ago 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 10 years ago
10 years ago 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 10 years ago
10 years ago George Mann replied:
I am having the same problem. I have tried the above solution and it isn't working either.

Test page:
www.themanndesign.com/comhub2/test.php
Replied 10 years ago
10 years ago Teodor Kuduschiev replied:
Hi George.
The error on your page is that the following file is not uploaded to the server:
ScriptLibrary/dmxDatabaseConnector/sqlBuilderEx.php

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 10 years ago
10 years ago George Mann replied:
Teodor,
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.
Thanks,
George

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 10 years ago
10 years ago 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 10 years ago
10 years ago 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