[Cartoweb-users] Stange query behaviour

[Bruno Friedmann]

Oliver Christen wrote:
> Hi
> 
> default policy for query is POLICY_XOR
> if I try in the demo and select in the query options "union" or
> "intersection", the airport stay selected.
> if you always want policy union (or another) simply define a different
> defaultPolicy in your client.ini but you will need to deactivate the
> extended query options panel (displayExtendedSelection = false)
> otherwise it is not taken into account
> 
> regards
> Oliver
> 
> 
Many thanks Oliver, I realize this later, that emulate a toggle on/off ...
Your information would accelerate the implementation.

Did you try the tests to put ?

; This one stop the id in resulting tables
noRowId = true

I've always the trouble at the second query the ids appear in the result.
It's a bit quiet strange ...


here's the default table.tpl (coreplugins/table/templates/)

{foreach from=$tables item=group}
<h2>{$group->groupTitle}</h2>
{foreach from=$group->tables item=table}
{if $table->numRows > 0}
<table class="cw3table">
    <caption>{$table->tableTitle}</caption>
    <tr>
      {if !$table->noRowId}<th>{t}Id{/t}</th>{/if}
      {foreach from=$table->columnTitles item=column}
      <th>{t}{$column}{/t}</th>
      {/foreach}
    </tr>
    {foreach from=$table->rows item=row}
    <tr>
       {if !$table->noRowId}<td>{$row->rowId}</td>{/if}
       {foreach from=$row->cells item=value}
       <td>{$value}</td>
       {/foreach}
    </tr>
    {/foreach}
</table>
{if $exportcsv_active|default:''}
<div class="exportlink"><a
href="{$exportcsv_url}project={$project}&amp;exportcsv_groupid={$group->groupId}&amp;exportcsv_tableid={$table->tableId}">{t}Download
CSV{/t}</a></div>
{/if}
{/if}
{/foreach}
{/foreach}

Which doesn't work in demoCW3 ( id are always print !! )


here's mine :

{foreach from=$tables item=group}
{* <h2>{$group->groupTitle}</h2> *}
        {foreach from=$group->tables item=table}
        {if $table->numRows > 0}
        <table class="cw3table">
                <caption style="width:260px;">
                {if $exportcsv_active|default:''}
                <div class="exportlink"><a
href="{$exportcsv_url}project={$project}&amp;exportcsv_groupid={$group->groupId}&amp;exportcsv_tableid={$table->tableId}"
title="{t}Download CSV{/t}">
                <img alt="{t}Download CSV{/t}" src="{r type=gfx}exportcsv.png{/r}" style="vertical-align:bottom; width:16px;
height:16px;border-width:1px;" />
                </a></div>
                {/if}
                &nbsp;{$table->tableTitle}&nbsp;
                </caption>
                <thead>
                {if !$table->noRowId}<th>&nbsp;{t}Id{/t}&nbsp;</th>{/if}
                {foreach from=$table->columnTitles item=column}
                <th>&nbsp;{$column}&nbsp;</th>
                {/foreach}
                </thead>
                <tbody>
                {assign var=split value='light'}
                {foreach from=$table->rows item=row}
                <tr class="{if $split == 'dark'}light{assign var=split value='light'}{else}dark{assign var=split
value='dark'}{/if}">
                {if !$table->noRowId}<td>{$row->rowId}</td>{/if}
                {foreach from=$row->cells item=value}
                <td>{$value}</td>
                {/foreach}
                </tr>
                {/foreach}
        </tbody></table>
        <p class="clr_b">&nbsp;</p>
        {/if}
        {/foreach}

{/foreach}

which work in our project, but with the id appear on the second call ...
(Ajax trouble somewhere ? )

in .ini we also have this :


;allows client to ask for attributes
returnAttributesActive = true

;activate Hilight or no
defaultHilight = false

;activates persistence of queries (default true)
persistentQueries = false

;define the default policy ( XOR to Union )
defaultPolicy = union

;displays layers selection form
displayExtendedSelection = false

; the list of layers which will be shown on the hilight selection list
;  if this list is not set, all layers are proposed in the list
; queryLayers =

; This one stop the id in resulting tables
noRowId = true


Any ideas would be really appreciate ... I certainly don't see something but what ;-)




> 
>> Hi all, I'm looking about 2 feedback about troubles found here.
>>
>> They appears in our ouwn projects, but also in democw3
>> cartoweb 3.4 + csv update ( but found also in 3.4 tar)
>>
>> If you select an airport, and query it the data result is shown.
>> But if your reissue the same query, the query result become empty.
>>
>> If you query another time the query result in filled with the data.
>>
>> If you put the no id param in .ini the second time the data is
>> displayed the id become visible.
>>
>>
>> ---
>>
>> In 3.3.0 : We have the following result.
>> Query a airport and you've got the result displayed, if you query a
>> town after, the result set will be completed with the town
>> data not erased.
>>
>> The id trouble work exactly the same ...
>>
>> Did you found the same dis-function ?
>>
>>
>>
>> -- 
>>
>>     Bruno Friedmann  bruno at ioda-net.ch
>>
>> Ioda-Net Sàrl   - www.ioda-net.ch
>>  2830 Vellerat - Switzerland
>>
>>  Tél : ++41 32 435 7171
>>  Fax : ++41 32 435 7172
>>  gsm : ++41 78 802 6760
>>
>> C'est Facile et Cool d'Évoluer en ligne : www.cfcel.com
>>
>>
>> _______________________________________________
>> Cartoweb-users mailing list
>> Cartoweb-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>>
> 


-- 

     Bruno Friedmann  bruno at ioda-net.ch

Ioda-Net Sàrl   - www.ioda-net.ch
  2830 Vellerat - Switzerland

  Tél : ++41 32 435 7171
  Fax : ++41 32 435 7172
  gsm : ++41 78 802 6760

C'est Facile et Cool d'Évoluer en ligne : www.cfcel.com