Sorry for the second post, but I'm exhausted at looking through the archives trying to find an example of a LIMIT function that accepts a WHERE clause, ORDERs the results before LIMITing them, and can be implemented without rewriting existing code. Something in a stored procedure would be nice.

I've spent way too much time searching the archives only to repeatedly see the same answers (small sampling):

1) look in our archive
http://archives.neohapsis.com/archives/dev/sapdb/2003-q1/0566.html
http://listserv.sap.com/pipermail/sapdb.general/2001-December/004191.html
http://listserv.sap.com/pipermail/sapdb.general/2002-April/006134.html

2) Why would anybody want to do that?
http://listserv.sap.com/pipermail/sapdb.general/2001-December/004147.html

3) SAPDB LIMIT like functions without ORDER BY
http://www.mail-archive.com/[EMAIL PROTECTED]/msg01356.html
http://listserv.sap.com/pipermail/sapdb.general/2001-December/004147.html

Anyway.. I've just about given up on using SAPDB. Is it possible that someone actually has a stored procedure that simulates MySQL's LIMIT function? If someone has done this, would you please post the stored procedure for future reference. If there is another technique that can be done without rewriting existing code (expect for the query, of course), I would love to see that too. Any help would be greatly appreciated.

Thanks -- Joel

--
Joel Griffiths - Software Engineer - Go Daddy Software
480-505-8800 #371 - 480-688-5343 (Cell)
14455 North Hayden Road, Suite 226, Scottsdale, AZ 85260


-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to