Smarty

[tsmtsm]

Hello fellow smarties,

I tried by myself and also searched here and there but could not find the correct way to do this.

Here's the problem.....
We ve got a Mysql DB Backend with Fieldnames like this "blabla.bla". (In this case the left of the period is not the table name.)
The following code doesn't work because of the "." in the fieldname.

=========================

{section name=data loop=$result}
<tr>
<td scope="col">{$result[data].InfoPolicy.ID}</td>
<td scope="col">{$result[data].InfoPolicy.ObjectID_FK}</td>
<td scope="col">{$result[data].InfoPolicy.IssueDate}</td>
</tr>
{/section}

=========================
I also tried with backticks on the whole resultstring as well as partially... somehow just trying to be lucky with the code:D.

However I couldn't figure it out..
Can anyone help me with this?

Thank you very much.

[toma]

Modify your abstraction layer to rename all column names, replacing . with _

Good luck!

[tsmtsm]