Fetch limit of zero doesnt give zero results?

Next topic

Author	Message
steve walker	Thursday 07 October 2004 1:47:48 am Hi there, Am seeing something strange with fetches and limits - seems that if you specify a limit of '0' it is interpreted as no limit at all. I am using Paul B's contrib from http://ez.no/community/contributions/hacks/more_attribute_filter_operators_and_fetch_by_owner_id but have tested it on normal fetch and seems to replicate same result. So, for instance - in folder.tpl, if you change 'page_limit=10' to 'page_limit=1' you get 1 result returned. If its changed to 'page_limit=0' you get full list of results returned rather than none. The reason I need to achieve this is so this will work: http://www.ez.no/community/forum/setup_design/advanced_search_development_homemade_fuzzy_logic/re_advanced_search_development_homemade_fuzzy_logic__17 Is it not possible to have a zero page limit return zero results? Thanks, Steve. http://www.oneworldmarket.co.uk
Paul Borgermans	Thursday 07 October 2004 3:06:29 am Hi Steve, limit 0 means limit = false, so it is by design and has nothing to do with ly modifications. I think you should surround the fetch by a test with {section show= } and not perform the test at all when you should not retrieve nodes. hth -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
steve walker	Thursday 07 October 2004 3:26:50 am OK, Thanks Paul. Will go down the section route! Regards, Steve. http://www.oneworldmarket.co.uk

Author

Message

Thursday 07 October 2004 1:47:48 am

Hi there,

Am seeing something strange with fetches and limits - seems that if you specify a limit of '0' it is interpreted as no limit at all.

I am using Paul B's contrib from http://ez.no/community/contributions/hacks/more_attribute_filter_operators_and_fetch_by_owner_id but have tested it on normal fetch and seems to replicate same result.

So, for instance - in folder.tpl, if you change 'page_limit=10' to 'page_limit=1' you get 1 result returned. If its changed to 'page_limit=0' you get full list of results returned rather than none.

The reason I need to achieve this is so this will work: http://www.ez.no/community/forum/setup_design/advanced_search_development_homemade_fuzzy_logic/re_advanced_search_development_homemade_fuzzy_logic__17

Is it not possible to have a zero page limit return zero results?

Thanks, Steve.

http://www.oneworldmarket.co.uk

Paul Borgermans

Thursday 07 October 2004 3:06:29 am

Hi Steve,

limit 0 means limit = false, so it is by design and has nothing to do with ly modifications.

I think you should surround the fetch by a test with {section show= } and not perform the test at all when you should not retrieve nodes.

hth

-paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

steve walker

Thursday 07 October 2004 3:26:50 am

OK, Thanks Paul.

Will go down the section route!

Regards, Steve.

http://www.oneworldmarket.co.uk

eZ debug

Timing:	Jan 19 2025 20:06:47
Script start
Timing:	Jan 19 2025 20:06:47
Module start 'layout'
Timing:	Jan 19 2025 20:06:47
Module start 'content'
Timing:	Jan 19 2025 20:06:48
Module end 'content'
Timing:	Jan 19 2025 20:06:48
Script end

Main resources:

Total runtime	0.7196 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	590.4063	152.6406
Module start 'layout'	0.0066	0.0034	743.0469	39.4766
Module start 'content'	0.0100	0.7082	782.5234	531.5781
Module end 'content'	0.7182	0.0014	1,314.1016	12.2813
Script end	0.7196		1,326.3828

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.4956	16	0.0002
Check MTime	0.0016	0.2228	16	0.0001
Mysql Total
Database connection	0.0012	0.1667	1	0.0012
Mysqli_queries	0.6704	93.1537	57	0.0118
Looping result	0.0005	0.0720	55	0.0000
Template Total	0.6854	95.2	2	0.3427
Template load	0.0022	0.3083	2	0.0011
Template processing	0.6832	94.9288	2	0.3416
Template load and register function	0.0002	0.0343	1	0.0002
states
state_id_array	0.0020	0.2750	1	0.0020
state_identifier_array	0.0018	0.2488	2	0.0009
Override
Cache load	0.0018	0.2558	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0864	2	0.0003
Fetch class attribute name	0.0014	0.1951	4	0.0004
XML
Image XML parsing	0.0006	0.0901	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0012	4	0.0000
General
dbfile	0.0008	0.1113	17	0.0000
String conversion	0.0000	0.0010	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs