Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > Transformations for custom tables View modes: 
User avatar
Member
Member
eagleag - 12/23/2009 7:30:14 AM
   
Transformations for custom tables
Hi,
I've created a document type.
One of it's fields is populated by "SQL Query (it must return value and text fields)".
the sql gets its info from a custom table.

I'm using a repeater (web part) with it displaying the that field.

<li><# EVAL("fieldName)  %#></li>


in the browsers this transformation displays like this:

option1 | option2 | option3 |

when I view source :

<li>option1 | option2 | option3 |</li>


Why isnt the <li></li> wrap each showing of information?
what is it wrapping the whole thing insted of each bit of info?

MANY THANKS:)



User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 12/23/2009 8:28:59 AM
   
RE:Transformations for custom tables
Hi,

it stores the options in this format in database (in one field of table). So if you eval the field it returns that content.

You could develop a custom transformation function: http://devnet.kentico.com/docs/devguide/adding_custom_functions_to_transformations.htm which would replace the “| ” by “</li><li>”.

Best regards,
Helena Grulichova