MiniVend Akopia Services

[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


Search for: Match: Format: Sort by: