Thanks On Nov 22, 2007 6:35 PM, Dennis Povshedny <[EMAIL PROTECTED]> wrote: > 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] > ----------------------------------------------------------------------------- > >
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------