Please Log in to join the conversation.
eciudad wrote: The following SQL script works fine in phpmyadmin, when used in query field and replaced with substitution it does return an error on the email substitution [cfe.cb_cfone_email], like error near '@hotmail.com' . This is the value of a text field entered on screen. Its is obvious that I am missing something and I do not know what.
SELECT cfc.id, CONCAT_WS( ' ', cfc.lastname, cfc.firstname, cfc.middlename, cfc.cb_thirdname) as fullnamedisplay
FROM #__comprofiler as cfc
INNER JOIN #__users as cfu ON cfu.id = cfc.id
WHERE cfu.email in (SELECT [cfe.cb_cfone_email] from #__comprofiler as cfe WHERE cfe.id = [user_id])
SELECT cfc.id, CONCAT_WS( ' ', cfc.lastname, cfc.firstname, cfc.middlename, cfc.cb_thirdname) as fullnamedisplay
FROM #__comprofiler as cfc
INNER JOIN #__users as cfu ON cfu.id = cfc.id
WHERE cfu.email in (SELECT cfe.cb_cfone_email from #__comprofiler as cfe WHERE cfe.id = [user_id])
SELECT cfc.id, CONCAT_WS( ' ', cfc.lastname, cfc.firstname, cfc.middlename, cfc.cb_thirdname) as fullnamedisplay
FROM #__comprofiler as cfc
INNER JOIN #__users as cfu ON cfu.id = cfc.id
WHERE cfc.id = [user_id]
Please Log in to join the conversation.
[lastname] [firstname] [middlename] [cb_thirdname]
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.