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

[Jason Korkin]

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.


Brian Kosick wrote:
> 
> At 06:02 PM 10/9/01 -0400, you wrote:
> ><snip>
> >
> >It works fine for me with the patch, essentially the same code (sku /
> >description instead of code / name). I am guessing that your "order by
> >name" is not working how you think....or that there is something the matter
> >with mc=1. Try removing that.
> >
> >As far as quoting goes, you should if you can quote every parameter
> >which is not fitting the character class \w+.
> >
> >--
> >Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
> >phone +1.513.523.7621      <mheins@redhat.com>
> >
> >Fast, reliable, cheap.  Pick two and we'll talk.  -- unknown
> <snip>
> OK, then maybe its my code to display the list.  Here's my complete test code.
> 
> [query list="1" ml="50" more="1" ma="yes" mc="1" rf="code,name" tf="name"
> st="db" sql=|
>          SELECT code, name
>          FROM products
>          ORDER BY name
>          |
> ]
> [more-list]
> <BLOCKQUOTE>
> Matches [matches] of [match-count] found.
> <BR>[more]<BR>
> </BLOCKQUOTE>
> [/more-list]
> </CENTER>
> <table>
> <tr><td>Code</td><td>Name</td></tr>
> [list]
>          <tr>
>          <td>[sql-param code]</td>
>          <td>[sql-param name]</td>
>          </tr>
> [/list]
> </table>
> [/query]
> 
> Should I use something other than [list] or [sql-param] to display the
> items?  It displays the more-list correctly now, but not the item information.
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users

-- 
---------------------------------------------------------------
**** Virtual Hosting w/ Interchange, $20/month! ****
---------------------------------------------------------------
KORKSOFT - Software & Internet Solutions
Interchange, E-Commerce, C++/Perl/PHP/ASP
http://www.korksoft.com
Tel: (561) 642-7005 x 201