This topic is locked

Truncated Text Fields

5/17/2009 6:40:21 PM
PHPRunner General questions
R
rgfischerjr author

I have a text field for a product specification that is set to 500 characters in the database.
In PHPR, I have checked 'truncate' and set the display to 100 characters... on the list page this works fine - click '...more' and the popup shows the entire text.
On the Printer Friendly page - the truncated text is displayed... with no way to click 'more' on a printout this is a bit of a problem.
Is there a way to have the truncated text on the list view but have the full text print out?

J
Jane 5/18/2009

Hi,
as workaround create alias for this field on the Edit SQL query tab:

select field1,

field1 as field1_print,

...

from TableName


Then set up field1_print as HTMLon the "View as" settings dialog on theVisual Editor tab.

R
rgfischerjr author 5/19/2009

Hi,

as workaround create alias for this field on the Edit SQL query tab:
Then set up field1_print as HTMLon the "View as" settings dialog on theVisual Editor tab.


Jane - you are a life saver. Where do I send your christmas present???