[FX.php List] AddSortParam line shows 0 records

[Dale Bengston]

Denis,

The only time I recall a sort causing a failed query was when the sort field contained a gremlin or some sort of corruption. This is a devilish thing to troubleshoot, though.

Forgive me if this has been suggested before, but things to try:
	- Set up your query so it returns one single record and see if you can sort it.
	- Try sorting on a different field on that layout.
	- Make a new layout and add fields onto it one at a time (no copy and paste from the old layout!) until it fails.

Dale


On Jan 12, 2012, at 11:38 PM, Denis Somar wrote:

> To further the mystery, I tried sorting on another page that works perfectly and it also borks with error 5 but no malformed URL
> 
> I tried reinstalling FX.php in case I had done something with it and still no luck.
> 
> I'm now officially at a complete loss, oy...
> 
> D
> 
> On Thu, Jan 12, 2012 at 4:29 PM, Troy Meyers <tcmeyers at troymeyers.com> wrote:
> Denis,
> 
> Has anyone suggested, or have you tried, just renaming the FileMaker field quote_id to something different, such as qote_id (and of course changing the instances in PHP) to see if that magically cures the problem?
> 
> -Troy
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120114/90a53b44/attachment.html