[TYPO3] MySQL question

2007-04-22 Thread Livius Agrippa
Hi, I want to create a service for the cal extension but I encountered a mysql problem. Can someone tell me what is wrong with this mysql statement, because I don't have any idea. SELECT name, email FROM fe_users WHERE disable = "0" AND deleted = "0" AND fe_users.uid IN (SELECT uid_foreign FROM t

Re: [TYPO3] MySQL question

2007-04-22 Thread Livius Agrippa
Hi Oliver, Thank you very much for the information. Indeed, the version of the mysql is 4.0.27-standard-log. But as I said in my first message, I want to rceate a service for cal extension. If you have an idea how can I change this code and if it won't take you to much: $table = "fe_users";

Re: [TYPO3] MySQL question

2007-04-22 Thread Oliver Rowlands
Hi Livius, What version of mysQL are you using? Sub-selects have only been available in mySQL since version 4.1. Upgrade mySQL or split that query into two queries. Regards, Oliver Livius Agrippa wrote: > Hi, > > I want to create a service for the cal extension but I encountered a > mysql pr