| Jennifer 2004-03-01, 5:35 pm |
| Hi-
I am at a really confusing point in my CMS mission (ours
is essentially a newspaper site). I need to populate my
index page with a table listing a headline, url and short
story summary.
My question, is where should I begin in using the CMS
PAPI. I feel so lost. I assumed a datalist would be the
best way to go with this, but I keep running in to rather
large brick walls.
Any suggestions from the group- Perhaps a quick jumping
off point? The English MCMS 2002: A Complete Guide is
absolutely no help at this moment.
Right now, in good old (though messy), dear ASP it looks
like this:
<%
strSQL = "select story.id, story.premium, directory,
headline, subheading, image, shortDesc, dateEntered from
story inner join category on story.category=category.id
where category.category='Top Stories' order by dateEntered
desc, story.id desc"
'response.write "<font color=white>" & strSQL
set rs = Conn.Execute(strSQL)
If Not rs.EOF Then
nOrder = 1
While Not rs.EOF and int(nOrder)<=11
id = rs("id")
premium = rs("premium")
directory = rs("directory")
headline = rs("headline")
subheading = rs("subheading")
image = rs("image")
shortDesc = rs("shortDesc")
'response.write "SHORT DESC=" & rs
("shortDesc")
dateEntered = rs("dateEntered")
'Lock image for premium content - JCM
'<img src="/images/story/ttprm2.gif" alt="premium
content" border="0" align="bottom">
If nOrder = "1" Then
If trim(image) <> "" Then%><IMG
SRC="/images/story/<% = image%>" VSPACE=4 ALT="<% =
headline%>"><BR><% End If %>
<FONT SIZE=3 FACE="Arial"><B><A
HREF="http://www.ttnews.com/members/<% = directory%>/<% =
CreateLink(id) %>"><% = headline%></A></B></FONT><BR>
<% If subheading <> "" Then%><I><%
= subheading%></I><% End If %>
<% Else %>
<FONT SIZE=3
FACE="Arial"><B><A HREF="/members/<% = directory%>/<% =
CreateLink(id) %>"><% = headline%></A><!--<font
color="#CC0000">**</font> --></B></FONT><BR>
<% End If %>
<FONT SIZE=2 FACE="Arial">
<% = shortDesc %>
</FONT>
<DIV ALIGN=RIGHT><FONT SIZE=1
FACE="Arial"></FONT></DIV>
<hr size=1 NOSHADE>
<%
nOrder = nOrder + 1
rs.MoveNext
Wend
%>
Thanks! Jennifer
|