MySQL Forums
Forum List  »  Microsoft Access

Re: Function sequence error
Posted by: Eddie Stuart
Date: December 14, 2004 11:35AM

I have just upgraded from 4.0 to 4.1 and now get this error on just one SQL read statement in an ASP application.

It works fine on my test server and other SQL (even in the same page) work fine on the production box, apart from this one.

It isn't even consistent - I select 5 records at a time using LIMIT and some groups of 5 work fine, others don't.

Confusion therefore reigns - if it always worked I would have somewhere to start.

The SQL is:-
SELECT SQL_CALC_FOUND_ROWS * FROM ClassAds WHERE CategID="16" AND CategTyp="Sell" AND Visible="Yes" AND Starts<=Now() AND Expires>Now() ORDER BY TimeLogged DESC LIMIT 0, 5;

Any ideas?

TIA,

Eddie Stuart

Options: ReplyQuote


Subject
Views
Written By
Posted
6161
November 09, 2004 08:03AM
Re: Function sequence error
3097
December 14, 2004 11:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.