[ic] Arbitrary table listings via [page] tag

Barry Treahy, Jr. interchange-users@icdevgroup.org
Sat Aug 31 11:45:02 2002


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