Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Instant Website: Realty/Listings/Auto:
Sort By Issue

 
 


jarvis
User

Apr 9, 2009, 4:31 AM

Post #1 of 5 (32967 views)
Shortcut
Sort By Issue Can't Post
Hi all,

Sorry to have posted yet again! Although I do appreciate the help. I've set my listings to order by rent ASC:
Code
  list($listingsRecords, $listingsMetaData) = getRecords(array( 
    'tableName'   => 'listings', 
 'orderBy' => 'rent ASC', 
  ));


ross
Staff / Moderator


Apr 9, 2009, 9:18 AM

Post #2 of 5 (32952 views)
Shortcut
Re: [jarvis] Sort By Issue [In reply to] Can't Post
Hi jarvis

Thanks for posting. Could you give me a bit more detail about the actual problem? Everything looks ok to me so far :).
-----------------------------------------------------------
Cheers,
Ross Fairbairn - 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: http://www.interactivetools.com/consulting/



jarvis
User

Apr 10, 2009, 1:08 AM

Post #3 of 5 (32905 views)
Shortcut
Re: [ross] Sort By Issue [In reply to] Can't Post
Hi Ross,

Sorry, I didn't notice the rest of the ticket had been cut off! Basically, the list of properties is being returned in rent order, however, rather than being:

475
550
750
1200
1275

It shows as
1200
1275
475
550
750

I can understand why the values are returned this way but wondered if there was a way of ordering them more like the top list?

Thanks


Damon
Staff / Moderator


Apr 10, 2009, 11:49 AM

Post #4 of 5 (32900 views)
Shortcut
Re: [jarvis] Sort By Issue [In reply to] Can't Post
Hi Jarvis,

Try this:

'orderBy' => 'rent+0 ASC',

That should now sort your numbers correctly.[

--------------------------------------------------- 
Cheers
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/


jarvis
User

Apr 14, 2009, 12:52 AM

Post #5 of 5 (32631 views)
Shortcut
Re: [Damon] Sort By Issue [In reply to] Can't Post
Fan-bloody-tastic! That's done the job!

Thanks very much!

Ian