[redexpertos]

Hello, I have many database fields with minus character in name like "COD-NOMINA"

I got a object using joomla framework
$consulta = "SELECT * FROM tmp_aportes WHERE `COD-NOMINA`='3108801'";
$db->setQuery($consulta);
$aportes = $db->loadObject();

but can´t access property anymore because I can not escape the - sign, how can I access those properties?

[alxkls]

property?? huh? which property??

[redexpertos]

Joomla framework method setQuery builds and populate the object automagically
Joomla! Help Site - [REVIEW] database->loadObject

Properties also known as object vars
PHP: get_object_vars - Manual

The problem is that object var names are taken directly from database field names, and database field names have the minus character inside the name like "COD-NOMINA".

$consulta = "SELECT * FROM tmp_aportes WHERE `COD-NOMINA`='3108801'";
$db->setQuery($consulta);
$aportes = $db->loadObject();

So it is necesary to escape those characters to avoid php attemps to operate a substraction (-) when evaluates the code

for example in this code

echo $aportes->COD-NOMINA ;

because if is not escaped php checks for a "property" $aportes->COD instead the required $aportes->COD-NOMINA

Thanks for any ideas.

[alxkls]

never really used joomla but from what what you posted it seems to be returning the result as a constant:

Code:

echo $aportes->COD-NOMINA ;

so what you could try instead is

Code:

echo $aportes->constant("COD-NOMINA") ;

[redexpertos]

Thanks bradgrafelman, it works.

Quote:
$aportes->{'COD-NOMINA'}
and surely, changing names would be a good decision but it is not an option at this time.