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)
 Detecting Null value in a field and displaying nothing

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-17 : 17:48:10
Steve writes "I am trying to retrieve info from a table onto an asp page. The page is an article. I want the first four paragraphs (fields p1-p4 in a table) to be displayed only. Then, from a hyperlink on that page I want to call the next 4 paragraphs to be displayed on the same asp page, and so on until the article has ended.

However, all articles have a different number of paragraphs. How can I check if there are no more paragraphs?

I'm using SQL Server 7 on Windows NT.

Many thanks"
   

- Advertisement -