DMXzone App Connect Support Product Page


App connect Table cells data - text not showing but the correct rows showing.

Asked 14 Jun 2017 14:38:31
has this question
14 Jun 2017 14:38:31 Matthew Da Cruz posted:

I have two issues on a page I am working on.

Problem 1:
I have a form that inserts the record.
I have added a "validate data" to the insert server action.
It finds the record when I submit the form and displays the error however it still does the insert even though the record is found to exist in the database.
How do you stop the insert from happening if record exists?
How do we redirect to another page if doing a app connect insert?

Problem 2:
The table that is required to show the record once inserted displays the correct row count but the rows data is not showing up.

I have looked in the consule F12 Firefox.
In the JSON tab I see the JSON with the data for each row

You can see source file here

Any suggestions will be appreciated.




Replied 14 Jun 2017 14:52:48
14 Jun 2017 14:52:48 Teodor Kuduschiev replied:
Hi Matthew,
The validate step must be before the insert step, so it won't allow execution of insert, if the validation fails ...
As for the problem 2 - please provide a link to your page where i can check this.
Replied 14 Jun 2017 15:33:28
14 Jun 2017 15:33:28 Matthew Da Cruz replied:
Ill Upload to a server.
Currently run locally
Replied 15 Jun 2017 12:13:07
15 Jun 2017 12:13:07 Matthew Da Cruz replied:
Hi Teodor

Ok so I have the page up here.

Feel free to add records.
You will see the son response has the records in it



Replied 15 Jun 2017 12:14:12
15 Jun 2017 12:14:12 Matthew Da Cruz replied:
sorry json response
Replied 15 Jun 2017 13:50:56
15 Jun 2017 13:50:56 Matthew Da Cruz replied:
Any Ideas
Replied 16 Jun 2017 09:48:44
16 Jun 2017 09:48:44 Matthew Da Cruz replied:
Hi Teodor,
Hope you had a chance to look at why the data is not being displayed. I need to get this project finished
Replied 17 Jun 2017 05:04:24
17 Jun 2017 05:04:24 Teodor Kuduschiev replied:
Hi Matthew,
What i see on your page, is a "Status Code:401 Unauthorized" message. Are you sure you did not set some kind of login and restriction for the queries in the action file?
Replied 17 Jun 2017 07:39:56
17 Jun 2017 07:39:56 Matthew Da Cruz replied:
HI Teodor
I recreated the actions without security.
I can add the record. I re the records in the response and in the test_view_company json

However its not being displayed.
Replied 17 Jun 2017 09:56:41
17 Jun 2017 09:56:41 Teodor Kuduschiev replied:
Hi Matthew,
I see on your page you have both App Connects and Data Bindings includes. Please create this page using only App Connect, you cannot mix them both on the same page ...
Also i see an id is missing from your body tag.
<body is="dmx-app" class="nav-md"> but i believe that's due to the DW template syntax. You can try this on a blank new page.
Replied 17 Jun 2017 11:41:40
17 Jun 2017 11:41:40 Matthew Da Cruz replied:
Awesome that worked removing the databinding includes.

Thanks Teodor
Replied 17 Jun 2017 13:05:41
17 Jun 2017 13:05:41 Matthew Da Cruz replied:
On the same page
I added a href button in column view.
I want this to go to a page project detail.

In this test I noted that when dropping in the variable it does not translate to the value in the database. It shows the field name in braces.
However in the same row under the first column the database value is shown.

When binding variables to anchors - what is the correct process?

Is there a video showing how to bind the variables in an anchor?
Replied 17 Jun 2017 13:40:26
17 Jun 2017 13:40:26 Matthew Da Cruz replied:

Reply to this topic