[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
SQL - Browse-Page
Hiya ppl!
I still got a problem with browsing through my SQL-based-catalog.
When I modify the simple-example a bit, it returns only the first page
always.
Looks like the SQL-Query doesn't get a "count up" so It always querys
the same thing and returns e.g. the first 5 rows if I wanna display 5
items per page.
I tried a solution but that didn't really work and returned in between
1-5 datasets per page depending on the category the item is in.
Heres the code snippet :
[search-region arg="st=sql
sf=Rubrik
se=
tf=Rubrik
tf=ArtNr
sm=yes
ra=yes
ml=20
"]
Rubrik is category
and ArtNr is ArticleCode :)
But as I said... it doesn't always return the maximum number I want (ok,
I know theres this ml=... thingie ... but the simple-demo with scratch
didn't work).
Thanks!!!!
Thorsten
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
Späth & Wien GbR http://netactive.de
Stresemannstr. 46 tspaeth@netactive.de
27570 Bremerhaven Mobil 0177 / 73 11 77 1
Tel. 0471 / 14 08 20 Fax. 0471 / 14 08 25