There still is no table when clicking the URL

Hi.

I'm using CC to display the table containing results data of CF. When clicking the 'Show Data' link to the right of my connection, I can view the table. But when clicking on the URL, a new tab opened but only displayed footer (Powered By ChronoConnectivity - ChronoEngine.com) with no table in the page. FYI, I already give permission to all users (from guest to super administrator) to view the table.

Pls help me on this. Thanks.

This is happen to me too! Maybe we need to execute at least one WHERE command?

My friend maybe you have commited the same mistake that me: you must tell to cc in Connection View Settings to print the desired fields in the results page. Example of sintaxis: {field} or other task like: {pagination}

I think you're right. Before, I have empty WHERE SQL, Header, Body, and Footer, boxes. But then I wrote in WHERE SQL box:

SELECT * FROM `jos_chronoforms_mynewform`

Header

<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>E-mail</th>
        </tr>
    </thead>
    <tbody>

Body

        <tr>
            <td>{text_1}</td>
            <td>{text_2}</td>
        </tr>

Footer

    </tbody>
</table>

Then this error message emerged:
[list]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 'SELECT count (*) FROM `jos_chronoforms_mynewform`' at line 1 SQL=SELECT count(*) FROM jos_chronoforms_mynewform SELECT count (*) FROM `jos_chronoforms_mynewform` 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 'SELECT count (*) FROM `jos_chronoforms_mynewform`' at line 1 SQL=SELECT count(*) FROM jos_chronoforms_mynewform SELECT count (*) FROM `jos_chronoforms_mynewform`
Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\fedus\components\com_chronoconnectivity\libraries\connection.php on line 300
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 'SELECT count (*) FROM `jos_chronoforms_mynewform`' at line 1 SQL=SELECT count(*) FROM jos_chronoforms_mynewform SELECT count (*) FROM `jos_chronoforms_mynewform`
Name E-mail[/list]

Can you tell me what went wrong? Or do you have an example of working WHERE, header, body, and footer? Thx before..😛

Hi. I have solved this myself by learning Bob's answers in other topics. Here's what I have:
WHERE: empty
Header:

<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>E-mail</th>
        </tr>
    </thead>

Body:

    <tbody>
    <tr>
            <td>{text_1}</td>
            <td>{text_2}</td>
        </tr>
    </tbody>

Footer:

</table> 

😀