At 19:40 +0200 on 24/5/2002, Tzahi Fadida wrote:
> p.s: i searched the net and they say error 28 is "not enough >space", but i don't think it is connected to space since most of my >phpnuke queries works fine, and the error only happens with order by. That's where you're wrong, buddy. It may well be a space problem. You see, without the order by, all it has to do is a join on three table, meaning that it doesn't need any temporary space for the result. It just scans the three tables, matches records to your conditions, and when they match, out they go to the caller. Whereas, when you have an order-by clause, you need some temporary storage, where you store all the results from the query, and then sort them. Space problem it is - trust the error message, this is not a Microsoft product... Herouth -- EMAIL: [EMAIL PROTECTED] HOME PAGE: http://herouth.port5.com/ ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
