2. PHPRunner General questions
  3. let it not appear if it is null
This topic is locked

let it not appear if it is null

 		5/21/2008 11:22:36 AM
PHPRunner General questions
U
 uludag author

Hi,
Again, I came up with some questions. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8555&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' />
Firstly, there appear some cells in view menu of my project for books like pages, publication place, translator, barrower etc.
Some of these cells are sometimes null. To illustrate, one time, the barrower of a given book is full, and another time the barrower cell for the same book may become null. The question is that: Is it possible the cell does not appear at all if it is null?
Secondly, when I work with a project of multiple language, I am not able to change the colour and format of some things like advanced search, export results, details found, page, records per page. This does not happen when the project contains one language.
Lastly, in basic search (not advanced), ID's create problem. For instance, the search for publicationplaceid does not find the results. As far as know, there is not a visual editor in list page, how can I comeover this problem? Having the visual editor, the search page does not create this problem.
As always, I am sure that you will do your best to answer these questions. I am really grateful for your invaluable support in here.
Sincerely,
J
 		Jane 5/22/2008

Hi,
please see my answers below:

  1. edit your pages on the Visual Editor in HTML mode.

    Here is a sample:
    {if $show_FieldName!=""}

    <TR>

    <TD class=shade width=150>FieldName</TD>

    <TD width=250>{$show_FieldName}</TD>

    </TR>

    {/if}


2. to change format of links in the multi-language project edit it in the HTML mode. We'll fix this issue in the next PHPRunner version.
3. I suppose you set up publicationplaceid as dropdown on the "Edit as" settings dialog on the Visual Editor and Link field and Display field are different. In this case to search for publicationplaceid field edit your SQL query on the Edit SQL query tab, join main and lookup table, check off display field on the list and search pages on the Choose fields tab and use this field in the search.