DMXzone Server Connect Support Product Page
Is there a way to preview the query in DatabaseSourceQueryBuilder?
Asked 17 Jan 2018 21:34:52
1
has this question
17 Jan 2018 21:34:52 Frank Haas posted:
DREAMWEAVER CC 2018DMXzone Server Connect
I created a query and inserted it on a page (following the tutorial), but no data show up.
Is there a way to test the query before using it? In the old Dreamweaver recordset menu there was a test button to display the query so you were sure everything was working before trying to use it on a page. I don't see any such button in the DMXZone Query Builder.
The connection builder has a test button and the connection I created tests okay.
The text that I typed in displays, but the table of data does not.
I tried simply inserting the data into a repeat region and tried inserting a table in the repeat region and inserting the data into the table. Neither worked.
Here is the code generated by Dreamweaver and DMXZone Server connect.
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Test DMX</title>
<script type="text/javascript" src="../ScriptLibrary/jquery-latest.pack.js"></script>
<script type="text/javascript" src="../dmxAppConnect/dmxAppConnect.js"></script>
<script type="text/javascript" src="../ScriptLibrary/dmxDataBindings.js"></script>
<script type="text/javascript" src="../ScriptLibrary/dmxDataSet.js"></script>
<script type="text/javascript" src="../ScriptLibrary/dmxServerAction.js"></script>
<link href="../PSO.css" rel="stylesheet" type="text/css">
</head>
<body id="Test1" is="dmx-app">
<p class="BlackHeadline">Birds</p>
<div data-binding-id="repeat1" data-binding-repeat="{{birds.data.birds}}">
<table width="800" border="2">
<tbody>
<tr>
<td>{{CommonName}}</td>
<td>{{Abundance}}</td>
<td>{{Occurrence}}</td>
</tr>
</tbody>
</table>
</div>
<p class="BlackHeadline"> </p>
<p class="BlackHeadline">End</p>
<p> </p>
<script type="text/javascript">
/* END dmxServerAction name "products" */
/* dmxServerAction name "birds" */
jQuery.dmxServerAction(
{"id": "birds", "url": "../dmxConnect/api/pso.php", "method": "GET", "sendOnSubmit": false, "sendOnReady": true, "data": {}}
);
/* END dmxServerAction name "birds" */
</script>
</body>
</html>Any suggestions on what might be wrong?
Replies
Replied 18 Jan 2018 07:39:45
18 Jan 2018 07:39:45 Teodor Kuduschiev replied:
Hi Frank,
You cannot preview the query in the Server Connect.
Please enable the debug mode in server connect options and provide a link to your page where we can check what is wrong. www.dmxzone.com/go/32354/debugging-problems-in-dmxzone-server-connect/
You cannot preview the query in the Server Connect.
Please enable the debug mode in server connect options and provide a link to your page where we can check what is wrong. www.dmxzone.com/go/32354/debugging-problems-in-dmxzone-server-connect/
Replied 18 Jan 2018 12:48:25
18 Jan 2018 12:48:25 Tom Dupre replied:
If you are using a local webserver (eg with Wamp), you can see exactly what SQL queries are being generated (if that's what you are asking for). I find this very useful for debugging.
I don't know if this option is set by default, but in any case you can create or edit this entry in my.ini, eg:
[mysqld]
port = 3306
; enables SQL queries to be logged
general_log = on
general_log_file=C:\wamp\logs\mysql_query.log
I have mysql_query.log open in a text editor which automatically updates as queries are executed.
I don't know if this option is set by default, but in any case you can create or edit this entry in my.ini, eg:
[mysqld]
port = 3306
; enables SQL queries to be logged
general_log = on
general_log_file=C:\wamp\logs\mysql_query.log
I have mysql_query.log open in a text editor which automatically updates as queries are executed.
Replied 18 Jan 2018 13:06:21
18 Jan 2018 13:06:21 Frank Haas replied:
Replied 18 Jan 2018 13:35:29
18 Jan 2018 13:35:29 Tom Dupre replied:
Turning on debugging in Server Connect doesn't help debug queries (as far as I know).
It seems you're viewing the page locally too. Where is your database? I always use a local server and database, so am not sure how things work if you're not.
It seems you're viewing the page locally too. Where is your database? I always use a local server and database, so am not sure how things work if you're not.
Replied 18 Jan 2018 13:57:51
18 Jan 2018 13:57:51 Frank Haas replied:
The database is on the server. It works fine for all of the database-related pages that already exist there. It is a Joomla-based site, but I use Dreamweaver to create the code for database-linked pages and then implant them in Joomla pages. I used to be able to do this using the recordset menu in Dreamweaver, but since that doesn't work anymore, I was trying to find a new way of doing it. DMXzone was recommended in the Dreamweaver forum.
I just can't get it to work. I tried building a very simple form to display some records and it won't do it. I know the database is good and the connection is good. There is something else going on.
When I click on Preview, the page comes up, but no data. When I try to directly access the testpage by typing the address in the web browser, I get File Not Found. Does that help?
I just can't get it to work. I tried building a very simple form to display some records and it won't do it. I know the database is good and the connection is good. There is something else going on.
When I click on Preview, the page comes up, but no data. When I try to directly access the testpage by typing the address in the web browser, I get File Not Found. Does that help?
Replied 18 Jan 2018 14:49:37
18 Jan 2018 14:49:37 Tom Dupre replied:
I expect there could be various points where the problem could be. I've never used Joomla. Server/App connect work very differently to the old built-in MySQL extensions. Obviously you want to make sure you upload all of the related files (the dmx.. folders etc.).
Perhaps you could try a very simple page which should return query results, without using Joomla, to see if that works - to help track down the problem. The suggestion I made before was specifically to debug SQL queries which probably can't be done unless you have a local database for developing - and anyway, the problem may well be elsewhere.
If you're getting File Not Found when trying to view the testpage that should be a clue. The URL you included above is using what I think is a fairly new feature in DW to display dynamic pages. I don't use this feature. The filename it uses is not the real filename - in case that could be the cause of any confusion.
Perhaps you could try a very simple page which should return query results, without using Joomla, to see if that works - to help track down the problem. The suggestion I made before was specifically to debug SQL queries which probably can't be done unless you have a local database for developing - and anyway, the problem may well be elsewhere.
If you're getting File Not Found when trying to view the testpage that should be a clue. The URL you included above is using what I think is a fairly new feature in DW to display dynamic pages. I don't use this feature. The filename it uses is not the real filename - in case that could be the cause of any confusion.
Replied 19 Jan 2018 09:17:09
19 Jan 2018 09:17:09 Teodor Kuduschiev replied:
Hello Frank,
The local link you provided does not work for us, we cannot access it as it is pointing to your local network.
Please upload your page to an accessible public server, and send us the link so we can debug.
The local link you provided does not work for us, we cannot access it as it is pointing to your local network.
Please upload your page to an accessible public server, and send us the link so we can debug.
Replied 20 Jan 2018 18:12:07
20 Jan 2018 18:12:07 Frank Haas replied:
Here is the link
www.pabirds.org/testforms/test1.php
This would not bring up the file the other day, but now it does. I have no idea why.
www.pabirds.org/testforms/test1.php
This would not bring up the file the other day, but now it does. I have no idea why.
Replied 20 Jan 2018 18:38:29
20 Jan 2018 18:38:29 Frank Haas replied:
I just created a new file similar to the previous one and, like the previous one, when I try to view it online by typing in the address manually, I get File Not Found. I can view it using the Dreamweaver preview button, but that only creates the fake link as before.
So, the current status now is: the file I created a few days ago can now be viewed by typing in the address, but the newer file cannot. I have no idea why. Neither file displays any data.
Also, when I tried to create the Server Connect Action Executor, in the Available Data Bindings box, no matter which item I click on and then click on the right arrow, all I get is "Please choose a valid server action." I tried every single item listed, from Repeat Regions down to Upload Progress. What is supposed to be there and what is to be selected to put into the box to the right? I can't find a manual on your site that explains this particular panel. I assume it is there, I just couldn't figure out from the titles, which one.
It would be nice if you had a manual that simply explains all of the items on each panel that comes up in your extensions, rather than just a tutorial which addresses one scenario, but doesn't address all of the options. Also. the screenshots in your videos are too small to read and too fuzzy to read when full screen.
Sorry to be so picky, but I am getting VERY frustrated with your extensions. The old Dreamweaver Bindings panel and Recordset panels were SO much easier to use than your alternative. I wish I could figure this out.
So, the current status now is: the file I created a few days ago can now be viewed by typing in the address, but the newer file cannot. I have no idea why. Neither file displays any data.
Also, when I tried to create the Server Connect Action Executor, in the Available Data Bindings box, no matter which item I click on and then click on the right arrow, all I get is "Please choose a valid server action." I tried every single item listed, from Repeat Regions down to Upload Progress. What is supposed to be there and what is to be selected to put into the box to the right? I can't find a manual on your site that explains this particular panel. I assume it is there, I just couldn't figure out from the titles, which one.
It would be nice if you had a manual that simply explains all of the items on each panel that comes up in your extensions, rather than just a tutorial which addresses one scenario, but doesn't address all of the options. Also. the screenshots in your videos are too small to read and too fuzzy to read when full screen.
Sorry to be so picky, but I am getting VERY frustrated with your extensions. The old Dreamweaver Bindings panel and Recordset panels were SO much easier to use than your alternative. I wish I could figure this out.
Replied 21 Jan 2018 14:35:17
21 Jan 2018 14:35:17 Teodor Kuduschiev replied:
Hello Frank,
reading your comments i think you have an issue defining your site in Dreamweaver. Please make sure to properly define the DW site, entering the remote/testing servers data.
Also i thing you are following some old tutorials. This is the only manual you need to follow: www.dmxzone.com/go/32764/dmxzone-app-connect-manual everything is explained here.
reading your comments i think you have an issue defining your site in Dreamweaver. Please make sure to properly define the DW site, entering the remote/testing servers data.
Also i thing you are following some old tutorials. This is the only manual you need to follow: www.dmxzone.com/go/32764/dmxzone-app-connect-manual everything is explained here.
Replied 21 Jan 2018 19:23:17
21 Jan 2018 19:23:17 Frank Haas replied:
The servers are set up correctly, as everything else works fine. It is just the DMX extensions that are giving me problems.
I will check out that tutorial.
Thanks
I will check out that tutorial.
Thanks
Replied 22 Jan 2018 09:07:15
22 Jan 2018 09:07:15 Teodor Kuduschiev replied:
Hi Frank,
I just checked the link you provided in your previous post.
The error returned by the server is:
It appears there is some issue with the session configuration in PHP on your server, which results in an error which stops our scripts from running. Here is some info about configuring sessions on your server:
php.net/manual/en/session.configuration.php#ini.session.save-path
I just checked the link you provided in your previous post.
The error returned by the server is:
It appears there is some issue with the session configuration in PHP on your server, which results in an error which stops our scripts from running. Here is some info about configuring sessions on your server:
php.net/manual/en/session.configuration.php#ini.session.save-path
Replied 22 Jan 2018 13:33:59
22 Jan 2018 13:33:59 Frank Haas replied:
I discovered that all of your dmx folders have uppercase letters in them. This does not work on my host, which is Linux.
So, I changed all of them to lower case.
Now I am getting the following error message.
"JavaScript Error in dmxDataBindingsEx_ServerActions.htm, line 8: actionUrll is not defined"
I can't find a file named dmxDataBindingsEx_ServerActions.htm in order to fix it.
Where is that file?
Also, the dmxdatabaseactions folder has nothing in it. Shouldn't the Actions that I have saved be in there?
Frank
PS: Is there a way to arrange a remote control session with you so you could look directly at my problem? I am willing to pay. You appear to be in a different time zone (I'm in the Eastern time zone, USA), but I'm sure we could work something out.
So, I changed all of them to lower case.
Now I am getting the following error message.
"JavaScript Error in dmxDataBindingsEx_ServerActions.htm, line 8: actionUrll is not defined"
I can't find a file named dmxDataBindingsEx_ServerActions.htm in order to fix it.
Where is that file?
Also, the dmxdatabaseactions folder has nothing in it. Shouldn't the Actions that I have saved be in there?
Frank
PS: Is there a way to arrange a remote control session with you so you could look directly at my problem? I am willing to pay. You appear to be in a different time zone (I'm in the Eastern time zone, USA), but I'm sure we could work something out.
Replied 22 Jan 2018 13:48:56
22 Jan 2018 13:48:56 Teodor Kuduschiev replied:
Hello Frank,
Linux servers are case sensitive, and there are no issues using mixed-case folder/file names there - and i doubt this is the issue on your server... You should not alter folder/file names as this will break everything.
Linux servers are case sensitive, and there are no issues using mixed-case folder/file names there - and i doubt this is the issue on your server... You should not alter folder/file names as this will break everything.
Replied 23 Jan 2018 14:09:03
23 Jan 2018 14:09:03 Frank Haas replied:
Okay. I am starting over. I uninstalled and reinstalled all of the DMX extensions.
I am now following the "Dynamic Dependent Drop-downs Part 1: Small Data Sources (up to 3000 records) " tutorial.
So far, so good, but the page in the tutorial already has some dropdown fields on the page and the tutorial does not specify how to create them in the first place. In Dreamweaver, the only dropdown option I see is in Bootstrap. Is that what I should use to insert them? If so, which type of dropdown should I insert? Or is there a better option?
Or do you have the sample page available to download so I could copy the code?
I am now following the "Dynamic Dependent Drop-downs Part 1: Small Data Sources (up to 3000 records) " tutorial.
So far, so good, but the page in the tutorial already has some dropdown fields on the page and the tutorial does not specify how to create them in the first place. In Dreamweaver, the only dropdown option I see is in Bootstrap. Is that what I should use to insert them? If so, which type of dropdown should I insert? Or is there a better option?
Or do you have the sample page available to download so I could copy the code?
Replied 23 Jan 2018 14:24:10
23 Jan 2018 14:24:10 Teodor Kuduschiev replied:
It does not matter how you will create the dropdowns ... they are just a standard HTML element and we do not think we need to teach people how to add standard HTML elements on their pages within Dreamweaver.
As our terms state:
Just insert standard dropdowns included in DW insert menu ...
As our terms state:
Just insert standard dropdowns included in DW insert menu ...