limit and order by issuselimit and order by issuse

2001-09-04 Thread shahzad
hello, I am trying to use limit and order by in the same query for paging of records. But faceing the problem that query does not return any row. After removing of limit every thing is working fine. Is it really a bug. Any solution. mysql version 3.23.38 regards, shahzad

MySQL Error: 1146 in Egroupware

2005-01-20 Thread Shahzad, Saleem
Hi, I am using egroupware and in the calendar on a specific day and event I click on the link but MySQL gives me the following error Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 = 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY

support UTF-8

2002-06-03 Thread shahzad sarwar
Hi , Do mysql ver 2.23.X support UTF-8 . If yes , to what extends. I have tried UTF-8 with mysql ver 3.23.37 on windows. It seems as that it support UTF-8 , but tools (utilities ) for mysql does not fully support utf . Have any body have tried that. Regards, shahzad sarwar

RE: support UTF-8

2002-06-08 Thread shahzad sarwar
ql may not work. I have now a complete portal running in mysql + php in utf-8. Regards, shahzad > > Hi Shahzad, > I also want to know whether mySQL support Unicode, utf-8 or not. > If you know anything about this please answer me as soon as possible, > > Sincerely, > Mehdi Z