title: ASP recordset fileds are empty at second utilisation
body: <p>Does anyone know why this statement</p>
  
  <pre><code>Response.write(rs.Fields.Item("password")&amp;" ; "&amp;rs.Fields.Item("password"))
  </code></pre>
  
  <p>Do this :</p>
  
  <pre><code>myPass ; 
  </code></pre>
  
  <p>It's very strange and I'm looking for a solution since this morning. It's making me crazy because the result of this is that this codntion :</p>
  
  <pre><code>if rs("password") = rs("password") then
  </code></pre>
  
  <p>is False !</p>
  
  <p>EDIT :</p>
  
  <p>After other test, i have made an other discover :</p>
  
  <pre><code>Response.write(rs.Fields.Item("name")&amp;" ; "&amp;rs.Fields.Item("name"))
  </code></pre>
  
  <p>do :</p>
  
  <pre><code>amdin ; admin
  </code></pre>
  
  <p>And if i change "password" by his ordinal index it doing the same displays :</p>
  
  <pre><code>myPass ; 
  </code></pre>
  
  <p>.</p>
  
  <p>EDIT : the related code :</p>
  
  <pre><code>Set Conn = Server.CreateObject("ADODB.Connection")
  Conn.Open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=crm_sandbox; UID=root;PASSWORD=tahina; OPTION=3" 
  
  if Request.Form("login") &lt;&gt; "" or Request.Form("mdp") &lt;&gt; "" or Request.Form("redirect") &lt;&gt; "" then
      Response.write(Request.Form("mdp")&amp;" ; "&amp;Request.Form("login")&amp;" ; "&amp;Request.Form("redirect")&amp;"&lt;br&gt;")
      if Request.Form("login") = "" then
          rapport = "&lt;p style='color: red; font-weight: bold;'&gt;Erreur : Veuillez remplir votre nom d'utilisateur.&lt;/p&gt;"
      elseif Request.Form("mdp") = "" then
          rapport = "&lt;p style='color: red; font-weight: bold;'&gt;Erreur : Veuillez remplir votre mot de passe.&lt;/p&gt;"
      elseif Request.Form("login") &lt;&gt; "" and Request.Form("mdp") &lt;&gt; "" then
          sql = "SELECT id, mdp, nom, initiales, couleur, droit FROM connection WHERE nom='"&amp;Request.Form("login")&amp;"';"
          Set rs = Server.CreateObject("ADODB.Recordset")
          rs.open sql, conn
  
          if rs.eof then
              rapport = "&lt;p style='color: red; font-weight: bold;'&gt;Erreur : Nom d'utilisateur inconnu.&lt;/p&gt;"
          elseif rs("mdp") &lt;&gt; Request.Form("mdp") then
              rapport = "&lt;p style='color: red; font-weight: bold;'&gt;Erreur : Mot de passe incorect.&lt;/p&gt;"
          elseif Request.Form("mdp") = rs("mdp") then
              Session("util_id") = rs("id")
              Session("util_nom") = rs("nom")
              Session("util_couleur") = rs("couleur")
              Session("util_initiales") = rs("initiales")
              Session("util_droit") = rs("droit")
              Session.Timeout = 660 'On créer une session de 11 heures
              rapport = "&lt;p style='color: green; font-weight: bold;'&gt;Vous êtes à présent connecté !&lt;/p&gt;"
  
              if Request.Form("redirect") &lt;&gt; "" then
                  rapport = rapport&amp;"&lt;p&gt;Vous allez être rédirigé vers votre page dans 3 secondes&lt;/p&gt;"
              end if
          end if
      end if
  end if
  </code></pre>