New user - Question - Q2

Stephan,
sure you can do it to edit SQL query on the Edit SQL query tab in the following way:

where table1 is your actual table name.

Thanks for that one, works great! Now for a bigger challenge:

1. As template features are not available for WYSIWYG, I need a two column view. How do I do this. I know I need to edit the *_view.php. But how?
   
2. This template needs headings after a certain amount of fields. Can this be put in as "blank" entries in Edit SQL Query that shows Information that doesn't come from the database - This heading must be different color as well, f possible)
   Eg.
   **** Personal Info [/color][/b]
   
   Name: kkkkkk Surname: aaaaa
   
   Contact info
   
   Tel: 3548955 Postal address: PO Box. 94398483
   
   Etc.

Jane
Further implications
After adding the combined fields (only used concat(`knownname`,' ',`surname`) as `Full Name`, ) as the Table name is the same, my whole table field order was set back to the original order, and all labels the same as the table names. I'll have to redo everything from scratch as the project was saved already.
Is it because I didn't use field 1 and the table name? Lost hours.
Stephan

Stephan,
you can do it editing generated files manually.

1. to create two columns on the VIEW page you need to delete some <tr> tags in the ..._view.php file.
   
2. to add your headers locate following line in the ..._view.php file:
   

   echo "<table cellpadding=2>";
   

and add this code before it:

echo "<font color=#763512>Personal info</font>";

Please note that all changes are removed after you rebuild your pages. Therefore modify generated pages when you've completed your project.

Any help on which tr tags to remove? Ther are thousands and I need to setup this project with other usability as well, meaning that I'll have to handcode them as well????

Stephan,
you need to look at the following lines in your ..._view.php file:

See the tags to remove in bold

echo "\r\n<tr><td class=shade>".Label("Field1")." </td><td>";