[ic] [more] / [more-list] Alpha Numeric

Brian Kosick interchange-users@interchange.redhat.com
Wed Oct 10 13:18:01 2001


At 01:03 PM 10/10/01 -0400, you wrote:
>Brian - Try this:
>
>         [query list="1" more="1" ml="15" sql="SELECT * FROM products"]
>                 [list]
>                 <TR>
>                         <TD><FONT SIZE=1
>FACE=Verdana>[sql-code]</FONT></TD>
>                         <TD><FONT SIZE=2 FACE=Arial>[sql-param
>title]</FONT></TD>
>                         <TD ALIGN=RIGHT><FONT SIZE=2
>FACE=Arial>[sql-price]</FONT></TD>
>                 </TR>
>                 [/list]
>
>                 <TR>
>                 <TD COLSPAN=3 ALIGN=CENTER>
>                 [more_list]
>                         [next-anchor]<FONT
>COLOR=#0000FF>>></FONT>[/next-anchor]
>                         [prev-anchor]<FONT
>COLOR=#0000FF><<</FONT>[/prev-anchor]
>                         [page-anchor]<FONT
>COLOR=#0000FF>$PAGE$</FONT>[/page-anchor]
>                         [more]
>                 [/more_list]
>                 [no-match]No Matches Returned[/no-match]
>                 </TD>
>                 </TR>
>         [/query]
>
>This works just fine... :-)
>
>Jason.
<snip>

Ahhhh  Ok i figured it out.  Your code would work great, but I'm trying to 
use the Alpha Numeric feature of the more list, that is, instead of 
displaying numbers for the more-list (previous 1 2 3 4 5 6 next), it would 
display (previous A B C D E F G next)

However your reply did give me my needed insight/clue.  Instead of using 
the [sql-param] tag, I switched it to [sql-field]  Every thing works great 
now!  Thanks everyone for the help and patience.