DBRW link to frontpage form

[Ronx]

Sounds like the extensions were used to process the form data before you
added the ID bit.

I suggest you either go back to the original, learn how to program asp
pages, or pay someone to build the necessary code for you.

There are articles on http://irt.org that explain how to read in
querystrings using JavaScript, and place that value in a form field.

As it stands, if you stay on the .asp route, you need to get and validate
all the form fields, combine them in an email, and programatically send
that email. Then either display a confirmation note (on the same page) or
redirect to a confirmation page.
There are ready made asp form handlers (some free) if you search for them.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Ronx,

The page in question here, that has the form, used to work fine as far as
submitting the form and showing the confirm page.

I think the issue now is that because I added the suggested asp to the
top
of the page...

<%
ID = Request.Querystring("ID")
%>

and renamed teh [age from .htm to .asp, I face this issue.

So, that said, do I need to add asp to each input field for the form?
Or,
based upon what I just stated, do u suggest soemthing else?

Thanks. -jz

The form is set to go to book_MAIN.asp for processing.

What that processing does I have no idea since it is in asp code
blocks -
which do not download to the browser.
I would look for errors in the asp script on the page.

You can use asp to retain the value of the fields when submitted -
otherwise the form fields *will* reset.

Example:
<input name="email" value="<%=request.form("email")%>">
--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Hi, Ronx.

I have the form set to send to <%=Email%>

Also, the issue is is it set to land on a confirm page that is an htm
file
in the same directory. It used to land there, but not since my
changes.

Ideas? The form only vlaidates the fields required, then when those
are
filled in, it just clears things out and reloads the page. I would
expect
that from reset, but not submit. Thanks. -jz

:

Both submit buttons appear to work equally well. The form action is
book_MAIN.asp, which should contain code that:
1) detects whether this is a new representation of the page, or if
the
submit button was pressed
2) If the submit button was pressed, then process the form data - I
would
validate the data in this code block, just in case the user has
JavaScript
disabled which will prevent the FrontPage validation working.

I never filled in the form, so pressing either of the submit buttons
gave
me the FrontPage validation errors. Had the form been submitted then
the
page would have reloaded and your asp script would process the data.

Should the form actually submit to a different page? If so in Form
Properties change the "Send to other" value to the correct page.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Actually, just looking at the code and the image button does not
match
the
new submit button i added, but neither do work, anyhow.

Also, the submit button is pointing to the same asp because I
currently
have
it framed, so it's set to process within the sama target frame.

</table>
<p align="right"><a target="_self"
href="book_MAIN.asp">
<img border="0" src="images/btnRESET.jpg"></a>
<input border="0" src="images/btnSUBMIT.jpg" name="I1"
type="image">
<input type="submit" value="Submit" name="B1"> </p>
</form>
<p> </td>

Thanks. -jz

:

Change
ID = Request.Query.String("ID")
to
ID = Request.Querystring("ID")

Notice the removed full stop between Query and String.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Thanks, Stefan.

I finally got around to trying this out and after publishing, I
get
an
error
when I drill down through the 2nd last page, which is a name
link
leading
to
the final detail page for that person. Here is the error and by
the
way,
I
added this to the header area of the final page that displays
the
form:

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name
and Email)
' from the user contact data table using a std DB recordset
lookup
%>

I also changed out the web bot for "email" with <%email%>, but
maybe
the
header part I added was the problem, as it refers to line 10:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'Query'

/book_MAIN.asp, line 10

Any ideas? Can you tell if I did soemthing wrong?

Thanks. -jz



:

Ok
So the 1st part my 1st resposne is all you need
- you need to pass the link as a parameter to the final form as
a
std
single form page and pass the ID field value of NAME to that
form page form as a parameter

Add your link to the form form page (say called
appointment.asp)
as:
<a href="appointment.asp?ID=<%=fp_rs("ID")%>">Make
appointment</a>
- where in fp_rs("ID") above is the DBR field result record
field
for
ID
for the NAME
Then on the page used the parameter results add at the top of
teh
page

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name and Email)
' from the user contact data table using a std DB recordset
lookup
%>
Then in the form use hidden or normal text fields to prefill in
the
form
as say
<%=Name%> and %=Email%> for the form vield values





_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, sorry about that, Stefan.
|
| Here's the flow.
|
| 1. Guest clicks FIND FOOT MASSAGER link on basic html page
|
| 2. I link them to an asp result set that displays STATE only,
from
an
Access
| query between two tables. One table has the state
(location_id)
and
the
| other table has all the user contact data, linked by pri key
location_id)
|
| 3. Click the STATE link, that displays result set of users
filtered
by
state
| (location_id)
|
| 4. Click the NAME of the foot massager this drills to another
result
set,
| showing NAME detail, which is the ID col in the table.
|
| 5. So, on this final result set page, I want to link to a
form
page,
so the
| user can book a visit. My challenge is, I have a standard
booking
form, but
| each NAME or ID...you know, each user, needs to have a form
that
emails
| results to them, specifically.
|
| I have an email addess field in the db, of course, so just
wondering
if I
| can do this without any login, as this is all publicly
accessible...
|
| I hoep that helps. Thanks for taking time out.
|
| jz
|
|
| "Stefan B Rusynko" wrote:
|
| > You need to clearly explain who is doing or viewing what
when
in
your process (and what/when you are displaying from the DB)
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | I'll save this for a possible other, future need.
| > |
| > | But, for this one, the form is to book an appointment
with
that
specific
| > | person that has a details page. The details person, in
this
case,
isn't
| > | filling in a form, so I need it to be public.
| > |
| > | thx.
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > You don't need a unique form for each person
| > | > - you need the link to "their" details point to a std
form
and
pass their unique ID (from the DB) to the details form
| > | > Best done by using the DB for them to log in with
| > | > See
http://support.microsoft.com/default.aspx?scid=321439
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP -
FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!"
(-;
| > | > _____________________________________________
| > | >
| > | >
| > | > | Ok, I have a good one, here. Maybe it's possible;
maybe
not.
Make sure
| > | > | you've had your coffee or ginko drink before tackling
this
one
| > | > |
| > | > | So, I have this one form to book an appointment. I
would
like
be able to
| > | > | have each detail page for a person, which of course
is
generated using a
| > | > | unique id and results page, point to their own,
specific
appointment form.
| > | > |
| > | > | I am guessing that I would need to take my main
appointment
form and
| > | > | manually create a unique form for each person, which
I
can
do.
(If this can
| > | > | be automated, as far as the form results being
emailed
to

 

[jz]

Can I then go back to an htm extension for this form page or what are you
suggesting as "go back to orginal?"

Thanks for your other ideas, too. None work for me, which is why i am
asking about the original. I mean, i will look inot the others if original
doesn't work for me, but would like the quickest route, if possible.

Thanks. -jz

Sounds like the extensions were used to process the form data before you
added the ID bit.

I suggest you either go back to the original, learn how to program asp
pages, or pay someone to build the necessary code for you.

There are articles on http://irt.org that explain how to read in
querystrings using JavaScript, and place that value in a form field.

As it stands, if you stay on the .asp route, you need to get and validate
all the form fields, combine them in an email, and programatically send
that email. Then either display a confirmation note (on the same page) or
redirect to a confirmation page.
There are ready made asp form handlers (some free) if you search for them.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Ronx,

The page in question here, that has the form, used to work fine as far as
submitting the form and showing the confirm page.

I think the issue now is that because I added the suggested asp to the
top
of the page...

<%
ID = Request.Querystring("ID")
%>

and renamed teh [age from .htm to .asp, I face this issue.

So, that said, do I need to add asp to each input field for the form?
Or,
based upon what I just stated, do u suggest soemthing else?

Thanks. -jz

The form is set to go to book_MAIN.asp for processing.

What that processing does I have no idea since it is in asp code
blocks -
which do not download to the browser.
I would look for errors in the asp script on the page.

You can use asp to retain the value of the fields when submitted -
otherwise the form fields *will* reset.

Example:
<input name="email" value="<%=request.form("email")%>">
--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Hi, Ronx.

I have the form set to send to <%=Email%>

Also, the issue is is it set to land on a confirm page that is an htm
file
in the same directory. It used to land there, but not since my
changes.

Ideas? The form only vlaidates the fields required, then when those
are
filled in, it just clears things out and reloads the page. I would
expect
that from reset, but not submit. Thanks. -jz

:

Both submit buttons appear to work equally well. The form action is
book_MAIN.asp, which should contain code that:
1) detects whether this is a new representation of the page, or if
the
submit button was pressed
2) If the submit button was pressed, then process the form data - I
would
validate the data in this code block, just in case the user has
JavaScript
disabled which will prevent the FrontPage validation working.

I never filled in the form, so pressing either of the submit buttons
gave
me the FrontPage validation errors. Had the form been submitted then
the
page would have reloaded and your asp script would process the data.

Should the form actually submit to a different page? If so in Form
Properties change the "Send to other" value to the correct page.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Actually, just looking at the code and the image button does not
match
the
new submit button i added, but neither do work, anyhow.

Also, the submit button is pointing to the same asp because I
currently
have
it framed, so it's set to process within the sama target frame.

</table>
<p align="right"><a target="_self"
href="book_MAIN.asp">
<img border="0" src="images/btnRESET.jpg"></a>
<input border="0" src="images/btnSUBMIT.jpg" name="I1"
type="image">
<input type="submit" value="Submit" name="B1"> </p>
</form>
<p> </td>

Thanks. -jz

:

Change
ID = Request.Query.String("ID")
to
ID = Request.Querystring("ID")

Notice the removed full stop between Query and String.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Thanks, Stefan.

I finally got around to trying this out and after publishing, I
get
an
error
when I drill down through the 2nd last page, which is a name
link
leading
to
the final detail page for that person. Here is the error and by
the
way,
I
added this to the header area of the final page that displays
the
form:

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name
and Email)
' from the user contact data table using a std DB recordset
lookup
%>

I also changed out the web bot for "email" with <%email%>, but
maybe
the
header part I added was the problem, as it refers to line 10:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'Query'

/book_MAIN.asp, line 10

Any ideas? Can you tell if I did soemthing wrong?

Thanks. -jz



:

Ok
So the 1st part my 1st resposne is all you need
- you need to pass the link as a parameter to the final form as
a
std
single form page and pass the ID field value of NAME to that
form page form as a parameter

Add your link to the form form page (say called
appointment.asp)
as:
<a href="appointment.asp?ID=<%=fp_rs("ID")%>">Make
appointment</a>
- where in fp_rs("ID") above is the DBR field result record
field
for
ID
for the NAME
Then on the page used the parameter results add at the top of
teh
page

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name and Email)
' from the user contact data table using a std DB recordset
lookup
%>
Then in the form use hidden or normal text fields to prefill in
the
form
as say
<%=Name%> and %=Email%> for the form vield values





_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, sorry about that, Stefan.
|
| Here's the flow.
|
| 1. Guest clicks FIND FOOT MASSAGER link on basic html page
|
| 2. I link them to an asp result set that displays STATE only,
from
an
Access
| query between two tables. One table has the state
(location_id)
and
the
| other table has all the user contact data, linked by pri key
location_id)
|
| 3. Click the STATE link, that displays result set of users
filtered
by
state
| (location_id)
|
| 4. Click the NAME of the foot massager this drills to another
result
set,
| showing NAME detail, which is the ID col in the table.
|
| 5. So, on this final result set page, I want to link to a
form
page,
so the
| user can book a visit. My challenge is, I have a standard
booking
form, but
| each NAME or ID...you know, each user, needs to have a form
that
emails
| results to them, specifically.
|
| I have an email addess field in the db, of course, so just
wondering
if I
| can do this without any login, as this is all publicly
accessible...
|
| I hoep that helps. Thanks for taking time out.
|
| jz
|
|
| "Stefan B Rusynko" wrote:
|
| > You need to clearly explain who is doing or viewing what
when
in
your process (and what/when you are displaying from the DB)

 

[jz]

I understand that ou have stated some pretty clear suggestions, Ronx, but as
I wait on hearing back from my last as to if I can do this by using some part
of the original...I'll share the form details. I'm just one step away from
finishing this very long process. I realize the there are programmers for a
reason, but this whole discussion began by saying, sure...u can have a form
for each person that is drilled down to. Now, that doesn't appear to be the
case by asking for help here.

Doesn't anyone in the group have the patience to just share how I can tie
this final loose end up? I am not ungrateful, by no means. I totally
appreciate all of the help, thus far. It's just that we have gone down a
rabbit trail and gotten thinsg to work, but at this final step of the form
actually shooting of results to the email recipient and displaying a confirm,
I'm dead in the water.

Here's the form details, if anyone wants to help. Thanks, again. I am so
very grateful for any input...

<form method="POST" action="--WEBBOT-SELF--" onSubmit="return
FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
<!--webbot bot="SaveResults"
u-file="_private/form_results.csv" s-format="TEXT/CSV" s-label-fields="TRUE"
b-reverse-chronology="FALSE" s-email-format="TEXT/PRE"
s-email-address="<%=Email%>" b-email-label-fields="TRUE"
b-email-subject-from-field="FALSE" s-email-subject="BOOK A VISIT - QUOTE
REQUEST" s-builtin-fields s-form-fields="FNAME LNAME VISIT_TYPE EMAIL COMPANY
SESSION_LENGTH HOW_MANY_MASSAGES VISIT_DATE_DESIRED CITY state ZIP COMMENTS "
u-confirmation-url="thanks.htm#top" startspan --><strong>[FrontPage Save
Results Component]</strong><!--webbot bot="SaveResults" endspan
i-checksum="6561" -->

-jz

Sounds like the extensions were used to process the form data before you
added the ID bit.

I suggest you either go back to the original, learn how to program asp
pages, or pay someone to build the necessary code for you.

There are articles on http://irt.org that explain how to read in
querystrings using JavaScript, and place that value in a form field.

As it stands, if you stay on the .asp route, you need to get and validate
all the form fields, combine them in an email, and programatically send
that email. Then either display a confirmation note (on the same page) or
redirect to a confirmation page.
There are ready made asp form handlers (some free) if you search for them.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Ronx,

The page in question here, that has the form, used to work fine as far as
submitting the form and showing the confirm page.

I think the issue now is that because I added the suggested asp to the
top
of the page...

<%
ID = Request.Querystring("ID")
%>

and renamed teh [age from .htm to .asp, I face this issue.

So, that said, do I need to add asp to each input field for the form?
Or,
based upon what I just stated, do u suggest soemthing else?

Thanks. -jz

The form is set to go to book_MAIN.asp for processing.

What that processing does I have no idea since it is in asp code
blocks -
which do not download to the browser.
I would look for errors in the asp script on the page.

You can use asp to retain the value of the fields when submitted -
otherwise the form fields *will* reset.

Example:
<input name="email" value="<%=request.form("email")%>">
--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Hi, Ronx.

I have the form set to send to <%=Email%>

Also, the issue is is it set to land on a confirm page that is an htm
file
in the same directory. It used to land there, but not since my
changes.

Ideas? The form only vlaidates the fields required, then when those
are
filled in, it just clears things out and reloads the page. I would
expect
that from reset, but not submit. Thanks. -jz

:

Both submit buttons appear to work equally well. The form action is
book_MAIN.asp, which should contain code that:
1) detects whether this is a new representation of the page, or if
the
submit button was pressed
2) If the submit button was pressed, then process the form data - I
would
validate the data in this code block, just in case the user has
JavaScript
disabled which will prevent the FrontPage validation working.

I never filled in the form, so pressing either of the submit buttons
gave
me the FrontPage validation errors. Had the form been submitted then
the
page would have reloaded and your asp script would process the data.

Should the form actually submit to a different page? If so in Form
Properties change the "Send to other" value to the correct page.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Actually, just looking at the code and the image button does not
match
the
new submit button i added, but neither do work, anyhow.

Also, the submit button is pointing to the same asp because I
currently
have
it framed, so it's set to process within the sama target frame.

</table>
<p align="right"><a target="_self"
href="book_MAIN.asp">
<img border="0" src="images/btnRESET.jpg"></a>
<input border="0" src="images/btnSUBMIT.jpg" name="I1"
type="image">
<input type="submit" value="Submit" name="B1"> </p>
</form>
<p> </td>

Thanks. -jz

:

Change
ID = Request.Query.String("ID")
to
ID = Request.Querystring("ID")

Notice the removed full stop between Query and String.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Thanks, Stefan.

I finally got around to trying this out and after publishing, I
get
an
error
when I drill down through the 2nd last page, which is a name
link
leading
to
the final detail page for that person. Here is the error and by
the
way,
I
added this to the header area of the final page that displays
the
form:

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name
and Email)
' from the user contact data table using a std DB recordset
lookup
%>

I also changed out the web bot for "email" with <%email%>, but
maybe
the
header part I added was the problem, as it refers to line 10:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'Query'

/book_MAIN.asp, line 10

Any ideas? Can you tell if I did soemthing wrong?

Thanks. -jz



:

Ok
So the 1st part my 1st resposne is all you need
- you need to pass the link as a parameter to the final form as
a
std
single form page and pass the ID field value of NAME to that
form page form as a parameter

Add your link to the form form page (say called
appointment.asp)
as:
<a href="appointment.asp?ID=<%=fp_rs("ID")%>">Make
appointment</a>
- where in fp_rs("ID") above is the DBR field result record
field
for
ID
for the NAME
Then on the page used the parameter results add at the top of
teh
page

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name and Email)
' from the user contact data table using a std DB recordset
lookup
%>
Then in the form use hidden or normal text fields to prefill in
the
form
as say
<%=Name%> and %=Email%> for the form vield values





_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, sorry about that, Stefan.
|
| Here's the flow.
|
| 1. Guest clicks FIND FOOT MASSAGER link on basic html page
|
| 2. I link them to an asp result set that displays STATE only,
from
an
Access
| query between two tables. One table has the state
(location_id)
and
the
| other table has all the user contact data, linked by pri key
location_id)
|
| 3. Click the STATE link, that displays result set of users
filtered
by
state
| (location_id)
|
| 4. Click the NAME of the foot massager this drills to another
result
set,
| showing NAME detail, which is the ID col in the table.
|
| 5. So, on this final result set page, I want to link to a
form
page,
so the
| user can book a visit. My challenge is, I have a standard
booking
form, but
| each NAME or ID...you know, each user, needs to have a form
that
emails
| results to them, specifically.
|
| I have an email addess field in the db, of course, so just
wondering
if I
| can do this without any login, as this is all publicly
accessible...
|
| I hoep that helps. Thanks for taking time out.
|
| jz
|
|
| "Stefan B Rusynko" wrote:
|
| > You need to clearly explain who is doing or viewing what
when
in
your process (and what/when you are displaying from the DB)

 

[jz]

I totally apologize for how this last post came out. I could not find any
edit option or I would have changed the wording. I would have changed it to
something a little less drastic, like...

"would there be anyone in the group willing to walk me through this last
portion to get the form to work?"

I did look at some free form handlers, but fairly lost when I look through
ut. Yes, i'm totally open to learning asp...it looks cool. I just need to
get this done soon and can usually pick up soem good traning in situations
like this.

Again, I am sorry for the harsh tone of my last post. I really wanted to
edit it, but couldn't. Yes, I must have thought those thoughts, but not
everyhing we think do we have to stand by, right? I can't unring the bell,
but I can apologize for my poor choice of words, so sorry:-(

Sounds like the extensions were used to process the form data before you
added the ID bit.

I suggest you either go back to the original, learn how to program asp
pages, or pay someone to build the necessary code for you.

There are articles on http://irt.org that explain how to read in
querystrings using JavaScript, and place that value in a form field.

As it stands, if you stay on the .asp route, you need to get and validate
all the form fields, combine them in an email, and programatically send
that email. Then either display a confirmation note (on the same page) or
redirect to a confirmation page.
There are ready made asp form handlers (some free) if you search for them.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Ronx,

The page in question here, that has the form, used to work fine as far as
submitting the form and showing the confirm page.

I think the issue now is that because I added the suggested asp to the
top
of the page...

<%
ID = Request.Querystring("ID")
%>

and renamed teh [age from .htm to .asp, I face this issue.

So, that said, do I need to add asp to each input field for the form?
Or,
based upon what I just stated, do u suggest soemthing else?

Thanks. -jz

The form is set to go to book_MAIN.asp for processing.

What that processing does I have no idea since it is in asp code
blocks -
which do not download to the browser.
I would look for errors in the asp script on the page.

You can use asp to retain the value of the fields when submitted -
otherwise the form fields *will* reset.

Example:
<input name="email" value="<%=request.form("email")%>">
--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Hi, Ronx.

I have the form set to send to <%=Email%>

Also, the issue is is it set to land on a confirm page that is an htm
file
in the same directory. It used to land there, but not since my
changes.

Ideas? The form only vlaidates the fields required, then when those
are
filled in, it just clears things out and reloads the page. I would
expect
that from reset, but not submit. Thanks. -jz

:

Both submit buttons appear to work equally well. The form action is
book_MAIN.asp, which should contain code that:
1) detects whether this is a new representation of the page, or if
the
submit button was pressed
2) If the submit button was pressed, then process the form data - I
would
validate the data in this code block, just in case the user has
JavaScript
disabled which will prevent the FrontPage validation working.

I never filled in the form, so pressing either of the submit buttons
gave
me the FrontPage validation errors. Had the form been submitted then
the
page would have reloaded and your asp script would process the data.

Should the form actually submit to a different page? If so in Form
Properties change the "Send to other" value to the correct page.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Actually, just looking at the code and the image button does not
match
the
new submit button i added, but neither do work, anyhow.

Also, the submit button is pointing to the same asp because I
currently
have
it framed, so it's set to process within the sama target frame.

</table>
<p align="right"><a target="_self"
href="book_MAIN.asp">
<img border="0" src="images/btnRESET.jpg"></a>
<input border="0" src="images/btnSUBMIT.jpg" name="I1"
type="image">
<input type="submit" value="Submit" name="B1"> </p>
</form>
<p> </td>

Thanks. -jz

:

Change
ID = Request.Query.String("ID")
to
ID = Request.Querystring("ID")

Notice the removed full stop between Query and String.

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Thanks, Stefan.

I finally got around to trying this out and after publishing, I
get
an
error
when I drill down through the 2nd last page, which is a name
link
leading
to
the final detail page for that person. Here is the error and by
the
way,
I
added this to the header area of the final page that displays
the
form:

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name
and Email)
' from the user contact data table using a std DB recordset
lookup
%>

I also changed out the web bot for "email" with <%email%>, but
maybe
the
header part I added was the problem, as it refers to line 10:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'Query'

/book_MAIN.asp, line 10

Any ideas? Can you tell if I did soemthing wrong?

Thanks. -jz



:

Ok
So the 1st part my 1st resposne is all you need
- you need to pass the link as a parameter to the final form as
a
std
single form page and pass the ID field value of NAME to that
form page form as a parameter

Add your link to the form form page (say called
appointment.asp)
as:
<a href="appointment.asp?ID=<%=fp_rs("ID")%>">Make
appointment</a>
- where in fp_rs("ID") above is the DBR field result record
field
for
ID
for the NAME
Then on the page used the parameter results add at the top of
teh
page

<%
ID = Request.Query.String("ID")
' here use the ID value to get your NAME contact information
(say
the
Name and Email)
' from the user contact data table using a std DB recordset
lookup
%>
Then in the form use hidden or normal text fields to prefill in
the
form
as say
<%=Name%> and %=Email%> for the form vield values





_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, sorry about that, Stefan.
|
| Here's the flow.
|
| 1. Guest clicks FIND FOOT MASSAGER link on basic html page
|
| 2. I link them to an asp result set that displays STATE only,
from
an
Access
| query between two tables. One table has the state
(location_id)
and
the
| other table has all the user contact data, linked by pri key
location_id)
|
| 3. Click the STATE link, that displays result set of users
filtered
by
state
| (location_id)
|
| 4. Click the NAME of the foot massager this drills to another
result
set,
| showing NAME detail, which is the ID col in the table.
|
| 5. So, on this final result set page, I want to link to a
form
page,
so the
| user can book a visit. My challenge is, I have a standard
booking
form, but
| each NAME or ID...you know, each user, needs to have a form
that
emails
| results to them, specifically.
|
| I have an email addess field in the db, of course, so just
wondering
if I
| can do this without any login, as this is all publicly
accessible...
|
| I hoep that helps. Thanks for taking time out.
|
| jz
|
|
| "Stefan B Rusynko" wrote:
|
| > You need to clearly explain who is doing or viewing what
when
in
your process (and what/when you are displaying from the DB)