#1  
Old 31st May 2012, 03:40 AM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 49
Default SELECT only get the 10 first

When making a simple SQL_Query like
SELECT * FROM Persons

When looping over all I selected I only get the 10 first
When looking in to nexusdb.inc.php i find there is a function ExecuteLimit($query,$limitcount,$limitstart) but my php is not good enought to understand this but I see its limmiting to 10
But when I make a SELECT I want to decide if there should be any limits

so what to do
  #2  
Old 3rd June 2012, 10:15 PM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 49
Default

I found the reason
Dataset has this as default
You have to use xxx->query->setlimitstart(-1) AND xxx->query->setlimitcount(-1) to open it up for the whole set in Your query. You can of course set it to any limit if You wish.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a UDF in a SELECT John Wilfong nexusdb.public.support.sql 2 12th January 2010 11:42 AM
Select Into SueKing nexusdb.public.support.sql 4 9th November 2009 07:15 PM
v2.02 Select from (Select) doesn't work? David Charron nexusdb.public.support.sql 2 15th September 2005 09:53 AM
V2.00 - Select bug Ole Willy Tuv nexusdb.public.support.sql 1 30th June 2005 01:14 PM
Select 'almost' * FROM Tor Tveitane nexusdb.public.support.sql 3 6th June 2005 10:48 PM


All times are GMT +11. The time now is 11:16 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.