article_custom with sort and offset

colak · 2007-06-30 07:58:56

I’m trying to use article_custom with sort and offset but txp returns the following error

tag_error <txp:article_custom category=“img” limit=“5” sort=“asc” /> -> Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘asc limit 0, 5’ at line 1
select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status = 4 and Posted <= now() and ((Category1=‘img’) or (Category2=‘img’)) order by asc limit 0, 5 on line 84

tag_error <txp:article_custom category=“img” limit=“10” offset=“5” sort=“asc” /> -> Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘asc limit 5, 10’ at line 1
select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status = 4 and Posted <= now() and ((Category1=‘img’) or (Category2=‘img’)) order by asc limit 5, 10 on line 84

This is my code…

<txp:article_custom category="img" limit="5" sort="asc" />
<txp:article_custom status="sticky" form="body" id="10" />
<txp:article_custom category="img" limit="10" offset="5" sort="asc" />

The resulting page only shows <txp:article_custom status="sticky" form="body" id="10" /> but not the rest. The code works without the sort but as i would like the oldest article to appear first my options are limited. Can anyone spot what i am doing wrong?

Last edited by colak (2007-06-30 08:00:13)

Mary · 2007-06-30 08:07:15

asc is not a valid sort type, Posted asc is what you want. :)

colak · 2007-06-30 08:15:43

thanks mary…
that did it:)
the txb entry was not that clear

Textpattern CMS

Textpattern CMS support forum

#1 2007-06-30 07:58:56

article_custom with sort and offset

#2 2007-06-30 08:07:15

Re: article_custom with sort and offset

#3 2007-06-30 08:15:43

Re: article_custom with sort and offset

Board footer