This topic is locked

Sorting and display

5/5/2007 7:26:52 AM
PHPRunner General questions
O
osluk author

I have a list of wine estimates
http://www.bordeauxreport.com/db-2006-view...SearchField=Ref
The Estimate is a range. For example 95 - 110 is there a way I cannot think of to display this and sort correctly?

Or disable the sort by column feature is another possibility.
Below is the text sort currently displayed to allow the range of price to be displayed.

This works if manually sorted and in print but id not so good from a sort logic point of view.

I did experiment with a mid range price but that would require sorting on a different field from the one displayed.
Any suggestions - perhaps to disable the heading sort would avoid it being an obvious issue!
Cheers Chris
100 - 120

100 - 120

100 - 120

1000 - 1200

1000 - 1300

110 - 120

110 - 130

1100 - 1400

120 - 130

120 - 150

1200 - 1500

125 - 135

130 - 140

130 - 150

140 - 150

140 - 150

140 - 160

150 - 160

150 - 170

150 - 180

150 - 180

Sergey Kornilov admin 5/7/2007

Sorting by range doesn't have much sense.
How do you compare 100-120 and 90-140 ranges?
If would restrict sorting on this column.

O
osluk author 5/8/2007

How can I stop this column being sortable / clickable
Chris

Sorting by range doesn't have much sense.

How do you compare 100-120 and 90-140 ranges?
If would restrict sorting on this column.

Alexey admin 5/8/2007

Chris,
remove column header in Visual Editor and put some text there.

O
osluk author 5/20/2007

Thanks Alexey,
That has fixed by the problem of a column being sortable (when I dont want it to be) but the notes column (set to 240 pixels) is now much narrower.
Any ideas.
Also the overall table width seems to vary. What am I missing.
Chhers Chris

J
Jane 5/21/2007

Chris,
it seems that column width for the 2006 Tasting Notes is assigned twice.

I recommend you to highlight this headeron the Visual Editor tab, turn on HTML mode on the toolbar, find this code:

<TD style="WIDTH: 240px" width=155><P align=center><FONT size=1>2006 Tasting Notes

and replace it with this one:

<TD style="WIDTH: 240px"><P align=center><FONT size=1>2006 Tasting Notes