Added: July/12/2004 at 1:23pm | IP Logged
|
|
|
Thanks for the message but it still doesn't work. I have the code set at this..
<% Dim RID RID = Request.Form("RID") sql = "UPDATE agents SET name = '" & request.form("name") & "', address = '" & request.form("address") & "', city = '" & request.form("city") & "', state = '" & request.form("state") & "', zip = '" & request.form("zip") & "', compperson = '" & request.form("compperson") & "', compemail = '" & request.form("compemail") & "', status = '" & request.form("status") & "', appdate = '" & request.form("appdate") & "', notes = '" & request.form("notes") where "&_ (ID = " & RID & ")"
MyConn.execute(sql) MyConn.Close %>
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'where'
/ge/edit.asp, line 155
|