DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: ASP - data review BEFORE posting to database

  1. #1
    Tracie Guest

    ASP - data review BEFORE posting to database


    Hi All
    Am a newbie to ASP... I have built a form and the data submits to my Access
    2000 database fine. However, my users want to view (preview) the data BEFORE
    it gets submitted to the database. I have built another form that submits
    the data to an html page for review... but I can't figure out how to get
    the data from the second page (it is no longer in fields) to the database?

    What am I missing, this must be fairly easy to do? Enter data in a form,
    review the data and if correct, submit to database?

    Please help... trying to go live with this application in three weeks and
    I would like to have some hair left to pull out on the next application ;
    )
    Thanks in advance for your help... please be pretty specific, I am new as
    this ASP stuff.... Tracie

  2. #2
    John Cantley Guest

    Re: ASP - data review BEFORE posting to database

    do a

    dim objItem
    For each objItem in Request.Form
    Response.Write "<input type="hidden" name=....
    next

    when you are coming into your review page. This will then give you all your
    form variables.

    John


    "Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
    news:39ff0c4a$1@news.devx.com...
    >
    > Hi All
    > Am a newbie to ASP... I have built a form and the data submits to my

    Access
    > 2000 database fine. However, my users want to view (preview) the data

    BEFORE
    > it gets submitted to the database. I have built another form that submits
    > the data to an html page for review... but I can't figure out how to get
    > the data from the second page (it is no longer in fields) to the database?
    >
    > What am I missing, this must be fairly easy to do? Enter data in a form,
    > review the data and if correct, submit to database?
    >
    > Please help... trying to go live with this application in three weeks and
    > I would like to have some hair left to pull out on the next application ;
    > )
    > Thanks in advance for your help... please be pretty specific, I am new as
    > this ASP stuff.... Tracie




  3. #3
    Olaf Guest

    Re: ASP - data review BEFORE posting to database


    Tracie,

    Johns' solution would work if your review page would be another ASP page.
    But since you mentioned that you will be using HTML, DHTML would be another
    solution.

    Olaf

    "John Cantley" <jcstrider@hotmail.com> wrote:
    >do a
    >
    >dim objItem
    >For each objItem in Request.Form
    > Response.Write "<input type="hidden" name=....
    >next
    >
    >when you are coming into your review page. This will then give you all your
    >form variables.
    >
    >John
    >
    >
    >"Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
    >news:39ff0c4a$1@news.devx.com...
    >>
    >> Hi All
    >> Am a newbie to ASP... I have built a form and the data submits to my

    >Access
    >> 2000 database fine. However, my users want to view (preview) the data

    >BEFORE
    >> it gets submitted to the database. I have built another form that submits
    >> the data to an html page for review... but I can't figure out how to get
    >> the data from the second page (it is no longer in fields) to the database?
    >>
    >> What am I missing, this must be fairly easy to do? Enter data in a form,
    >> review the data and if correct, submit to database?
    >>
    >> Please help... trying to go live with this application in three weeks

    and
    >> I would like to have some hair left to pull out on the next application

    ;
    >> )
    >> Thanks in advance for your help... please be pretty specific, I am new

    as
    >> this ASP stuff.... Tracie

    >
    >



  4. #4
    Tracie Guest

    Re: ASP - data review BEFORE posting to database


    John
    T H A N K Y O U ! ! !
    Took me a while to figure out exactly where the input type had to go... but
    I've tested it and it works beautifully!!!
    I have spent so much time trying to work this out and you had the answer
    right away! I can't tell you how much I appreciate your help!!
    Again, THANK YOU!!
    Tracie




    "John Cantley" <jcstrider@hotmail.com> wrote:
    >do a
    >
    >dim objItem
    >For each objItem in Request.Form
    > Response.Write "<input type="hidden" name=....
    >next
    >
    >when you are coming into your review page. This will then give you all your
    >form variables.
    >
    >John
    >
    >
    >"Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
    >news:39ff0c4a$1@news.devx.com...
    >>
    >> Hi All
    >> Am a newbie to ASP... I have built a form and the data submits to my

    >Access
    >> 2000 database fine. However, my users want to view (preview) the data

    >BEFORE
    >> it gets submitted to the database. I have built another form that submits
    >> the data to an html page for review... but I can't figure out how to get
    >> the data from the second page (it is no longer in fields) to the database?
    >>
    >> What am I missing, this must be fairly easy to do? Enter data in a form,
    >> review the data and if correct, submit to database?
    >>
    >> Please help... trying to go live with this application in three weeks

    and
    >> I would like to have some hair left to pull out on the next application

    ;
    >> )
    >> Thanks in advance for your help... please be pretty specific, I am new

    as
    >> this ASP stuff.... Tracie

    >
    >



  5. #5
    Alexander Prokopyev Guest

    Re: ASP - data review BEFORE posting to database

    Hello,

    Other solution is to use an array saved in Session variable.
    like:

    dim F, Dict()
    redim Dict(Request.Form.Count-1,1)
    dim I: I=0
    for each F in Request.Form
    Dict(I,0)=F
    Dict(I,1)=Request.Form(F)
    I=I+1
    next
    Session("FormData")=Dict

    Alexander Prokopyev.
    MVP for ASP
    www.brainbench.com

    "Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
    news:39ff0c4a$1@news.devx.com...
    >
    > Hi All
    > Am a newbie to ASP... I have built a form and the data submits to my

    Access
    > 2000 database fine. However, my users want to view (preview) the data

    BEFORE
    > it gets submitted to the database. I have built another form that submits
    > the data to an html page for review... but I can't figure out how to get
    > the data from the second page (it is no longer in fields) to the database?
    >
    > What am I missing, this must be fairly easy to do? Enter data in a form,
    > review the data and if correct, submit to database?
    >
    > Please help... trying to go live with this application in three weeks and
    > I would like to have some hair left to pull out on the next application ;
    > )
    > Thanks in advance for your help... please be pretty specific, I am new as
    > this ASP stuff.... Tracie




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center