[FX.php List] Problem with AddSortParam

[Jonathan Schwartz]

Chris,

Records appearing in recid sort order is probably no sort at all. 
Post just the fx portion of both scripts. Include the GET or POST 
lines that define the variables also.


J


At 12:35 PM -0700 10/4/06, Chris Bisgard wrote:
>content-class: urn:content-classes:message
>Content-Type: multipart/alternative;
>	boundary="----_=_NextPart_001_01C6E7EC.490A9EEE"
>
>Hi all,
>
>This is a strange problem, and I'm just not sure how to debug it. I 
>have a fairly simple script that just lists events for any given 
>date from a calendar database in FM8. I am trying to sort the 
>results by date, but no matter what I do with AddSortParam, the 
>results come up sorted by the -recid. Even if I try sorting by a 
>text field instead of date, it still sorts by -recid.
>
>Incidentally, I have a similar script that queries another database 
>on the same server, and it sorts everything fine. The only 
>difference is that the query in the broken script comes from a GET 
>function (hyper-linked from a little calendar table, so people can 
>click the date they want), and the script that works properly 
>uses POST data from a form. Would that have anything to do with it?
>
>I will post the entire script if anyone needs to see it, but mainly 
>I was just hoping for some guidance on what to look for that moght 
>be causing the AddSortParam function not to work. It seems big 
>enough that I must be missing something obvious.
>
>Thanks in advance,
>Chris Bisgard
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 

Jonathan Schwartz
FileMaker 8 Certified  Developer
Associate Member, FileMaker Solutions Alliance
Schwartz & Company
jonathan at eschwartz.com
http://www.eschwartz.com
http://www.exit445.com
415-381-1852