[ic] Arbitrary table listings via [page] tag

[Richard Eddy]

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...
>
>Barry
>
>--
>
>Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO
>E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028

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.

Richard.