Show database results horizontally

  • Thread starter Thread starter Masood
  • Start date Start date
M

Masood

How can I show database results in an ASP page horizontally.
Results shows as:
1
2
3
but I want them to show:
1 2 3 4

Thank you
 
I assume you're using the FP DB wizard for this. In the last (or second to
last) screen of the wizard there is a few (limited) choices about how to
layout out the results, you can choose the horizontal table layout format.

The vertical layout might be the default, but it can be changed. I no
longer use FP so I can't remember exactly how its done.
 
Thank you for quick response but there is no option for horizontal table
format.
I thought there may be a code that I could add to convert the vertical
listing to horizontal.

Thanks
 
Masood,

I have not used DB Wizard, and have written only a little ASP

But the display must be controlled by the HTML code

For example, the following code will display "name" "comments" and
Timestamp" vertically (in separate rows)
<table>
<tr><td><%=FP_FieldVal(fp_rs,"name")%></td></tr>
<tr><td><%=FP_FieldVal(fp_rs,"comments")%></td></tr>
<tr><td><%=FP_FieldVal(fp_rs,"Timestamp")%></td></tr>
</table>

The following code will display them horizontally (in adjacent columns)
<table>
<tr>
<td><%=FP_FieldVal(fp_rs,"name")%></td>
<td><%=FP_FieldVal(fp_rs,"comments")%></td>
<td><%=FP_FieldVal(fp_rs,"Timestamp")%></td>
</tr>
</table>

You can edit the HTML code using the HTML or Code tab
 
Masood,

I'm sure there is a way to do it through the DB wizard; I found this
tutorial through Google, it has screen shots of each step through the
database results wizard:

http://www.frontpagemagic.com/DRW/Format/DynamicSorting/Index.asp

If you follow this and redo the wizard for your page, take note of Step 4 of
5 - it allows for different layouts; if that's not the solution you're
after, I'm not sure how else it can be done other than with custom ASP
coding.
 
Back
Top