 |
Dragon-fyre
User
Mar 27, 2007, 11:44 PM
Post #1 of 8
(2292 views)
Shortcut
|
I am in the process of loading my database for a rental property manager
She would like to have the sorting done by property address.
I am getting some weird results.
I am being very careful to remain consistent with the addresses yet it is doing some odd things. I do understand that using alphanumeric characters can cause problems but that is why I am trying to be so careful with what I'm using.
the following is an example of what it's doing.
215 NW Anthony # 7
215 NW Anthony # 1
215 NW Anthony # 2
215 NW Anthony # 3
215 NW Anthony # 6
215 NW Anthony # 4
The last number set # 7 or whatever is the apt number.
I am using the same system with all and it just keeps doing it. any idea why?
Thanks in advance
Rick
|
|
| |
|
Donna
Staff
/ Moderator
Mar 29, 2007, 9:27 AM
Post #2 of 8
(2277 views)
Shortcut
|
Hi there!
Can you let me know your website address? With that, we can take a look at your site directly and see what's happening with the sorting. :)
Donna
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
Dragon-fyre
User
Mar 29, 2007, 12:10 PM
Post #3 of 8
(2273 views)
Shortcut
|
http://www.helenespropertyplace.com/test/
Click on Available Rental List to see the database.
bear in mind that it is still a work in progress.
Thanks
Rick
|
|
| |
|
DavidH
User
Apr 8, 2007, 11:09 AM
Post #4 of 8
(2167 views)
Shortcut
|
I created a date field with the year 1st,Month 2nd and day 3rd which I dont display in my form, I have a regular date field to display for the form.
Example: 060408
By adding the year,month,day (in that order) the current date is always the largest number.
I add this to the end of my search.cgi?
sort_order=28,123,reverse
(the 28 is the listing field number which you have the sample date placed into - change to match yours), this should work with the homepages also. It must be placed directly after search.cgi? so that the sort gets done first
The current (date) listings (etc) will showup first
http://mysite.com/cgi-bin/rm/exec/search.cgi?sort_order=28,123,reverse
Combine that with another keyword field for mutiple options.
http://mysite.com/cgi-bin/rm/exec/search.cgi?sort_order=28,123,reverse&field28_keyword=new
Im still learning all the commands, and hope this helps
DavidH
|
|
| |
|
ChetW
Staff
Apr 8, 2007, 11:28 AM
Post #5 of 8
(2164 views)
Shortcut
|
Hi DavidH,
Thanks for the post!
It sounds like your getting a good handle on how Listings Manager works, that's great to see! I'm sure that many people in the sommunity will find this tip helpful and we always appreciate it when the community jumps in to help each other out. :)
If there is anything that we can lend you a hand with please feel free to ask.
Cheers,
Chet Woodside - Product Specialist
support@interactivetools.com
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
Dragon-fyre
User
Apr 8, 2007, 11:53 AM
Post #6 of 8
(2162 views)
Shortcut
|
Wonderful. that is something I can put to use.
I really appreciate the help and input.
Rick
|
|
| |
|
Jake
Staff
/ Moderator
Jul 20, 2007, 9:22 AM
Post #8 of 8
(1532 views)
Shortcut
|
Hi niptuck,
Thanks for posting!
You would actually add this bit of code to the end of a link to search.cgi, where X is the field you wanted to sort by:
http://www.yoursite.com/cgi-bin/listman/exec/search.cgi?search=1&sort_order=X,123,reverse
Does this make sense?
Let us know if you have any other questions. 
-----------------------------------------------------------
Cheers,
Jake Swanson - Product Specialist
support@interactivetools.com
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
