|
Log in | ||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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 | |
|
|
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 |