8 years ago
Topic

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

 

Get a VIP membership
4229 Posts
Kadministrator
8 years ago
1
Level 1

Turn on debugging in list configuration to see how query looks and why you are getting multiple results

8 years ago
0
Level 2

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

8 years ago
0
Level 1

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

Get a VIP membership