Attribute filter with SELECT ALL

Next topic

Author	Message
Gunnar Birkeland	Tuesday 02 May 2006 12:41:55 am Hi Im building a search enginge into my Log Database. It currently has 6 search criterias witch can be <i>empty</i> <b>OR</b> <i>not</i>. So the sorting is done on a attribute_filter basis: I have got 6 of these: {def $first = array(190,'=',$avariable)} wich i wrap into: {def $searchstring = array( $first , $second[..........] )} And finally puts into my fetch: ... 'offset', $view_parameters.offset, 'attribute_filter', $searchstring, 'limit', $numberOfObjects ) )} ... This works just fine, as long as one of my criterias are <b>NOT</b> empty. So what i want to do is the following: My six arrays must be able to contain a SELECT * if the $avariable is not set. Like this {def $first = array(190,'=', 'ALL')} Thanks in advance for all replys. ------------------------------------ Gunnar Birkeland http://www.enternett.no </major> ---------------------------- ez-version: 3.9.3. PHP: 4.4.2-1 MYSQL: 4.0.24
Gunnar Birkeland	Tuesday 02 May 2006 1:02:22 am Hi there In case anyone wonders, a way around this is of course with the operator NOT LIKE, like this: {def $first = array(191,'!=','phlaskdjf')} This way every variable of this id that does not match the criteria gets fetched. Thank me. (<i>This is becoming a habit...</i>) -G </major> ---------------------------- ez-version: 3.9.3. PHP: 4.4.2-1 MYSQL: 4.0.24

Author

Message

Tuesday 02 May 2006 12:41:55 am

Im building a search enginge into my Log Database. It currently has 6 search criterias witch can be empty OR not.
So the sorting is done on a attribute_filter basis:
I have got 6 of these:

{def $first = array(190,'=',$avariable)}

wich i wrap into:

{def $searchstring = array( $first , $second[..........] )}

And finally puts into my fetch:

...
'offset', $view_parameters.offset,
'attribute_filter', $searchstring,
'limit', $numberOfObjects ) )} 
...

This works just fine, as long as one of my criterias are NOT empty.
So what i want to do is the following:
My six arrays must be able to contain a SELECT * if the $avariable is not set.
Like this

{def $first = array(190,'=', 'ALL')}

Thanks in advance for all replys.

------------------------------------
Gunnar Birkeland
http://www.enternett.no

</major>
----------------------------
ez-version: 3.9.3.
PHP: 4.4.2-1
MYSQL: 4.0.24

Gunnar Birkeland

Tuesday 02 May 2006 1:02:22 am

Hi there

In case anyone wonders, a way around this is of course with the operator NOT LIKE, like this:

{def $first = array(191,'!=','phlaskdjf')}

This way every variable of this id that does not match the criteria gets fetched.

Thank me. (This is becoming a habit...)

-G

</major>
----------------------------
ez-version: 3.9.3.
PHP: 4.4.2-1
MYSQL: 4.0.24

eZ debug

Timing:	Jan 18 2025 19:27:49
Script start
Timing:	Jan 18 2025 19:27:49
Module start 'layout'
Timing:	Jan 18 2025 19:27:49
Module start 'content'
Timing:	Jan 18 2025 19:27:49
Module end 'content'
Timing:	Jan 18 2025 19:27:49
Script end

Main resources:

Total runtime	0.0175 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	589.0547	152.6250
Module start 'layout'	0.0066	0.0035	741.6797	39.4453
Module start 'content'	0.0101	0.0054	781.1250	89.4609
Module end 'content'	0.0155	0.0019	870.5859	30.3047
Script end	0.0175		900.8906

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	14.3523	14	0.0002
Check MTime	0.0011	6.1560	14	0.0001
Mysql Total
Database connection	0.0012	7.0256	1	0.0012
Mysqli_queries	0.0032	18.2065	3	0.0011
Looping result	0.0000	0.0968	1	0.0000
Template Total	0.0015	8.8	1	0.0015
Template load	0.0009	5.2184	1	0.0009
Template processing	0.0006	3.5394	1	0.0006
Override
Cache load	0.0006	3.5216	1	0.0006
General
dbfile	0.0003	1.4405	8	0.0000
String conversion	0.0000	0.0572	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs