[ic] Arbitrary table listings via [page] tag

Barry Treahy, Jr. interchange-users@icdevgroup.org
Sun Sep 1 12:50:03 2002


Richard Eddy wrote:

>
>
> At 11:44 PM 31/08/2002, you wrote:
>
>> Richard Eddy wrote:
>>
>>> My MySQL database contains an arbitrary table called "ecomposers" 
>>> containing
>>> a list of composers with two fields, code and composer.
>>>
>>> I can display a list of the entries in the composer field beginning 
>>> with "B"
>>> using a loop within a page such as:
>>>
>>> [loop search="
>>>         fi=ecomposers
>>>         ac=yes
>>>         bs=yes
>>>         st=db
>>>         sf=composer
>>>         se=B
>>>         su=yes
>>>         ra=yes
>>>         rf=all
>>>         tf=composer
>>>         "]
>>>     [page scan     ... ][loop-data ecomposers composer][/page]<BR>
>>> [/loop]
>>>
>>> However, no matter what code I put within the
>>> [search-region]...[/search-region] tags on page "test.html" I cannot
>>> generate a similar list with:
>>>
>>> [page scan
>>>     fi=ecomposers
>>>     ac=yes
>>>     bs=yes
>>>     st=db
>>>     sf=composer
>>>     se=B
>>>     su=yes
>>>     ra=yes
>>>     rf=all
>>>     tf=composer
>>>     sp=test
>>>     ]My link
>>> [/page]
>>>
>>> which generates:
>>>
>>> ../cgi-bin/buywellic2/scan/fi=ecomposers/ac=yes/bs=yes/st=db/sf=composer/se 
>>>
>>> =B/su=yes/ra=yes/rf=all/tf=composer/sp=test.html
>>>
>>> I have been unable to resolve the following problem despite many hours
>>> reading the manuals and the forum messages and would appreciate any 
>>> help you
>>> can give.
>>
>>
>> Richard, is it safe to presume that you duplicated the code within 
>> the search-region in your test.html just as you can find in the 
>> results.html file?  Specifically, do you have the search-list tags as 
>> well the error processing for no-matches?
>>
>> If so, you must be seeing something...
>>
> Since receiving your reply I have done as you suggested, replacing the 
> code between the search-list tags of a working results.html file but 
> the results are the same.
>
> With [item-field composer] I get blank lines equal to the number of 
> matches I would expect instead of composer names.

Put the [dump] tag into the target page and then look at the last search 
element.  I had a problem where scan was creating loops with invalid 
names, its a long shot but perhaps you might be seeing the same thing ...

Barry

-- 

Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO 

E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028