在ASP中判断SQL语句是否执行成功

在ASP中判断SQL语句是否执行成功 
 

--------------------------------------------------------------------------------

www.Gaomingnet.com    2005 - 12 - 4     高铭智能建站系统 
 

利用err对象: 

　 　 sql = " insert into table(f1,f2) values('v1','v2') "
　 　 conn.execute sql
　 　  if  err.number <> 0   then  
　 　 　 　 response.write  " 出错了： " &  err.description err.clear
　 　  else  
　 　 　 　 response.write  " OK "
　 　  end   if
 
 
 

 
<script type="text/javascript"> google_ad_client = "pub-8527320164371593"; google_ad_width = 728; google_ad_height = 90; google_ad_format = "728x90_as"; google_ad_type = "text_image"; //2006-11-09: asp.net google_ad_channel = "8786117784"; google_language = 'en'; </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>