Skip to main content

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - JuriB

1
Questions / Tag cloud
Hello,
is possible to build a tag cloud from a filed of a database table?
I've tryied with a checkbox list that filters querying on that field of the source ("SELECT  DISTINCT Tag AS value,Tag AS label FROM articoli") but it works fine as log as there is only one tag per record.
If a record has two tags, it takes them as a single one
Has anyone had this problem before?
Thanks in advance
Juri
2
Questions / Lookup in List and View pages
Hello,
i have 2 tables, let's say cars and tables, with this sample data:

(`ID`, `CarName`, `Tyre`)
(1, 'Renault Clio', '2'),
(2, 'Nissan Juke', '3');

(`ID`, `TyreModel`) VALUES
(1, 'Pirelli xyz'),
(2, 'Michelin 180'),
(3, 'Michelin 220');

In Add and Edit pages the lookup works perfectly. I was even able to lookup two and more tables with inner join.
But when it comes to List and View pages, there is no auto lookup, nor something to set in the Tyre Field Property.
Obviously there is no lookup in the published page

In the List Page Properties there is a field to set a join, but it add an inner join with no custom editing possible.
SELECT * FROM cars
INNER JOIN tyres ON cars.Tyre=tyres.ID
This adds other fields to the table than have to be unselected.. and is not  very easy when tables have many fields
Are there others way to get a simple lookup in the List and View pages?

Thanks and best regards
Juri Bertello