Hi! Place the limit clause at the end.
select * from databaseentry where Sub="BarsandPubs" order by Button_Name limit 5; Regards, Dennis Xeepe Phone Solution Team http://en.xeepe.com mailto:[EMAIL PROTECTED] sip:[EMAIL PROTECTED] -----Original Message----- From: nishit sharma [mailto:[EMAIL PROTECTED] Sent: Thursday, November 22, 2007 3:51 PM To: sqlite-users@sqlite.org Subject: [sqlite] error After making command i m getting this error select * from databaseentry where Sub="BarsandPubs" limit 5 order by Button_Name; SQL error: near "order": syntax error can anybody help regards Nishit ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.3/1144 - Release Date: 21.11.2007 16:28 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.3/1144 - Release Date: 21.11.2007 16:28 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------