2. PHPRunner General questions
  3. Field Presentation problems
This topic is locked

Field Presentation problems

 		3/2/2006 6:08:34 PM
PHPRunner General questions
G
 greenman author

I have a database, to which I have just added approxiamtely 30 new fields.
When I run phprunner to build the the pages, I find that the new fields are presented at the lhs of the resulting web pages. This is the opposite to the sql database layout, where the same fields are layed out right to left..

example

sql admin shows fieds as
field1 field2 field3 ....... fieldn
phprunner output shows
fieldn ..... field3 field2 field1
In the field order and total screen, it also list the fields so
fieldn

..

field3

field2

field1
which is from last to first
In other words I need to re-order the fields so that more meaningful and often used fields present on the left. Itherefore have to move fields around.
This is most time consuming.
Could PHP runner be changed to allow the order of fields reversal?
cheers

Bill
W
 		webbiz 3/3/2006

You can try editing the Project XML file (projectname.phpr) and then rebuild the project.
Sergey Kornilov admin 3/3/2006

Bill,
you can use drug-and-drop and Move up and Move down buttons on the Fields order and totals Tab .
G
 		greenman author 3/6/2006

Thanks Sergei, but still means I have to move each field one at a time to reverse the order.
cheers

Bill

Bill,

you can use drug-and-drop and Move up and Move down buttons on the Fields order and totals Tab .
G
 		greenman author 3/6/2006

This looks promising.
I look through the project file and find the <strsql> select and the fields following. This is still in the same order as the original. Nothing else seems to show field order.
How do you work out the order or otherwise edit it
cheers
Bill

You can try editing the Project XML file (projectname.phpr) and then rebuild the project.
Sergey Kornilov admin 3/7/2006

Each field in project file has the following properties:

<m_nAddPageOrder>0</m_nAddPageOrder>

<m_nEditPageOrder>0</m_nEditPageOrder>

<m_nListPageOrder>1</m_nListPageOrder>

<m_nViewPageOrder>0</m_nViewPageOrder>

<m_nAdvSearchPageOrder>0</m_nAdvSearchPageOrder>

<m_nPrinterPageOrder>0</m_nPrinterPageOrder>

<m_nExportPageOrder>0</m_nExportPageOrder>


This number defines field position on each generated page.
I guess you can do this much faster dragging and dropping fields in PHPRunner.