Database results

[pancake]

Dear All,

I have a web page that outputs using a database results region something like this

orange
blue
green
yellow

then I have another database results region beneath that that does something similar

purple
brown
white
black

How do I get the results to display like this instead ?
(i.e. Horizontally instead of vertically)

orange blue green yellow
purple brown white black

Thanks

 

[Cirrus9]

One way is to create a table and have the results display in a each cell by having your response.write embedded in each <td> </td> tag. You can have the code loop the <TD> so that it can dynamically create the correct number of tags according to your results.

 

[pancake]

Not so sure about this, I am using a FP database results region and creating a table seems to just add another cell to the right hand side of the table and results when I edit the html. Can't seem to find a way of changing the Webbot to display horizontally.

Should I be using some other method of displaying the database results than database results region?

Not as easy as I thought !

 

[Kdogg]

Question When you the database Results Wizard to create your output in Step 4 of 5 it prompts you for how you want you data displayed. It sounds like your looking for the &quot;Table - one record per row &quot; option . Is this correct?

 

[pancake]

I am using the one record per row, the colour field returns the four records as below

orange
blue
green
yellow

Then another query returns another set of results from the field colour

purple
brown
white
black

I could really do with one row per set of database results

Thanks

 

[Kdogg]

You know I've had problem's with multiple Query Results. I Can only get results from one usually the first. I think there is a problem the bot in Front Page. It's supposed to accept multiples.I don't see anything on Knowledge Base either

 

[SirLars]

ok, i think i see it...

when you are doing your database results do NOT use a table...

in the first dropdown menu choose
&quot;List-one field per item&quot;
uncheck the boxes for &quot;add labels for all field values&quot;
and &quot;Place horizontal separator between records&quot;

the second dropdown menu choose &quot;line breaks&quot;

like this.. it will display your results

blue
red
purple
orange etc...

now go into HTML view and find the database results section

remove the <p> and </p>(paragraph) tags around the grey text
** important ** do not change/edit the grey text as that will alter your database results.. you just want to edit the formatting of your database results...

if you remove the <p> and </p> (paragraph) tags and replace the <p> with a hyphen - the text will come out like this
-blue -red -purple -orange

hope this helps..

Lars

 

[artdirectoreric]

Don't forget, you can format and rearrange your results area just like any other section of your page, including text formatting, splitting and merging cells, etc.