SQL UPDATE som bruger Forms og database...
Koden først...<!-- #INCLUDE FILE=\"SSI/PageOpen.asp\" -->
<BR>
<table border=\'1\' bordercolor=\'black\' bordercolorlight=\'black\' bordercolordark=\'black\' align=\'center\' cellpadding=\'0\' cellspacing=\'0\' width=\'40%\'>
<tr>
<td bgcolor=\'#1F487F\' ALIGN=center>
<%
Response.write \"<FONT color=\'silver\' size=\'4\'>\" & Session(\"Nickname\") & \"<FONT>\"
Response.write \"<FORM ACTION=\'Profile.asp\' METHOD=POST NAME=\'FormProfile\'>\"
Response.write \"<FONT color=silver>Password:</FONT><BR>\"
Response.write \"<INPUT TYPE=TEXT NAME=\'FormPassword\' VALUE=\" & Session(\"Password\") & \"><BR>\"
Response.write \"<FONT color=silver>Fornavn:</FONT><BR>\"
Response.write \"<INPUT TYPE=TEXT NAME=\'FormFirstname\' VALUE=\" & Session(\"Firstname\") & \"><BR>\"
Response.write \"<FONT color=silver>Efternavn:</FONT><BR>\"
Response.write \"<INPUT TYPE=TEXT NAME=\'FormLastname\' VALUE=\" & Session(\"LastName\") & \"><BR>\"
Response.write \"<FONT color=silver>E-Mail:</FONT><BR>\"
Response.write \"<INPUT TYPE=TEXT NAME=\'FormEmail\' VALUE=\" & Session(\"Email\") & \"><BR>\"
Response.write \"<FONT color=silver>ICQ:</FONT><BR>\"
Response.write \"<INPUT TYPE=TEXT NAME=\'FormICQ\' VALUE=\" & Session(\"ICQ\") & \"><BR><BR>\"
Response.write \"<INPUT TYPE=SUBMIT VALUE=\'Update\'>\"
Response.write \"</FORM>\"
Dim objComm
Dim strSQL
Dim intNoofRecords
\' Dim strConnect \'From SSI/DataStore.asp
set objComm = Server.CreateObject(\"ADODB.Command\")
strSQL = \"UPDATE dbUser SET dbLoginPassword = \" & Request.form(\"FormPassword\") & \" WHERE dbUserID LIKE \" & Session(\"ID\")
objComm.ActiveConnection = strConnect
objComm.CommandText = strSQL
objComm.CommandType = 1
objComm.Execute
set objComm = Nothing
%>
</td>
</tr>
</table>
<BR>
<!-- #INCLUDE FILE=\"SSI/PageClose.asp\" -->
------
hvis jeg fjerner Request.form (\"FormPassword\") og sætter en værdi end eks. \'hulabula\' virker det fint....
