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


332 Views

Avatar
SS_Learner

Community Member, 18 Posts

23 April 2013 at 1:29pm

Edited: 23/04/2013 1:29pm

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..