Show database results horizontally

[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

 

[Andrew Murray]

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.

 

[Masood]

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

 

[Trevor Lawrence]

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

 

[Andrew Murray]

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.

 

[Kathleen Anderson]

Masood:

Take at look at http://www.spiderwebwoman.com/thingumajig/multi.htm I
think it might be what you're looking for.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others