Forums

Hi, i need to connect to a DB using different queries, so i'm going to set up some ChronoConnectivity connections.
I've made the first one and it works as expected but now when i try do create a new one the save doesn't works anymore and I'm stuck with only one connection at once.

Moreover I was expecting a sort of copy button to duplicate the connections but I have only save/apply/cancel ones, is it correct?

Thanks for any kind of help :-)
Ale

Hi Ale,

Not sure I understand what you are trying to do here.

A ChronoConnectivity listing will only connect to a single table using a simple Query (no JOINs allowed). There is a hacked version in the forums here that can handle a more complex query.

There's also a ChronoForm here that will copy ChronoConnectivity listings.

Bob

I need to connect to a single DB, lets say departures_db but i need to extract from it data filtered by the scheduled destinations.

So i did a connection called destination_a with a SQL query like:

WHERE destination = 'A'

and i can list all the related dapertures, but now i need to list the destinations B, C and so on.

My plan was to create a new connection, to the same table but with different SQL queries. But after I've made the first one i cant create anymore.

Thanks
Ale

Hi Ale,

I don't know whay you can't create more listings. I've not seen that problem reported here before.

But, you can do this with a single listing - either by adding a selector to let the user choose the destination; or by getting the destination info from a calling url.

Bob

Hi again Bob,
yes, its looks weird to me too but I'm a bit in a hurry so i need to fix it now, in the near future I'll try to understand where is my problem.

Your advice to pass in a URL the value sounds great (damn, I should have thought at this by myself 🙂 )
but i don't know how to add a POST variable to a menu item in joomla (be patient, I'm a ASP programmer jumping in a new world)

Hi Ale,

You can use a Menu Item of type External URL to include a parameter. (I think some other menu types will also allow custom parameters.)

Bob

Hi Bob,
thanks a lot, it looks like it works :-)

Hi k.anderson3454,

Seems to work OK from here :-(

Bob