Re: How to insert a banner between news?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 10/03/04 

Date: Sun, 3 Oct 2004 20:31:04 +0100

Hi

If this is actually a SQL Server problem then you should post the DDL and
example data such as http://sqlxml.org/faqs.aspx?faq=10
http://sqlxml.org/faqs.aspx?faq=29 and code.

This does seem to be a programming issue, but use of the case statement may
be possible to determine if the banner is to be present and/or you can
construct your HTML within the SQL statement.

John

"Ragnar Heil" <r@gnar.de> wrote in message
news:Xns9577A45CD994Argnarde@130.133.1.4...
>
> I get a news-list with 4 items back from a SQL-query. That already works
> fine.
>
> Now I want to insert a banner after the 2nd news. Let's keep it simple,
> if blnBanner = true then
> <img src....>
> end if
>
> SQLQuery: "SET ROWCOUNT 4 SELECT COUNT(*) FROM mytable"
>
> how can I do it?