I have created a simple list which is working OK but now want to use sortable headers. For a column called "LastName" in the SQL table, I have used the syntax for the inbuilt SORT function and added this to the Group Header section

Would have given you the syntax I've used but this seems to be doing silly things to this post.

However, this does not appear to be sorting the table on this column when I click the link

Your help would be greatly appreciated in "sorting" this problem out

First off, welcome to the ListX Developers forum! It can sometimes be a little bit difficult to get the formatting to appear within the confines of the Forum, but there are ways of making it work. I personally tend to use the "Code Highlighter" by ActiProSoftware to present the preferred display to the output window. Check out Paste Code Sample for testing out the syntax. Now, on to your question! Sorting is defined fairly well within the help documentation (Click Here)

Sorting and Sort Actions
The complete usage of Sorting involves 3 basic principles, the first two involve inclusion of the sorting semantics into the List Format html, discussed within the Sorting help. You would need to specify first the Action syntax for the link itself, followed by the Sort Header syntax.

Sort Syntax: {SORT,ColumnName,StandardText,AscendingText,DescendingText,DefaultOrder,SortIndex}

Sort Header Syntax:
{SORTHEADER,SortIndex}

Example:
<tr>
    <th><a {SORT,LastName,Last Name,Last Name < img src=asc.gif>, Last Name <img src=desc.gif>,ASC,1}>{SORTHEADER,1}< / a>< / th>
< / tr>

Beyond this, the syntax of the query must provide placement for the sorting mechanisms, meaning the usage of the [SORTTAG] contained within your specified rendering query. Read about the usage of the Sort tag within the

After about 8 hours of playing around with ListX, I have various modules interacting, and the sortheaders working.

Now, I need to format them..and have hit a wall..regardless of formatting applied, with the exception of the Background image applied with a <td class=menubg> tag, there seems to be some sort of implied formatting on the sort headers which I cannot override. Non-"sort header" cells format normally.

<a {SORT,LastName,Last Name,Last Name < img src=asc.gif>, Last Name <img src=desc.gif>,ASC,1}>{SORTHEADER,1}< / a>

I want to make the normal state font color WHITE, so I can use a dark colored background, and expected to be able to see the SORT CSS classes (mouseover, etc) which are applied in the documentation, so I could add them to the skin CSS and control their presentation. I even purchased your CSS Editor, to aid in this effort..to no avail.

Is there some separate CSS file for ListX? What are the classes applied?

Help?

Regards,

John S Main, CPA, CNE, MCSE
Plexus Corp.

Hi John,

Try Using Diffrent calss for your SORT Headers and have that classs defined in Portal.css

Ex:

<a {SORT,LastName,Last Name,Last Name < img src=asc.gif class="SortHeader">, Last Name <img src=desc.gif>,ASC,1}>{SORTHEADER,1}< / a>


and in your Portal.css add the classes like

a.SortHeader:Link, a.sortHeader:Active, a.SortHeader:Visited
{
color:#FFFFFF;
}

a.SortHeader:hover
{
color:#EEEEEE;
}

I have tried different Class, also tried font color tag, the color of the Sort column header refuses to change?

What am I missing?

Thanks, Walter.

Could have a syntax issue...what does the first row of your table look like?

This what I have, tried many different ways.

Thanks, Walter.

<td color="white">
<A {SORT, gp_no, "<div style='color=white'>GP Part</div>", "^ GP Part ^", "v GP Part v",,5}>{SORTHEADER,5}</A> </td>