Hi,
I have created an own table with 10 lines. I create a liste with a query components filled by:
select title as mon_titre, id as id_item from #__cck_store_spec_component_user
The part list of template is filled by 2 fields "mon_titre" and "id_item" with storage part linked to corresponding table and field.
The result is a list with more than 10 results, displayed on 2 pages, first page with item listed without order and lot of blank line (see below) and next page in correct order but with blank line between each line (see below). I don't( understand why I have this result.
First page of the list:
Second page:
Thank you for help me.
Gérard
Turn on debugging in list configuration to see how query looks and why you are getting multiple results
Hi Klas,
With debug mode the SQL query is not the one that I have entered:
My Query: select t0.title, t0.id from #__cck_store_my_own_table as t0 ( note than the table "#__cck_store_my_own_table" is a table that I have created himself out off Seblod context)
Query show with debug:
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS
parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS
loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
LIMIT 25
SELECT COUNT(t0.id)
FROM `#__cck_core` AS t0
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
It is very far of my query !
I have tried with component Query (part of search components), If I used the mode "autonome" I have no result, if I used the mode "suffix", the query used is also not the same than my query
Hi Klas,
I have found the reason. With the SQL Query you must used the cck_storage_location and don't forget to set dynamic value to free.
Now list is correctly displayed.
Thank you for your help
Gérard