Support forums - Re: Updating database pages (and not adding a new record)

Support forums » Products » Cute Editor for ASP » Re: Updating database pages (and not adding a new record)

Re: Updating database pages (and not adding a new record)

10-19-2004, 2:30 PM

Adam
Joined on 09-23-2003
Aurora, ON
Posts 18,678

Re: Updating database pages (and not adding a new record)

Reply Quote

bnmiros,

Here is the Code:

ID = Request("ID")

If ID <> "" then

sql="select TitleField,MessageField from test where id="&CInt(ID)&""
set rs=server.createobject("adodb.recordset")

    rs.open sql,conn,3,3

    rs("TitleField") = TitleField
    rs("MessageField") = MessageField
    rs.update
    rs.Close

Set rs = nothing

End If

Here are a few good ASP sites:

ASP101 - http://www.asp101.com

4GuysFromRolla - http://www.4guysfromrolla.com

Microsoft VBScript Language Reference - http://msdn.microsoft.com/scripting/default.htm?/scripting/VBScript/doc/vb
scripttoc.htm

Best regards

asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
asp wysiwyg html editor: http://cutesoft.net/ASP
asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
Live Support: http://cutesoft.net/live-support/default.aspx

View Complete Thread