Link from Connectivity to Connectivity

Hi!

I hope my question is very simple:

First I want to show a list with the main information of my table. And then it should be possible to click on an entry and show the complete data of these entry.
I know there ist the 'where SQL' field and I think it has something to do with POST and GET variables. But I have not idea how it exactly works.

Can you help me?
Holgerman

Hi Holgerman,

so you have 2 tables ? this is simple, make 2 connections, one to each table, at the first connection you will list your data as normal, but, you will make them as links, the link href will has something at the end like catid=9 for example, now to the 2nd connection, open it, at the "GET Variables" add catid, then at your WHERE SQL, add something like "WHERE categoryid={catid}", I assume that your 2nd table has a field called categoryid, this will get all rows with categoryid = 9 from the 2nd table!

you can let me know your 2 tables structure here and I can help with real fields names!

Cheers

max

Hi Max!

I only have one Table:
The fields are:
ID
Datum
Einsatzort
Beschreibung
Fahrzeuge

But I want to show this table in 2 different ways:

1. Only a list with 'Datum' and 'Einsatzort'
2. The full view of one selected from the list with all fields

Regards
Holger

Hi Holger,

Easy, make your 1st connection to this table, name it first, at the body, add some code like this :

{ID} - <a href="index.php?option=com_chronoconnectivity&connectionname=second&ID={ID}">{Einsatzort}</a><br>

now make another connection to the same Table, name it second, and add this code in the body :

{ID}<br>
{Datum}<br>
{Einsatzort}<br>
{Beschreibung}<br>
{Fahrzeuge}<br>

and at the WHERE SQL :

WHERE ID={ID}

and at the GET Variables:

ID

open your first connection link now which should be like this :
index.php?option=com_chronoconnectivity&connectionname=first

tell me how does it look!🙂

Cheers

Max

The list looks good but when I try to save the second connectivity, I get the following:

Fatal error: Cannot redeclare class Tablechronoforms_Einsatz in /www/htdocs/w0097f59/ffw15/administrator/components/com_chronoconnectivity/admin.chronoconnectivity.php(28) : eval()'d code on line 15

The error comes now also when I try to open ChronoConnectivity in the backend. When I set published of the connectivity to 1 in the Database it works how I need it in the frontend. But I can't create any new or edit old ones.

well, try to make another copy of your table and use it at the 2nd connectivity and see if everything is going good and I will look into a fix for this error!

well, try to make another copy of your table and use it at the 2nd connectivity and see if everything is going good and I will look into a fix for this error!

With the 2nd table it works.

so with 2 different tables everything is as you need ?

so with 2 different tables everything is as you need ?

Thats right. But I only update one table ...

I understand, I'm looking into a fix very quickly right now!

Hi Holger,

First, use the 2 files attached to replace yours under admin/components/com_chronoconnectivitiy/

now, open your first connection, then save it again!
open your 2nd connection then choose the same table and then save!

now test everything and let me know!

cheers

Max

Wow! You are very fast! It works! No problems at the moment!

You do a very good job wiht this components. With chronoform an chronoconnectivity you made a big toolbox for joomla. Thank you very much.

Thanks Holgerman, if you like chronoConnectivity then don't hesitate to leave a review at joomla.org for it, its still new and didn't get any votes/review and adding one will help other users to know more about it🙂

Best regards,

Max