Updating DB from form

[Fox]

My project is on MSSQL

Can someone set me on the right track.
I need to be able to allow users to update
their profile. Is there a way to display
their data in form fields, let them make
their changes and then have only the
changed fields update ? Or do I have to
work with each individual field ?

Thanks,
Fox

[Fox]

Thanks, guess I was not taking UPDATE literally.
But just to make sure I understand. When using UPDATE
the server is checking only for changed data and is not
rewriting the entire record ?

Thanks,
Fox



"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:eo#wynCYDHA.1004@TK2MSFTNGP12.phx.gbl...

> Yes, of course there is. You create a recordset of the user's data,

display

> that data in your form fields, have the form submit to a page that will

take

> those values and execute an UPDATE statement on the table using a WHERE
> clause with the userID.
>
> Ray at work
>
> "Fox" <fox @ connexions .net> wrote in message
> news:e5CMhkCYDHA.2476@tk2msftngp13.phx.gbl...

> > My project is on MSSQL
> >
> > Can someone set me on the right track.
> > I need to be able to allow users to update
> > their profile. Is there a way to display
> > their data in form fields, let them make
> > their changes and then have only the
> > changed fields update ? Or do I have to
> > work with each individual field ?
> >
> > Thanks,
> > Fox
> >
> >

>
>

[Alan]

The server wont care what's changed and what hasn't , it'll just set the
column value for each term you include in the query. However, it won't null
out (for example) column values not included in the SET clause.

The solution to your original question is just to update any column for
which a value comes through in the post from your form. It doesn't matter
whether the value has changed or not - UPDATEing a column containing an 'A'
with an 'A' will still leave an 'A'.

Cheers,

Alan

"Fox" <fox @ connexions .net> wrote in message
news:u2aKY#HYDHA.2152@TK2MSFTNGP09.phx.gbl...

> Thanks, guess I was not taking UPDATE literally.
> But just to make sure I understand. When using UPDATE
> the server is checking only for changed data and is not
> rewriting the entire record ?
>
> Thanks,
> Fox
>
>
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:eo#wynCYDHA.1004@TK2MSFTNGP12.phx.gbl...

> > Yes, of course there is. You create a recordset of the user's data,

> display

> > that data in your form fields, have the form submit to a page that will

> take

> > those values and execute an UPDATE statement on the table using a WHERE
> > clause with the userID.
> >
> > Ray at work
> >
> > "Fox" <fox @ connexions .net> wrote in message
> > news:e5CMhkCYDHA.2476@tk2msftngp13.phx.gbl...

> > > My project is on MSSQL
> > >
> > > Can someone set me on the right track.
> > > I need to be able to allow users to update
> > > their profile. Is there a way to display
> > > their data in form fields, let them make
> > > their changes and then have only the
> > > changed fields update ? Or do I have to
> > > work with each individual field ?
> > >
> > > Thanks,
> > > Fox
> > >
> > >

> >
> >

>
>