Forums

Hi
First question so here goes

I have selected my table under functions and everything works fine. However with the Where clause I need to display data according to a value in the url.. ie mysite.com.au/456

That url is actually a Joomla article and i would like to display some extra data relating to that article.. so how would i go about setting the Where clause to = 456 then only show that data and so on for other pages

Even a push in the right direction will be very helpful

Thanks🙂

Hi ponygirl,

Is this CCv5 or the newer v6? It might need a different answer.

Bob

sorry it's v6

Hi ponygirl,

I'm new to CCV6 so having to work this out from scratch.

I have found that if there is a url parameter like &id=999 then {data:id} will show the value.

I can't see so far how to parse a url like mysite.com.au/456

Bob

Hi,

How do you run Connectivity v6 when you access: mysite.com.au/456 ??

If this is a Joomla article link then it will be routed to the default Joomla article page and Connectivity will not run unless its loaded using a Joomla plugin.

Best regards,
Max

HI GH,
I've the same question: I'm a really new to all the world of joomla and so on CCv6. I'm Italian and my english is not so good.

Like described in your FAQ (the only one about CCV6) the line "Article.id:{data:id} filter the resultset with a URL parameter. It works for me, but not when I add a default parameter.

Example:
I've a table named "nc" with a char(1) column "RI" (I,R,V, etc..)
If I write nc.RI:{data:nc_ri/I} the result without parameter in URL is this

FROM `web_lista_nc` AS `nc` WHERE `nc`.`RI` = '{data:nc_ri' ORDER BY `nc.D_NC` DESC LIMIT 30;

I try also whit PHP code, like a I see in a CCv5 FAQ but seems CCv6 not parse correctly the array that php return.

thanks in advance

Hi Natalini,

Do you have the latest Connectivity v6 update ? if yes then please download and install the latest Chronoforms v6 update too, because it has the fix for this issue.

Best regards,
Max

Thanks Max,
now I'm on CCv6 6.0.2 and CFv6 6.0.4 but in the function tab, database, read data, I can't select an external DB table. Also in an existing and working connection. Have I to change something else?

bye
Marco

Hi Marco,

Why can't you select an external db table ? what happens exactly or what do you find ?

You should provide the external db details and enable it then save the form/connection before the tables appear.

Best regards,
Max

Hi Max,
I'm not creating a classic www.site but an intranet work site where migrating all my old MSaccess frontend so every kind of OS can connect and browse the data. By now data is stored on Mysql and with your powerful components I'm looking to publish the data needed by my users.

The external DB option worked since I've update to CFv6.0.4. Now, also after have applied changes, the dropdown menù can't read the external db table list and so I can't choose the table I need.

The connection I've created before update works right, but also in these I can't change db table.

Hope it was clear.

Hi Marco,

If the external db details are correct then the tables dropdown should have the tables list in this database, what does it show in the dropdown after you save the connection ? does it show "DB connection failed" ? or an empty dropdown ?

Best regards,
Max

Hi,
yes there were 2 lines:

------select table------
Database connection failed

... but I found now: before updating I was using DBtype "mysqli" and now I've try to change in "mysql" without 'i' and it cames back to work.

please, forgive me.

Hi Marco,

Great, no problems!

Best regards,
Max