georgie
Member
Hi
I use a calc element to display informations dynamically, perfect!
But sometimes this information are so long in size that my forms bug.
I use a CSS "overflow" in lists, it is OK. But not in forms.
I have tried to apply a SQL limit in my query ("limit 0,5", in the code of the calc element), but I can not.
Can you help me?
Here my calc code:
THX
I use a calc element to display informations dynamically, perfect!
But sometimes this information are so long in size that my forms bug.
I use a CSS "overflow" in lists, it is OK. But not in forms.
I have tried to apply a SQL limit in my query ("limit 0,5", in the code of the calc element), but I can not.
Can you help me?
Here my calc code:
Code:
// Declaration de la variable stockant l id d'origine
$customer_email = '{customer___email_raw}';
// if-else de gestion des cas vides - pour eviter de declencer une requete WHERE vide
if (!empty($customer_email)) {
// Acces a la base de donnees
$myDb = FabrikWorker::getDbo(false, 1);
// Creation requete - argument true pour nettoyer une eventuelle ancienne requete
$myQuery = $myDb->getQuery(true);
// Requete de recuperation de la valeur concernee en fonction de l id d'origine
$myQuery->select("group_concat(concat('<a href=\"',joo_acymailing_url.url,'\" target=\"_blank\">',date_format(from_unixtime(joo_acymailing_urlclick.date),'%d/%m/%Y'),'</a>') order by joo_acymailing_urlclick.date desc)")
->from('joo_acymailing_url inner join joo_acymailing_urlclick on joo_acymailing_url.urlid = joo_acymailing_urlclick.urlid inner join joo_acymailing_subscriber on joo_acymailing_urlclick.subid = joo_acymailing_subscriber.subid')
->where('joo_acymailing_subscriber.email = ' . $myDb->quote($customer_email));
$myDb->setQuery($myQuery);
$ClicHistory = $myDb->loadResult();
// Calcul
return $ClicHistory ;
}
// If empty
else {
return '';
}
THX