Re: Retrive and update database with ASP form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: xfile (cou-cou_at_remove.nospam.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 09:05:00 +0800

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.

"xfile" <cou-cou@remove.nospam.com>
???????:u6$3OkE9EHA.3012@TK2MSFTNGP09.phx.gbl...
> Hi:
>
> I guess you are right on your (3) example. That is what I want :)
>
>
> "xfile" <cou-cou@remove.nospam.com>
> ???????:ewEuxeE9EHA.2032@tk2msftngp13.phx.gbl...
>> 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.
>>
>>
>> "Stefan B Rusynko" <sbr_enjoy@hotmail.com>
>> ???????:%233tVL998EHA.3596@TK2MSFTNGP12.phx.gbl...
>>> 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
>>>
>>> --
>>>
>>> _____________________________________________
>>> 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
>>> _____________________________________________
>>>
>>>
>>> "xfile" <cou-cou@remove.nospam.com> wrote in message
>>> news:%23d0k7v98EHA.3476@TK2MSFTNGP15.phx.gbl...
>>> | 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" <sbr_enjoy@hotmail.com>
>>> | ???????:uZ74PX98EHA.2196@TK2MSFTNGP11.phx.gbl...
>>> | > 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
>>> | > _____________________________________________
>>> | >
>>> | >
>>> | > "xfile" <cou-cou@remove.nospam.com> wrote in message
>>> | > news:ev74zy38EHA.3336@TK2MSFTNGP11.phx.gbl...
>>> | > | 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" <sbr_enjoy@hotmail.com>
>>> | > | ???????:%23VF1WWx8EHA.3828@TK2MSFTNGP09.phx.gbl...
>>> | > | > 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
>>> | > | > _____________________________________________
>>> | > | >
>>> | > | >
>>> | > | > "xfile" <cou-cou@remove.nospam.com> wrote in message
>>> | > | > news:u878OQx8EHA.3592@TK2MSFTNGP09.phx.gbl...
>>> | > | > | 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.
>>> | > | > |
>>> | > | > |
>>> | > | >
>>> | > | >
>>> | > |
>>> | > |
>>> | >
>>> | >
>>> |
>>> |
>>>
>>>
>>
>>
>
>

Quantcast