Fejl i denne kode
Jeg får denne fejlADODB.Recordset fejl '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/community/change.asp, linje 8
<%
' åbner databasen
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=guf4you;USER=root;PASSWORD=;OPTION=3;"
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "Select * From community"
rs.open sql, conn, 1, 1
' udskifter felternes oplysninger
if Request.ServerVariables("REQUEST_METHOD") = "POST" then
rs.update
rs("brugernavn") = Request.form("brugernavn")
rs("køn") = Request.form("kon")
rs("kode") = Request.form("password")
rs("fuldtnavn") = Request.form("navn")
rs("fodselsdagdag") = Request("År") & "/" & Request("Måned") & "/" & Request("Dag")
rs("email") = Request.form("email")
rs("msn") = Request.form("msn")
rs("vistnavn") = Request.form("vistnavn")
rs("landsdel") = Request.form("landsdel")
rs.update
Response.Write("<br><center>Din profil er nu blevet opdateret</FONT></center>")
end if
%>
</font>
<form method=post action=loggetind.asp>
<table width="99%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="skrift" width="140"><font size="1" face="Verdana">Brugernavn:
</font></td>
<td width="259"> <font face="Verdana" size="1">
<input type="text" value="<%=RS("brugernavn")%>" name="brugernavn" class="bottom" disabled size="21">
</font>
</td>
</tr>
<tr>
<td class="skrift" width="140"><font size="1" face="Verdana">Password:
</font></td>
<td width="259"> <font face="Verdana" size="1">
<input type="text" value="<%=RS("kode")%>" name="password" class="bottom" size="21">
</font>
</td>
</tr>
<tr>
<td class="skrift" width="140"><font size="1" face="Verdana">Fulde navn:
</font></td>
<td width="259"> <font face="Verdana" size="1">
<input type="text" value="<%=RS("navn")%>" name="navn" class="bottom" size="21">
</font>
</td>
</tr>
<tr>
<td height="24" class="skrift">Vist navn:</td>
<td height="24" class="skrift"><font face="Verdana" size="1">
<input type="text" value="<%=RS("vistnavn")%>" name="vistnavn" class="bottom" size="21"></font></td>
</tr>
<tr>
<td class="skrift" width="140">
<font face="Verdana" size="1">Fødselsdagdag: </font></td>
<td width="259">
<font size="1" face="Verdana"><select size="1" name="År">
<option value="<%=rs("fodselsdagdag") = Request("År")%>"><%=rs("fodselsdagdag") = Request("År")%>
</option>
<option>1960</option>
<option>1961</option>
<option>1962</option>
<option>1963</option>
<option>1964</option>
<option>1965</option>
<option>1966</option>
<option>1967</option>
<option>1968</option>
<option>1969</option>
<option>1970</option>
<option>1971</option>
<option>1972</option>
<option>1973</option>
<option>1974</option>
<option>1975</option>
<option>1976</option>
<option>1977</option>
<option>1978</option>
<option>1980</option>
<option>1981</option>
<option>1982</option>
<option>1983</option>
<option>1984</option>
<option>1985</option>
<option>1986</option>
<option>1987</option>
<option>1988</option>
<option>1989</option>
<option>1990</option>
<option>1991</option>
<option>1992</option>
<option>1993</option>
<option>1994</option>
<option>1995</option>
<option>1996</option>
<option>1997</option>
<option>1998</option>
<option>1999</option>
<option>2000</option>
</select><select size="1" name="Måned">
<option value="<%=rs("fodselsdagdag") = Request("måned")%>"><%=rs("fodselsdagdag") = Request("måned")%>
</option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select><select size="1" name="Dag">
<option value="<%=rs("fodselsdagdag") = Request("dag")%>"><%=rs("fodselsdagdag") = Request("dag")%>
</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select> </font>
</td>
</tr>
<tr>
<td valign="top" class="skrift" width="140">
<font face="Verdana" size="1">Køn:</font></td>
<td width="259"> <font face="Verdana" size="1"> <select name="kon" class="bottom" size="1">
<option value="<%=RS("kon")%>"><%=RS("kon")%></option>
<option value="Mand">Mand</option>
<option value="Kvinde">Kvinde</option>
</select></font></td>
</tr>
<tr>
<td class="skrift" width="140"><font size="1" face="Verdana">E-mail:
</font></td>
<td width="259"> <font face="Verdana" size="1">
<input type="text" value="<%=RS("email")%>" name="email" class="bottom" size="22">
</font>
</td>
</tr>
<tr>
<td class="skrift"><font face="Verdana" size="1">MSN: </font></td>
<td> <font face="Verdana" size="1">
<input type="text" value="<%=RS("msn")%>" maxlength="15" name="icq" class="bottom" size="22" >
</font>
</td>
</tr>
<tr>
<td width="140" valign="top" class="skrift">
<font face="Verdana" size="1">Landsdel:</font></td>
<td> <font size="1" face="Verdana"> <select size="1" name="landsdel" tabindex="10">
<option value="<%=RS("email")%>"><%=RS("email")%></option>
<option selected>Ikke angivet</option>
<option>Bornholm</option>
<option>Fyn</option>
<option>Færøerne</option>
<option>Grønland</option>
<option>Lolland/Falster</option>
<option>Midtjylland</option>
<option>Nordjylland</option>
<option>Sjælland</option>
<option>Sønderjylland</option>
<option>Udlandet</option>
<option>Andet sted</option>
</select>
</font>
</td>
</tr>
<tr>
<td colspan="2">
<p align="center"><font face="Verdana" size="1">
<input type=submit value=opdater name="Submit" class="bottom"></font></td>
