Variable Help (I think - App Newbie)

[ChrisFelder]

This is probably very simple but I've spent hours trying to make it work and so
far no luck.

I have a form page that submits to a database (that part works fine). When the
user submits the data, I want that data to display on the next page (Page Two)
that loads, in a sort of summary page that shows the data entered from the form
(Page One).

So far everything works (the form is writing to the database correctly),
except the summary page (Page Two) displays the data found in the first record
of the database, and NOT the record that was just entered. I think I need to
somehow 'bind' the two pages together with a variable so that Page Two
recognizes the data from the form submitted on Page One? By the way, I'm using
ASP and mySQL.

Here are the two pages:
[url]http://www.spring-hill-place.com/agent/NewContract.asp[/url] - submits to:
[url]http://www.spring-hill-place.com/agent/PrintView.asp[/url]

I appreciate any help anyone can offer.

[Zachariah Crow]

Hi Chris. There are a number of ways to do this. I've taken the easy road
myself and just purchased an extension that does what you are asking. It can
be found here: [url]http://www.tom-muck.com/extensions/help/insertretrieve/[/url]

If you want to figure it out other ways, do a web search for "retrieve
record ID after insert" and there will be a number of matches for you to
look through.



"ChrisFelder" <cf@chrisfelder.com> wrote in message
news:d5qobo$6jp$1@forums.macromedia.com...

> This is probably very simple but I've spent hours trying to make it work
> and so
> far no luck.
>
> I have a form page that submits to a database (that part works fine). When
> the
> user submits the data, I want that data to display on the next page (Page
> Two)
> that loads, in a sort of summary page that shows the data entered from the
> form
> (Page One).
>
> So far everything works (the form is writing to the database correctly),
> except the summary page (Page Two) displays the data found in the first
> record
> of the database, and NOT the record that was just entered. I think I need
> to
> somehow 'bind' the two pages together with a variable so that Page Two
> recognizes the data from the form submitted on Page One? By the way, I'm
> using
> ASP and mySQL.
>
> Here are the two pages:
> [url]http://www.spring-hill-place.com/agent/NewContract.asp[/url] - submits to:
> [url]http://www.spring-hill-place.com/agent/PrintView.asp[/url]
>
> I appreciate any help anyone can offer.
>

[ChrisFelder]

Thank you; I posted this in another forum and got my answer - I just needed to
sort the records in decending order of the time sumitted. Then it pulls the
most recent one automatically. I'm using the time the record is submitted as
the primary index (including minutes and seconds) so the likelihood that two
simultaneously submit records at the same second is very unlikely. There aren't
many people using this application at the same time.

Thanks for the reply.