[GENERAL] More Rule creation problems (and nowhere near 8K)

2000-01-14 Thread Neil Burrows
new.fax, new.mobile, new.package, current_datetime(), current_datetime(), new.suspended, new.suspended_date, new.deleted, new.deleted_date, new.comments); Regards, ---[ Neil Burrows ]- E-mail: [EMAIL PROTECTED] |

RE: [GENERAL] LIMITS in SELECTs

1999-01-09 Thread Neil Burrows
Hi, > Is there a way to select only a range of rows from a table, using > a command > like: > > SELECT * FROM table WHERE where_statement LIMIT 50,100; Assuming you use a "Order By" clause to make sure you got the records in the appropriate order there is a patch file in the "patches" directory