 | | |
|
databanks
New User
Oct 29, 2002, 10:26 AM
Post #1 of 4
(1643 views)
Shortcut
|
Thanks for the help on the previous issue.
I am trying to get the search results ordered properly. When I use $ or commas e.g. $1,200,000. in the listing manager fields, it seems to indicate to the database that the field is text and not numeric. The result is that the search results are ordered by, in my case, 123, and not the value in the field I assign. That is to say, ordered by the text value of the field and not the numeric value of the field. So when I try to order results from least expensive to most, I am getting $1,200,000, then $149,900, then $189,900, then $220,000.
When I take the $ and commas out of the listing field in the RM.cgi, the order of results are correct, but the html output looks bad. I can insert a $ before, in my case, lfield7 in all of the templates, but how do I get the commas to show up.
I have seen example sites that have the prices with $ and commas, so I know it can be done, I just don't know what I am doing wrong. I have tried republishing after making changes but to no avail.
Any ideas?
Thanks
|
|
| |
|
Damon
Staff
/ Moderator
Oct 31, 2002, 5:55 PM
Post #2 of 4
(1617 views)
Shortcut
|
Hi,
This is really unusual that your search results are not sorting properly by price. If you send a support request into our Support Team we will be able to look into that for you and find out why that is happening.
Here is the link to the Support Request Form.
Cheers
Damon Edis
interactivetools.com
|
|
| |
|
dlo_itools
Staff
Nov 7, 2002, 10:06 AM
Post #3 of 4
(1590 views)
Shortcut
|
What is your sort_order set to? The only way I could duplicate this behavior was using a "text" sort order e.g.
<input type="hidden" name="sort_order" value="6,abc,forward">
If I use a numeric sort order e.g.
<input type="hidden" name="sort_order" value="6,123,forward">
the results are sorted numerically, even if the data has dollar signs and commas (e.g. $90,000 comes before $100,000)
/Dave Lo
|
|
| |
|
databanks
New User
Nov 7, 2002, 10:23 AM
Post #4 of 4
(1587 views)
Shortcut
|
I got it fixed, although not figured out. I removed the test listings I had, resaved the html and republished the database. It wasn't until I removed the listings (I did that last) and put in new listings that it worked correctly. Anyway, it works now. Thanks for the help.
|
|
| |
|
