Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions

Number of records after using the SQLQuery in SS3


Reply

270 Views

Avatar
SS_Learner

23 April 2013 at 1:29pm (Last edited: 23 April 2013 1:29pm), Community Member, 18 Posts

Hi Friends

Is it possible in Silverstripe 3 with SQLQuery that i can get only few records?
i have a query in which "Where Isused=1" have 5 records shows me the result properly in slick grid as required.
And the other query is "Where Isused=0" which have more the 150 records,which don't execute my query and i don't get the result.
when i run my query in the phpmysql it gives me proper result but not when i run it with SQLQuery () in SS3..

Thanks for any kind of help provided..