Ako resetovat TABLE pre DB query

Ahojte,

mam problem ak v sablone robim SQL Query napr.

{foreach $table->select("id, title$lang AS title")->where('position', 'left')->order('order') as $linkCategoryLeft}
			...
{/foreach}

a nasledne hned nato

{foreach $table->select("id, title$lang AS title")->where('position', 'right')->order('order') as $linkCategoryRight}
			...
{/foreach}

tak pri prvej query ziska data korektne. Pri druhej query ale vybuilduje WHERE (position = left and position = right).

Co s tym ? Dakujem.

Nette : 2.0.12

Editoval aRagornol (27. 9. 2013 21:21)