Radicore Forum: Bug Reports » different results in queries

Home » RADICORE development » Bug Reports » different results in queries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: different results in queries [message #637 is a reply to message #636]

Wed, 14 February 2007 10:50

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

No, it is not a bug. Each call to _dml_getData() causes the current setting of $this->rows_per_page to be used in the LIMIT clause. Your code appears to be running inside an UPDATE1 pattern, and if you look inside file 'std.update1.inc' you will see the line:

$dbobject->setRowsPerPage(1);

which tells the system to extract and display 1 record at a time. This setting is still in operation when your custom code is being executed. To remove all limits you must insert the following line before any calls to $this->_dml_getData():

$this->rows_per_page = 0;

Do not forget to reset it aferwards.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		different results in queries By: stephenboey on Mon, 12 February 2007 19:44
		Re: different results in queries By: AJM on Tue, 13 February 2007 04:25
		Re: different results in queries By: stephenboey on Tue, 13 February 2007 08:58
		Re: different results in queries By: AJM on Tue, 13 February 2007 09:16
		Re: different results in queries By: stephenboey on Tue, 13 February 2007 15:09
		Re: different results in queries By: AJM on Tue, 13 February 2007 20:02
		Re: different results in queries By: stephenboey on Tue, 13 February 2007 20:36
		Re: different results in queries By: AJM on Wed, 14 February 2007 04:34
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 08:13
		Re: different results in queries By: AJM on Wed, 14 February 2007 08:56
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 09:02
		Re: different results in queries By: AJM on Wed, 14 February 2007 09:47
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 10:22
		Re: different results in queries By: AJM on Wed, 14 February 2007 10:50
		Re: different results in queries By: stephenboey on Wed, 14 February 2007 11:03

Previous Topic:	dml_updateSelection
Next Topic:	not able to search 'Task Id'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 10:19:14 EST 2024

Total time taken to generate the page: 0.01167 seconds