Retrive and update database with ASP form

[xfile]

Hi:

Sorry to bother again, and this is my new problem, and hope someone can
point me to where I can find more accurate sources.

I try to come up an ASP form for registered user to modify their
registration information.

I have done many researches about how to retrieve database information and
update them, so I guess this part is ok although I have not tested it yet.

But what I wish to have the data displayed as the format of the initial
registration form which contains some pull-down manus for their selections.

Most of articles that I have read is to display data is a table rather than
using the original form format.

The wishful thinking is, that the user can view their data (as the current
selection) of the form, and then make any necessary changes (either by
filling out new texts, such as e-mail address or company name) and/or select
a new option (such as their industry). After everything is being confirmed,
the new data will be inserted back to the database for update.

So, can anyone point me where might have such reference articles or samples?

Before coming here, I have spent many hours on search Google and MS, but as
indicated before, I could not find anything that is similar to what I wish
to have - for the data retrieving and display part, in particular.

By the way, is that possible with ASP?

Thanks so much in advance.

 

[Stefan B Rusynko]

Take a look at the edit part of
http://www.asp101.com/samples/db_edit.asp




| Hi:
|
| Sorry to bother again, and this is my new problem, and hope someone can
| point me to where I can find more accurate sources.
|
| I try to come up an ASP form for registered user to modify their
| registration information.
|
| I have done many researches about how to retrieve database information and
| update them, so I guess this part is ok although I have not tested it yet.
|
| But what I wish to have the data displayed as the format of the initial
| registration form which contains some pull-down manus for their selections.
|
| Most of articles that I have read is to display data is a table rather than
| using the original form format.
|
| The wishful thinking is, that the user can view their data (as the current
| selection) of the form, and then make any necessary changes (either by
| filling out new texts, such as e-mail address or company name) and/or select
| a new option (such as their industry). After everything is being confirmed,
| the new data will be inserted back to the database for update.
|
| So, can anyone point me where might have such reference articles or samples?
|
| Before coming here, I have spent many hours on search Google and MS, but as
| indicated before, I could not find anything that is similar to what I wish
| to have - for the data retrieving and display part, in particular.
|
| By the way, is that possible with ASP?
|
| Thanks so much in advance.
|
|

 

[xfile]

Hi:

Thanks. How interesting. I did download that particular sample during the
research, but have not studied it yet.

So that is something close to what I want?

I asked this because the data are displayed with a table not with the
pull-down or option box, so I am not sure.

Thanks again.

 

[Stefan B Rusynko]

The initial list of records to select is in table form but if you click the edit option it shows that record in a form view which is
what you wanted




| Hi:
|
| Thanks. How interesting. I did download that particular sample during the
| research, but have not studied it yet.
|
| So that is something close to what I want?
|
| I asked this because the data are displayed with a table not with the
| pull-down or option box, so I am not sure.
|
| Thanks again.
|
|
| "Stefan B Rusynko" <[email protected]>
| ???????:%[email protected]...
| > Take a look at the edit part of
| > http://www.asp101.com/samples/db_edit.asp
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | Hi:
| > |
| > | Sorry to bother again, and this is my new problem, and hope someone can
| > | point me to where I can find more accurate sources.
| > |
| > | I try to come up an ASP form for registered user to modify their
| > | registration information.
| > |
| > | I have done many researches about how to retrieve database information
| > and
| > | update them, so I guess this part is ok although I have not tested it
| > yet.
| > |
| > | But what I wish to have the data displayed as the format of the initial
| > | registration form which contains some pull-down manus for their
| > selections.
| > |
| > | Most of articles that I have read is to display data is a table rather
| > than
| > | using the original form format.
| > |
| > | The wishful thinking is, that the user can view their data (as the
| > current
| > | selection) of the form, and then make any necessary changes (either by
| > | filling out new texts, such as e-mail address or company name) and/or
| > select
| > | a new option (such as their industry). After everything is being
| > confirmed,
| > | the new data will be inserted back to the database for update.
| > |
| > | So, can anyone point me where might have such reference articles or
| > samples?
| > |
| > | Before coming here, I have spent many hours on search Google and MS, but
| > as
| > | indicated before, I could not find anything that is similar to what I
| > wish
| > | to have - for the data retrieving and display part, in particular.
| > |
| > | By the way, is that possible with ASP?
| > |
| > | Thanks so much in advance.
| > |
| > |
| >
| >
|
|

 

[xfile]

Hi:

Thanks again, and I guess you're right and I am studying it in great details
now.

But I'd like to ask a question if you don't mind to help me also.

Will it be better (for simplicity reason), that I use the following logic:

(1) User log in = ASP static page populates their current information stored
at the database

(2) User click "Edit" button, which redirect them to a new registration
page, and after they filling out the information, this registration form
post to another ASP page (called update)

(3) Update.asp then do the insert and delete

I think this will be easier at least for (1) as compared to what I wish to
accomplish and that is to come up the registration form on (2) but with
their current information as selected on the drop-down menu. And the
drop-down menu is hard coded, not in the database. This is the part that
troubles me for many days.

So if I can skip this part, by just populating their current information on
the page, and then redirect them to a new registration form (as the initial
registration), and then do the insert and delete, I think it would be
easier.

Any suggestions are deeply appreciated.

The initial list of records to select is in table form but if you click
the edit option it shows that record in a form view which is
what you wanted




| Hi:
|
| Thanks. How interesting. I did download that particular sample during
the
| research, but have not studied it yet.
|
| So that is something close to what I want?
|
| I asked this because the data are displayed with a table not with the
| pull-down or option box, so I am not sure.
|
| Thanks again.
|
|
| "Stefan B Rusynko" <[email protected]>
| ???????:%[email protected]...
| > Take a look at the edit part of
| > http://www.asp101.com/samples/db_edit.asp
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | Hi:
| > |
| > | Sorry to bother again, and this is my new problem, and hope someone
can
| > | point me to where I can find more accurate sources.
| > |
| > | I try to come up an ASP form for registered user to modify their
| > | registration information.
| > |
| > | I have done many researches about how to retrieve database
information
| > and
| > | update them, so I guess this part is ok although I have not tested
it
| > yet.
| > |
| > | But what I wish to have the data displayed as the format of the
initial
| > | registration form which contains some pull-down manus for their
| > selections.
| > |
| > | Most of articles that I have read is to display data is a table
rather
| > than
| > | using the original form format.
| > |
| > | The wishful thinking is, that the user can view their data (as the
| > current
| > | selection) of the form, and then make any necessary changes (either
by
| > | filling out new texts, such as e-mail address or company name)
and/or
| > select
| > | a new option (such as their industry). After everything is being
| > confirmed,
| > | the new data will be inserted back to the database for update.
| > |
| > | So, can anyone point me where might have such reference articles or
| > samples?
| > |
| > | Before coming here, I have spent many hours on search Google and MS,
but
| > as
| > | indicated before, I could not find anything that is similar to what
I
| > wish
| > | to have - for the data retrieving and display part, in particular.
| > |
| > | By the way, is that possible with ASP?
| > |
| > | Thanks so much in advance.
| > |
| > |
| >
| >
|
|

 

[Stefan B Rusynko]

The method you describe (1 & 2) would just be DB record fields

In 1 it would be something like a table or page layout w/ their info using the DB fields
(say <%=objRS("FirstName")%>) base on selecting their record from the DB on log in

In 2 the same existing field value would be displayed in the form field for them to edit by passing their record to the edit form
per the example
<input name="FirstName" size="25" value="<%=objRS("FirstName")%>">

Don't understand what drop down menu you are talking about
If you mean you want to display their data (1st option below) and then a dropdown for alternate data for them to use in editing form
2 make it a select
<select size="1" name="Title">
<option selected><%=objRS("Title")%></option>
<option value="Mr">Mr</option>
<option value="Mrs">Mrs</option>
</select>

And yes it is best to use a 3rd ASP only page to process the form 2
The "process" page would update the DB w/ their changes from form 2




| Hi:
|
| Thanks again, and I guess you're right and I am studying it in great details
| now.
|
| But I'd like to ask a question if you don't mind to help me also.
|
| Will it be better (for simplicity reason), that I use the following logic:
|
| (1) User log in = ASP static page populates their current information stored
| at the database
|
| (2) User click "Edit" button, which redirect them to a new registration
| page, and after they filling out the information, this registration form
| post to another ASP page (called update)
|
| (3) Update.asp then do the insert and delete
|
| I think this will be easier at least for (1) as compared to what I wish to
| accomplish and that is to come up the registration form on (2) but with
| their current information as selected on the drop-down menu. And the
| drop-down menu is hard coded, not in the database. This is the part that
| troubles me for many days.
|
| So if I can skip this part, by just populating their current information on
| the page, and then redirect them to a new registration form (as the initial
| registration), and then do the insert and delete, I think it would be
| easier.
|
| Any suggestions are deeply appreciated.
|
|
|
| "Stefan B Rusynko" <[email protected]>
| ???????:[email protected]...
| > The initial list of records to select is in table form but if you click
| > the edit option it shows that record in a form view which is
| > what you wanted
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | Hi:
| > |
| > | Thanks. How interesting. I did download that particular sample during
| > the
| > | research, but have not studied it yet.
| > |
| > | So that is something close to what I want?
| > |
| > | I asked this because the data are displayed with a table not with the
| > | pull-down or option box, so I am not sure.
| > |
| > | Thanks again.
| > |
| > |
| > | "Stefan B Rusynko" <[email protected]>
| > | ???????:%[email protected]...
| > | > Take a look at the edit part of
| > | > http://www.asp101.com/samples/db_edit.asp
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | > | > | Hi:
| > | > |
| > | > | Sorry to bother again, and this is my new problem, and hope someone
| > can
| > | > | point me to where I can find more accurate sources.
| > | > |
| > | > | I try to come up an ASP form for registered user to modify their
| > | > | registration information.
| > | > |
| > | > | I have done many researches about how to retrieve database
| > information
| > | > and
| > | > | update them, so I guess this part is ok although I have not tested
| > it
| > | > yet.
| > | > |
| > | > | But what I wish to have the data displayed as the format of the
| > initial
| > | > | registration form which contains some pull-down manus for their
| > | > selections.
| > | > |
| > | > | Most of articles that I have read is to display data is a table
| > rather
| > | > than
| > | > | using the original form format.
| > | > |
| > | > | The wishful thinking is, that the user can view their data (as the
| > | > current
| > | > | selection) of the form, and then make any necessary changes (either
| > by
| > | > | filling out new texts, such as e-mail address or company name)
| > and/or
| > | > select
| > | > | a new option (such as their industry). After everything is being
| > | > confirmed,
| > | > | the new data will be inserted back to the database for update.
| > | > |
| > | > | So, can anyone point me where might have such reference articles or
| > | > samples?
| > | > |
| > | > | Before coming here, I have spent many hours on search Google and MS,
| > but
| > | > as
| > | > | indicated before, I could not find anything that is similar to what
| > I
| > | > wish
| > | > | to have - for the data retrieving and display part, in particular.
| > | > |
| > | > | By the way, is that possible with ASP?
| > | > |
| > | > | Thanks so much in advance.
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|

 

[xfile]

Hi:

Thanks for your kind reply and tips, which I am currently testing it.

Just for clarification purpose, the drop-down menus are selections for their
industry and department, etc.

My original thought was to like this - if one has selected "automobile
industry" during the initial registration and stored at the database, and
when the person decided to modify registration information and call up
registered information, the drop-down menu will display "automobile" as
"selected" instead of "please select an industry" as the original
registration form.

I thought this would be a bit of more "user friendly" for user, since they
could just review all information previously enter and hit "confirm" or
"edit".

Since I have problem for achieving that, so that is what I meant for the
(1) - (3). All information will be displayed with a field (no drop-down
menu). In the case of the above example, i.e. automobile industry, it will
just display a field "automobile industry" and not drop-down menu with auto
industry selected.

And they can still hit "edit" and in this case, they will be redirect to a
new registration page as they used before. They would then have to do it
from the beginning to the end as the initial registration.

And after that, it will be the same as the initial registration with an
exception of an additional step for the processing page to delete their
initial records.

It's less user-friendly (my thought) but this is the best I can do within
reasonable timeframe.

Thanks again for your kind reply.

The method you describe (1 & 2) would just be DB record fields

In 1 it would be something like a table or page layout w/ their info using
the DB fields
(say <%=objRS("FirstName")%>) base on selecting their record from the DB
on log in

In 2 the same existing field value would be displayed in the form field
for them to edit by passing their record to the edit form
per the example
<input name="FirstName" size="25" value="<%=objRS("FirstName")%>">

Don't understand what drop down menu you are talking about
If you mean you want to display their data (1st option below) and then a
dropdown for alternate data for them to use in editing form
2 make it a select
<select size="1" name="Title">
<option selected><%=objRS("Title")%></option>
<option value="Mr">Mr</option>
<option value="Mrs">Mrs</option>
</select>

And yes it is best to use a 3rd ASP only page to process the form 2
The "process" page would update the DB w/ their changes from form 2




| Hi:
|
| Thanks again, and I guess you're right and I am studying it in great
details
| now.
|
| But I'd like to ask a question if you don't mind to help me also.
|
| Will it be better (for simplicity reason), that I use the following
logic:
|
| (1) User log in = ASP static page populates their current information
stored
| at the database
|
| (2) User click "Edit" button, which redirect them to a new registration
| page, and after they filling out the information, this registration form
| post to another ASP page (called update)
|
| (3) Update.asp then do the insert and delete
|
| I think this will be easier at least for (1) as compared to what I wish
to
| accomplish and that is to come up the registration form on (2) but with
| their current information as selected on the drop-down menu. And the
| drop-down menu is hard coded, not in the database. This is the part
that
| troubles me for many days.
|
| So if I can skip this part, by just populating their current information
on
| the page, and then redirect them to a new registration form (as the
initial
| registration), and then do the insert and delete, I think it would be
| easier.
|
| Any suggestions are deeply appreciated.
|
|
|
| "Stefan B Rusynko" <[email protected]>
| ???????:[email protected]...
| > The initial list of records to select is in table form but if you
click
| > the edit option it shows that record in a form view which is
| > what you wanted
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | Hi:
| > |
| > | Thanks. How interesting. I did download that particular sample
during
| > the
| > | research, but have not studied it yet.
| > |
| > | So that is something close to what I want?
| > |
| > | I asked this because the data are displayed with a table not with
the
| > | pull-down or option box, so I am not sure.
| > |
| > | Thanks again.
| > |
| > |
| > | "Stefan B Rusynko" <[email protected]>
| > | ???????:%[email protected]...
| > | > Take a look at the edit part of
| > | > http://www.asp101.com/samples/db_edit.asp
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | > | > | Hi:
| > | > |
| > | > | Sorry to bother again, and this is my new problem, and hope
someone
| > can
| > | > | point me to where I can find more accurate sources.
| > | > |
| > | > | I try to come up an ASP form for registered user to modify their
| > | > | registration information.
| > | > |
| > | > | I have done many researches about how to retrieve database
| > information
| > | > and
| > | > | update them, so I guess this part is ok although I have not
tested
| > it
| > | > yet.
| > | > |
| > | > | But what I wish to have the data displayed as the format of the
| > initial
| > | > | registration form which contains some pull-down manus for their
| > | > selections.
| > | > |
| > | > | Most of articles that I have read is to display data is a table
| > rather
| > | > than
| > | > | using the original form format.
| > | > |
| > | > | The wishful thinking is, that the user can view their data (as
the
| > | > current
| > | > | selection) of the form, and then make any necessary changes
(either
| > by
| > | > | filling out new texts, such as e-mail address or company name)
| > and/or
| > | > select
| > | > | a new option (such as their industry). After everything is
being
| > | > confirmed,
| > | > | the new data will be inserted back to the database for update.
| > | > |
| > | > | So, can anyone point me where might have such reference articles
or
| > | > samples?
| > | > |
| > | > | Before coming here, I have spent many hours on search Google and
MS,
| > but
| > | > as
| > | > | indicated before, I could not find anything that is similar to
what
| > I
| > | > wish
| > | > | to have - for the data retrieving and display part, in
particular.
| > | > |
| > | > | By the way, is that possible with ASP?
| > | > |
| > | > | Thanks so much in advance.
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|

 

[xfile]

Hi:

I guess you are right on your (3) example. That is what I want

Hi:

Thanks for your kind reply and tips, which I am currently testing it.

Just for clarification purpose, the drop-down menus are selections for
their industry and department, etc.

My original thought was to like this - if one has selected "automobile
industry" during the initial registration and stored at the database, and
when the person decided to modify registration information and call up
registered information, the drop-down menu will display "automobile" as
"selected" instead of "please select an industry" as the original
registration form.

I thought this would be a bit of more "user friendly" for user, since they
could just review all information previously enter and hit "confirm" or
"edit".

Since I have problem for achieving that, so that is what I meant for the
(1) - (3). All information will be displayed with a field (no drop-down
menu). In the case of the above example, i.e. automobile industry, it will
just display a field "automobile industry" and not drop-down menu with
auto industry selected.

And they can still hit "edit" and in this case, they will be redirect to a
new registration page as they used before. They would then have to do it
from the beginning to the end as the initial registration.

And after that, it will be the same as the initial registration with an
exception of an additional step for the processing page to delete their
initial records.

It's less user-friendly (my thought) but this is the best I can do within
reasonable timeframe.

Thanks again for your kind reply.

The method you describe (1 & 2) would just be DB record fields

In 1 it would be something like a table or page layout w/ their info
using the DB fields
(say <%=objRS("FirstName")%>) base on selecting their record from the DB
on log in

In 2 the same existing field value would be displayed in the form field
for them to edit by passing their record to the edit form
per the example
<input name="FirstName" size="25" value="<%=objRS("FirstName")%>">

Don't understand what drop down menu you are talking about
If you mean you want to display their data (1st option below) and then a
dropdown for alternate data for them to use in editing form
2 make it a select
<select size="1" name="Title">
<option selected><%=objRS("Title")%></option>
<option value="Mr">Mr</option>
<option value="Mrs">Mrs</option>
</select>

And yes it is best to use a 3rd ASP only page to process the form 2
The "process" page would update the DB w/ their changes from form 2




| Hi:
|
| Thanks again, and I guess you're right and I am studying it in great
details
| now.
|
| But I'd like to ask a question if you don't mind to help me also.
|
| Will it be better (for simplicity reason), that I use the following
logic:
|
| (1) User log in = ASP static page populates their current information
stored
| at the database
|
| (2) User click "Edit" button, which redirect them to a new registration
| page, and after they filling out the information, this registration
form
| post to another ASP page (called update)
|
| (3) Update.asp then do the insert and delete
|
| I think this will be easier at least for (1) as compared to what I wish
to
| accomplish and that is to come up the registration form on (2) but with
| their current information as selected on the drop-down menu. And the
| drop-down menu is hard coded, not in the database. This is the part
that
| troubles me for many days.
|
| So if I can skip this part, by just populating their current
information on
| the page, and then redirect them to a new registration form (as the
initial
| registration), and then do the insert and delete, I think it would be
| easier.
|
| Any suggestions are deeply appreciated.
|
|
|
| "Stefan B Rusynko" <[email protected]>
| ???????:[email protected]...
| > The initial list of records to select is in table form but if you
click
| > the edit option it shows that record in a form view which is
| > what you wanted
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | Hi:
| > |
| > | Thanks. How interesting. I did download that particular sample
during
| > the
| > | research, but have not studied it yet.
| > |
| > | So that is something close to what I want?
| > |
| > | I asked this because the data are displayed with a table not with
the
| > | pull-down or option box, so I am not sure.
| > |
| > | Thanks again.
| > |
| > |
| > | "Stefan B Rusynko" <[email protected]>
| > | ???????:%[email protected]...
| > | > Take a look at the edit part of
| > | > http://www.asp101.com/samples/db_edit.asp
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | > | > | Hi:
| > | > |
| > | > | Sorry to bother again, and this is my new problem, and hope
someone
| > can
| > | > | point me to where I can find more accurate sources.
| > | > |
| > | > | I try to come up an ASP form for registered user to modify
their
| > | > | registration information.
| > | > |
| > | > | I have done many researches about how to retrieve database
| > information
| > | > and
| > | > | update them, so I guess this part is ok although I have not
tested
| > it
| > | > yet.
| > | > |
| > | > | But what I wish to have the data displayed as the format of the
| > initial
| > | > | registration form which contains some pull-down manus for their
| > | > selections.
| > | > |
| > | > | Most of articles that I have read is to display data is a table
| > rather
| > | > than
| > | > | using the original form format.
| > | > |
| > | > | The wishful thinking is, that the user can view their data (as
the
| > | > current
| > | > | selection) of the form, and then make any necessary changes
(either
| > by
| > | > | filling out new texts, such as e-mail address or company name)
| > and/or
| > | > select
| > | > | a new option (such as their industry). After everything is
being
| > | > confirmed,
| > | > | the new data will be inserted back to the database for update.
| > | > |
| > | > | So, can anyone point me where might have such reference
articles or
| > | > samples?
| > | > |
| > | > | Before coming here, I have spent many hours on search Google
and MS,
| > but
| > | > as
| > | > | indicated before, I could not find anything that is similar to
what
| > I
| > | > wish
| > | > | to have - for the data retrieving and display part, in
particular.
| > | > |
| > | > | By the way, is that possible with ASP?
| > | > |
| > | > | Thanks so much in advance.
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|

 

[xfile]

Hi Stefan:


Thanks, and this is just an update for I have successfully retrieved data
displayed within an ASP page, and some are drop-down menus.

I am doing some modifications now, and learning how to update data back to
database with that form, which seems very difficult.

But thanks again.

Hi:

I guess you are right on your (3) example. That is what I want

Hi:

Thanks for your kind reply and tips, which I am currently testing it.

Just for clarification purpose, the drop-down menus are selections for
their industry and department, etc.

My original thought was to like this - if one has selected "automobile
industry" during the initial registration and stored at the database, and
when the person decided to modify registration information and call up
registered information, the drop-down menu will display "automobile" as
"selected" instead of "please select an industry" as the original
registration form.

I thought this would be a bit of more "user friendly" for user, since
they could just review all information previously enter and hit "confirm"
or "edit".

Since I have problem for achieving that, so that is what I meant for the
(1) - (3). All information will be displayed with a field (no drop-down
menu). In the case of the above example, i.e. automobile industry, it
will just display a field "automobile industry" and not drop-down menu
with auto industry selected.

And they can still hit "edit" and in this case, they will be redirect to
a new registration page as they used before. They would then have to do
it from the beginning to the end as the initial registration.

And after that, it will be the same as the initial registration with an
exception of an additional step for the processing page to delete their
initial records.

It's less user-friendly (my thought) but this is the best I can do within
reasonable timeframe.

Thanks again for your kind reply.

The method you describe (1 & 2) would just be DB record fields

In 1 it would be something like a table or page layout w/ their info
using the DB fields
(say <%=objRS("FirstName")%>) base on selecting their record from the DB
on log in

In 2 the same existing field value would be displayed in the form field
for them to edit by passing their record to the edit form
per the example
<input name="FirstName" size="25" value="<%=objRS("FirstName")%>">

Don't understand what drop down menu you are talking about
If you mean you want to display their data (1st option below) and then a
dropdown for alternate data for them to use in editing form
2 make it a select
<select size="1" name="Title">
<option selected><%=objRS("Title")%></option>
<option value="Mr">Mr</option>
<option value="Mrs">Mrs</option>
</select>

And yes it is best to use a 3rd ASP only page to process the form 2
The "process" page would update the DB w/ their changes from form 2




| Hi:
|
| Thanks again, and I guess you're right and I am studying it in great
details
| now.
|
| But I'd like to ask a question if you don't mind to help me also.
|
| Will it be better (for simplicity reason), that I use the following
logic:
|
| (1) User log in = ASP static page populates their current information
stored
| at the database
|
| (2) User click "Edit" button, which redirect them to a new
registration
| page, and after they filling out the information, this registration
form
| post to another ASP page (called update)
|
| (3) Update.asp then do the insert and delete
|
| I think this will be easier at least for (1) as compared to what I
wish to
| accomplish and that is to come up the registration form on (2) but
with
| their current information as selected on the drop-down menu. And the
| drop-down menu is hard coded, not in the database. This is the part
that
| troubles me for many days.
|
| So if I can skip this part, by just populating their current
information on
| the page, and then redirect them to a new registration form (as the
initial
| registration), and then do the insert and delete, I think it would be
| easier.
|
| Any suggestions are deeply appreciated.
|
|
|
| "Stefan B Rusynko" <[email protected]>
| ???????:[email protected]...
| > The initial list of records to select is in table form but if you
click
| > the edit option it shows that record in a form view which is
| > what you wanted
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | Hi:
| > |
| > | Thanks. How interesting. I did download that particular sample
during
| > the
| > | research, but have not studied it yet.
| > |
| > | So that is something close to what I want?
| > |
| > | I asked this because the data are displayed with a table not with
the
| > | pull-down or option box, so I am not sure.
| > |
| > | Thanks again.
| > |
| > |
| > | "Stefan B Rusynko" <[email protected]>
| > | ???????:%[email protected]...
| > | > Take a look at the edit part of
| > | > http://www.asp101.com/samples/db_edit.asp
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | > | > | Hi:
| > | > |
| > | > | Sorry to bother again, and this is my new problem, and hope
someone
| > can
| > | > | point me to where I can find more accurate sources.
| > | > |
| > | > | I try to come up an ASP form for registered user to modify
their
| > | > | registration information.
| > | > |
| > | > | I have done many researches about how to retrieve database
| > information
| > | > and
| > | > | update them, so I guess this part is ok although I have not
tested
| > it
| > | > yet.
| > | > |
| > | > | But what I wish to have the data displayed as the format of
the
| > initial
| > | > | registration form which contains some pull-down manus for
their
| > | > selections.
| > | > |
| > | > | Most of articles that I have read is to display data is a
table
| > rather
| > | > than
| > | > | using the original form format.
| > | > |
| > | > | The wishful thinking is, that the user can view their data (as
the
| > | > current
| > | > | selection) of the form, and then make any necessary changes
(either
| > by
| > | > | filling out new texts, such as e-mail address or company name)
| > and/or
| > | > select
| > | > | a new option (such as their industry). After everything is
being
| > | > confirmed,
| > | > | the new data will be inserted back to the database for update.
| > | > |
| > | > | So, can anyone point me where might have such reference
articles or
| > | > samples?
| > | > |
| > | > | Before coming here, I have spent many hours on search Google
and MS,
| > but
| > | > as
| > | > | indicated before, I could not find anything that is similar to
what
| > I
| > | > wish
| > | > | to have - for the data retrieving and display part, in
particular.
| > | > |
| > | > | By the way, is that possible with ASP?
| > | > |
| > | > | Thanks so much in advance.
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|