Updating

Jack Michaelson's picture

He has: 1,733 posts

Joined: Dec 1999

I'm working on an Intranet and I've got the following problem:

I want to create a page where users can update databasefields.

First I retrieve the selected record and place it into <input type> in an HTML-table. That's no problem at all.
But..
If a users changes the value of an <input type> and presses the 'Update'-button, I want the dbfield to be changed. This is the point where I got the troubles.
I tried the following:
<form action="thispage.asp">
...

<td>
<input type="text" name="idno" value="<%=rs.fields("id")%>">
</td>
...
'---here comes the trouble part---
if Len(request.form("idno")<>0 then
rs.fields("id")=request.form("idno")
rs.update
</form>
This is not working..
Who tells me what I'm doing wrong??

------------------
Jack Michaelson
[email protected]
! Click here for my profile !

Shakespeare: onclick || !(onclick)