Try:



if rs.eof then

  response.write("error:no such record")

  else



  rs.Edit

  rs("clientConn") =  client

  rs("construction") =  constr

  rs("consultation") =  consul



  rs.Update

   end if





Another way to do this is:



  sql = "update survey set " & _

        "clientconn   = '" & client & "', " & _

        "construction = '" & constr & "', " & _

        "consultation = '" & consul & "' " & _

        "where uid    = " & uid & " " & _

        "and   email  = '" & mail & "' "



  con.execute sql





Regards

/Pelle

www.pellesoft.nu