Hi,

could someone please help us, I want to get better error messages than the standard server error I normally receive. How do i do this?

Also,

The below code is processing but with NO results. Records I select from comments are supposed to be updated to commentsA. Nothing happens. Can anyone see an issue.

cheers

 
		iMonth = cInt(Request.QueryString("month"))
		strSQL="SELECT * FROM comments where entryMonth="&iMonth
		set iRS=Server.CreateObject("ADODB.Recordset")
		iRS.Open strSQL, Conn 
	    
		if not (iRS.eof or iRS.bof) then
		iRS.MoveFirst 
		  do while NOT iRS.eof
		  
		    strSQL2 = "UPDATE commentsA SET studentName='"&iRS("studentName")&"',studenteMail='"&iRS("studenteMail")&"',portal='"&iRS("portal")&"',referal='"&iRS("referal")&"',comments='"&iRS("comments")&"',entrydate='"&iRS("entrydate")&"',entrymonth="&iRS("entrymonth")&",closed="&iRS("closed")&",reason='"&iRS("reason")&"',fixdate='"&iRS("fixdate")&"'"
			Set kuUpdate = Server.CreateObject("ADODB.Connection")
		  	kuUpdate.Open Conn
			kuUpdate.Execute strSQL	'errors here.		kuUpdate.Close
			iRS.movenext
		  loop		
		else
		  
		end if

cheers
Steve

Have you tried turning off 'Use friendly HTTP Error Messages' under Tools - Options - Advanced (in IE) ?

yes. I just get the standard error message. Tells me nothing at all.