-----Original Message-----

From: Sylvester [mailto:sylvester@e...]

Sent: 16 June 2000 11:08

Subject: 





Hi there, 



I am working on an ASP file in which i want to use an sql statement. I've 

got a userstable in which you can click a user. If you do so you will be 

forwarded to a field with that users properties. Now I want to make a page 

with which i can edit those properties and thus edit my usersdatabase. Can 

you tell me if there are any standard codes for doing such things ?

 



Greetings.





S.T.M. Danckaarts



( E-stores, Holland ) 

On page1.asp



a) Create a recordset with the user's details.

b) Create a HTML form with textfields, checkboxes etc and set the values to

the values for that user in the database, eg:



Username: <input type="text" name="t1" value="<% =objRS("Username")%>"><br>



Submit the form to page2.asp



On page2.asp take the values of the Request.Form collection and use an SQL

query, stored procedure or ADO Recordset object to put the values back into

the database.



HTH



Cheers

Ken





> -----Original Message-----

> From: Sylvester 

> Sent: 16 June 2000 11:08

> Subject:

>

>

> Hi there,

>

> I am working on an ASP file in which i want to use an sql statement. I've

> got a userstable in which you can click a user. If you do so you will be

> forwarded to a field with that users properties. Now I want to make a page

> with which i can edit those properties and thus edit my usersdatabase. Can

> you tell me if there are any standard codes for doing such things ?

>

>

> Greetings.

>

>

> S.T.M. Danckaarts