Hello
I need some help i have some code that retrive the information and display
as a link. When the link is selected the code Display more information
related with this selection, the problem begins here the information
displayed have a link too and when selected i cant display nothing.
Could you take a look to the code and help me
Thanks
Carlos
<%
u_category=request.querystring("u_category")
accessdb="canalnoticias"
cn="driver={Microsoft Access Driver (*.mdb)};"
cn=cn & "dbq=" & server.mappath(accessdb)
set rs = server.createobject("ADODB.Recordset")
' Check to see if the user had clicked on a link from the page
if u_category = "" then
sql = "select * from noticias order by TipoDocumento asc"
else
sql = "select * from noticias where TipoDocumento='" & u_category &"' order
by Titulo asc"
end if
rs.Open sql, cn
' if there is no match on category then redirct the user to the category
page
' this prevents a truncated screen or error message from appearing when
users type in the address field
if rs.eof then response.redirect request.servervariables("script_name")
response.write"<body bgcolor='#FFFFFF'>"
rs.movefirst
do while not rs.eof
TipoDocumento=rs("TipoDocumento")
' if the category is not equal to the previous category
' then output the category
' (On the first interation last_category will be null
' and cause the first category to output)
if TipoDocumento <> last_category then
%>
<br><b>
<%
' if the user has not drilled on a category then hyperlink the category
if u_category = "" then %>
<a href="<%= request.servervariables("script_name") %>?u_category=<%=
TipoDocumento %>">
<% end if %>
<%= TipoDocumento %>
<% if u_category = "" then %>
</a>
<% end if %>
</b><br>
<%
end if
%>
<% if u_category <> "" then %>
<a "<%= rs("Id") %>"><%= rs("Titulo") %></a><br><%= rs("Resumo") %>
</b>
<br>
<%
else
end if
' Places the current category value in the last_category field
' After each iteration last_category will be filled with the value
' of the category from the previous observation
last_category=TipoDocumento
rs.MoveNext
loop
' Check to see if the user had clicked on a link from the page
if u_category <> "" then
' if the user has drilled down show a link back to the category page
%>
<br><b><a href="<%= request.servervariables("script_name") %>"><--Voltar
a tras</a>
<% end if %>
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
