Hi Valter, Looking at your code, should the "Sorry!" be output when there's an error? At the moment it'll be output when there isn't an error. You have what appears to be the code to be run when there's no error in the "if err.number <> 0" condition, which is when there's been an error. Dan www.diado.com
-----Original Message----- From: Valter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 16:34 To: [EMAIL PROTECTED] Subject: [AspClassicAnyQuestionIsOk] Re: Another question.. 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 <http://us.ard.yahoo.com/SIG=129o27a8p/M=296572.5305651.6444487.3001176/D=groups/S=1705006764:HM/EXP=1094571254/A=2343726/R=0/SIG=12ieefsmv/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1094484854588799> <http://us.ard.yahoo.com/SIG=129o27a8p/M=296572.5305651.6444487.3001176/D=groups/S=1705006764:HM/EXP=1094571254/A=2343726/R=1/SIG=12ieefsmv/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1094484854588799> Get unlimited calls to U.S./Canada <http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1094484854588799> <http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=groups/S=:HM/A=2343726/rand=778277585> _____ 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] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [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/
