Forum

November 2nd, 2014
A A A
Avatar
sp_LogInOut Log In

Lost password?
sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
Go to Bottom
The forums are currently locked and only available for read only access
This topic is locked No permission to create posts
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Valid Select SQL?
Tags: sqlmysql
27/03/2011
04:04
Avatar
ashore
Member
Members
Forum Posts: 3
Member Since:
27/03/2011
sp_UserOfflineSmall Offline
Go to Top
1sp_Permalink sp_Print

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?

27/03/2011
04:12
Avatar
ashore
Member
Members
Forum Posts: 3
Member Since:
27/03/2011
sp_UserOfflineSmall Offline
Go to Top
2sp_Permalink sp_Print

Whooops, my error.  The MySQL complaint wasn't re my sql, but rather about setGridOptions(sortname), which was indeed ambiguous.

This topic is locked No permission to create posts
sp_Feed All RSS
Go to top
Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
29 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information