jQuery Grid Plugin - jqGrid - Topic: Valid Select SQL? http://www.trirand.com/blog/?page_id=393/help/valid-select-sql Simple:Press Version 5.7.5.3 ashore on Valid Select SQL? http://www.trirand.com/blog/?page_id=393/help/valid-select-sql#p22559 Help http://www.trirand.com/blog/?page_id=393/help/valid-select-sql#p22559 Whooops, my error.  The MySQL complaint wasn't re my sql, but rather about setGridOptions(sortname), which was indeed ambiguous.

]]> Sun, 27 Mar 2011 04:12:33 +0300 ashore on Valid Select SQL? http://www.trirand.com/blog/?page_id=393/help/valid-select-sql#p22558 Help http://www.trirand.com/blog/?page_id=393/help/valid-select-sql#p22558 Folks, I wd have thought that any sql handled OK by PHPMy Admin - sans error report - wd be accommodated by $grid->SelectCommand.

But not so, since I'm getting a complaint from the plugin.  From which i infer that the plug-in does some pre-processing and possibly appends some additional clauses.

If so, (a) what's appended?  (b) is there some way to get at the sql actually handed off to MySQL? (c) suggestions?

]]> Sun, 27 Mar 2011 04:04:11 +0300