ASP 쿼리문 실행시 결과값 받아오기

sql = "insert into XXXXX ............"
on error resume next
con.execute(sql)
           
if Err.Number <> 0 then
   orderOk = "FALSE"
   Err.Clear
else
   orderOK = "TRUE"
end if
on error goto 0

================================================================================

sql = "insert into XXXXX ............"
con.execute(sql), Result
           
if Result = 1 then
   orderOK = True;

else
   orderOK = False;

end if