I am looking for help on creating an edit screen to input...

[Flapman]

Hi,

I need help creating an edit screen. I have a page that displays the contents of my Database but would like to be able to edit a dtatbase record from the same screen. How can I do that?

 

[motte]

If you can get the stuff out of the database to display on a page, you are just about there...in stead of just displaying to a page, write it into a form...suppose a record has fields f1, f2, and f3...you get those fields for a record...

in the form you can do this:
<form action=&quot;somePostPage.asp&quot; method=post>
<input type=text name=f1field value='<% = ors(&quot;f1&quot%>'>
<input type=text name=f2field value='<% = ors(&quot;f2&quot%>'>
<textarea name=f3field><% = ors(&quot;f3&quot%></textarea>
<input type=submit value=&quot;Click&quot;>
</form>

This will then, after submitting go to another page. On that second page, do your update for the fields to the database...That's all you need to do. Pay special attention to how the textarea is set up. There is no value attribute, and I write the data to be in between the open and closing textarea tags.

hope this gives you what you need.

Mike

 

[Flapman]

Since I created the page automatically in Frontpage I am absolutely clueless to how it works. I'm just learning. Would someone be willing to walk me through the process of creating an edit page? I need to edit a person's passwords, user names and level number. I'd like to be able to do it while I view the contacts' information. Kind of like viewing and updating all at once.

 

[Flapman]

I forgot, what is &quot;ors&quot; in the input lies in the example?

Flapman