how to present database data as an unordered list

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

how to present database data as an unordered list

Author

Topic

token
Posting Yak Master

133 Posts

Posted - 2005-11-23 : 18:41:41

This problem is still killing me. Can anyone PLEASE view the URL below

http://www.laptopsdirect.co.uk/Acer_Ferrari_4002WLMi_LX.FR405.070/version-1.asp

How are they able to list the features of the product with bullet-points? The data is coming from a database, but how is it stored in that database?

Finally I managed to get my page to display the data with bullet-points, but the space between each line is double spacing. The URL above presents the data with single line spacing. Any ideas of what I'm supposed to do here?

Cheers,
Token

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-11-23 : 19:19:36

It should be something like this


<ul>
 <li>stuff</li>
 <li>stuff</li>
 <li>stuff</li>
</ul>

Are you having problems with getting things to display like that in ASP.net?

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>

token
Posting Yak Master

133 Posts

Posted - 2005-11-23 : 19:29:22

Hi MichaelP,

I am using ColdFusion. My HTML code looks like this now:

<div id="prodDetailSpecs"><cfoutput query="rsProductDetail">
<ul>
<li>#rsProductDetail.Feature#</li>
</ul>
</cfoutput>
</div>

It displays all the features with their own bullet-points, but the line spacing has become like double spacing. There is at least 1 line blank space between each bullet-point. How do I remove that?

Thanks again,
Token

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-11-23 : 19:38:19

Well, I'm not sire on the exact specifics on ColdFusion, but I'm pretty sure I know what's wrong. It looks like you are creating a new unorder list for each line item.

Try this:


<div id="prodDetailSpecs">
<ul>
<cfoutput query="rsProductDetail">
<li>#rsProductDetail.Feature#</li>
</cfoutput>
</ul>
</div>

Michael

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>

DustinMichaels
Constraint Violating Yak Guru

464 Posts

Posted - 2005-11-23 : 19:51:17

They are probably using a css style to remove the space between the list items.

Try messing around with the top and bottom margin on list items in your css file. For example

ul { margin-top: 0; margin-bottom: 0; }

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-23 : 23:39:24

This is SQL Server Developer Forum
Post this question at ASP.NET Forum to get more replies

Madhivanan

Failing to plan is Planning to fail

IT1
Starting Member

5 Posts

Posted - 2005-11-24 : 11:05:56

Make sure the repeat is around a single <li>data</li> tag

<ul>
##start repeat here##
<li>stuff</li>
##move next##
##end repeat##
</ul>

should work fine

token
Posting Yak Master

133 Posts

Posted - 2005-11-25 : 12:57:21

I managed to get rid of the double spacing by setting margin and padding to zero. www.alistapart.com helped a bit. Thanks to everyone here!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources