Buy Now
Sign in

Link from Connectivity to Connectivity

Holgerman , August 15 2008, 08:26
H
Holgerman 6
August 15 2008, 08:26 #11550
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
admin 28
August 15 2008, 11:35 #11553
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
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
H
Holgerman 6
August 15 2008, 12:02 #11554
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
admin 28
August 15 2008, 12:09 #11555
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
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
H
Holgerman 6
August 15 2008, 12:48 #11556
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.
admin 28
August 15 2008, 12:54 #11557
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!
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
H
Holgerman 6
August 15 2008, 13:01 #11558
"admin":
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.
admin 28
August 15 2008, 13:03 #11559
so with 2 different tables everything is as you need ?
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
H
Holgerman 6
August 15 2008, 13:28 #11560
"admin":
so with 2 different tables everything is as you need ?


Thats right. But I only update one table ...
admin 28
August 15 2008, 13:29 #11561
I understand, I'm looking into a fix very quickly right now!
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
admin 28
August 15 2008, 13:41 #11562
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
Attachments
com_chronoconnectivity.zip
(6.71 KiB)
777 Downloads/Views
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
H
Holgerman 6
August 15 2008, 13:58 #11563
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.
admin 28
August 15 2008, 14:04 #11564
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
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!