[TYPO3] MySQL question
livius_agrippa at yahoo.com
Sun Apr 22 17:43:13 CEST 2007
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";
$select = "name, email";
$where = 'fe_users.uid IN (SELECT uid_foreign FROM
tx_cal_fe_user_event_monitor_mm WHERE uid_local = "'.
$moduleCaller->getUid() .'") AND disable = "0" AND deleted = "0"';
$result = $GLOBALS['TYPO3_DB']->exec_SELECTquery($select,$table,$where);
Oliver Rowlands wrote:
> 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.
> Livius Agrippa wrote:
>> 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
>> tx_cal_fe_user_event_monitor_mm WHERE uid_local = "48")
>> The error returned by the MySQL is:
>> #1064 - You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT uid_foreign FROM tx_cal_fe_user_event_monitor_mm WHERE u
>> Best regards,
More information about the TYPO3-english