Here is some of my code:
<%@ LANGUAGE = "VBSCRIPT" %>
<%
On Error Resume Next
p_mese = Request.Form("p_mese")
.
.'Here coming others Request.Form
.
%>
<% 'Here I am setting the DB connection
Dim outpostDB
Dim......
Dim .......
%>
<%
set outpostDB = Server.CreateObject("ADOBEDB.Connection")
....
%>
< if Err.number <> 0 then %>
<% set newfindSet = outpostDB.Execute("select * from news.....")
Do While Not newfindSet.EOF
%>
<%= newfindSet("new:title") %>
<%
newfindSet.MoveNext
Loop
%>
<%
newfindSet.Close
set newfindSet = Nothing
outpostDB.Close
set outpostDB = Nothing
%>
<% else %>
Sorry!!
<% end if %>
Hope I've been clear enough for you to understand.
I do believe that I am writing the if statement in the wrong place.
Thanks for your help
Valter
------------------------ 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/