SQL-WHERE Expression

14 years 3 months ago #129 by
SQL-WHERE Expression was created by
After defining the where clause under Joomla Catalog view - Parameters (Basic) - SQL-WHERE Expression (eg.appname='myapp'), catalog view shows only records where appname='myapp'. This is correct.
But, selecting 'All' option from alphabox or limitbox, as defined in Catalog view template using {joodb alphabox} and {joodb limitbox}, yields ALL records.

Please Log in to join the conversation.

14 years 3 months ago #130 by
Replied by on topic Re:SQL-WHERE Expression
Just to make it clear, I suppose it should display ALL records where appname='myapp' in a 1 page as opposed to ALL records from the table.







[KC 2010-06-24 09:24:04]:



After defining the where clause under Joomla Catalog view - Parameters (Basic) - SQL-WHERE Expression (eg.appname='myapp'), catalog view shows only records where appname='myapp'. This is correct.
But, selecting 'All' option from alphabox or limitbox, as defined in Catalog view template using {joodb alphabox} and {joodb limitbox}, yields ALL records.



Please Log in to join the conversation.

Moderators: Dirkjoest