DBRW link to frontpage form

[jz]

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 their email address
that is already in the result set, that would be awesome...since that would
be the only difference in the form)

The challenge is, again...if this is even possible, to make that link on
their detail results page point to a unqiue form file name.

Maybe I'm making this more complicated, as I'm thinking it through as i type
this. I can just add the filename in the db colum, right? Then, link to it
like I do with a photo file or whatever, right?

Thanks for any guidance, as always.

-jz

 

[Stefan B Rusynko]

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 their email address
| that is already in the result set, that would be awesome...since that would
| be the only difference in the form)
|
| The challenge is, again...if this is even possible, to make that link on
| their detail results page point to a unqiue form file name.
|
| Maybe I'm making this more complicated, as I'm thinking it through as i type
| this. I can just add the filename in the db colum, right? Then, link to it
| like I do with a photo file or whatever, right?
|
| Thanks for any guidance, as always.
|
| -jz

 

[jz]

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]

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 their email address
| > | that is already in the result set, that would be awesome...since that would
| > | be the only difference in the form)
| > |
| > | The challenge is, again...if this is even possible, to make that link on
| > | their detail results page point to a unqiue form file name.
| > |
| > | Maybe I'm making this more complicated, as I'm thinking it through as i type
| > | this. I can just add the filename in the db colum, right? Then, link to it
| > | like I do with a photo file or whatever, right?
| > |
| > | Thanks for any guidance, as always.
| > |
| > | -jz
| >
| >
| >

 

[jz]

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

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 their email address
| > | that is already in the result set, that would be awesome...since that would
| > | be the only difference in the form)
| > |
| > | The challenge is, again...if this is even possible, to make that link on
| > | their detail results page point to a unqiue form file name.
| > |
| > | Maybe I'm making this more complicated, as I'm thinking it through as i type
| > | this. I can just add the filename in the db colum, right? Then, link to it
| > | like I do with a photo file or whatever, right?
| > |
| > | Thanks for any guidance, as always.
| > |
| > | -jz
| >
| >
| >

 

[Stefan B Rusynko]

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 their email address
| > | > | that is already in the result set, that would be awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it through as i type
| > | > | this. I can just add the filename in the db colum, right? Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[jz]

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 their email address
| > | > | that is already in the result set, that would be awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it through as i type
| > | > | this. I can just add the filename in the db colum, right? Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[jz]

Also...this is what my link looks like that drills down to that form page:

.../../book_MAIN.asp?ID=<%=fp_rs("ID")%>

Thanks, Stefan. -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 their email address
| > | > | that is already in the result set, that would be awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it through as i type
| > | > | this. I can just add the filename in the db colum, right? Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[jz]

And sorry, for what it's worth...when I rollover the link, it does appear to
have the right id for that result page before it tries to link to the booking
form page.

thx. -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 their email address
| > | > | that is already in the result set, that would be awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it through as i type
| > | > | this. I can just add the filename in the db colum, right? Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[Ronx]

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
their email address
| > | > | that is already in the result set, that would be
awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make
that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it
through as i type
| > | > | this. I can just add the filename in the db colum, right?
Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[jz]

Thanks, Ronx...

That worked. One more issue, though. My form does not process on submit.
I had used a form image and made it a submit button by using the same value
of the original submit button and it worked before my making this an asp page
and making these recent changes.

I added a normal submit button next to it, now, just to test and that button
also shows the page name on rollover and when submitted, just reloads the
page.

Any ideas? I can share a link, if u think it will help. Actually, it's
agonyofdafeet.com, choose FIND on right...then drill down and u will see the
form and submit issue.

thanks for any feedback and for your last one! -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
their email address
| > | > | that is already in the result set, that would be
awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make
that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it
through as i type
| > | > | this. I can just add the filename in the db colum, right?
Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[jz]

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
their email address
| > | > | that is already in the result set, that would be
awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make
that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it
through as i type
| > | > | this. I can just add the filename in the db colum, right?
Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[Stefan B Rusynko]

Thanks Ronx
- My error on the Request.Query.String vs Request.QueryString
(don't know how I added that .)

--

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


| 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
| >
| >
| >
| > "Stefan B Rusynko" wrote:
| >
| >> 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
| >> their email address
| >> | > | > | that is already in the result set, that would be
| >> awesome...since that would
| >> | > | > | be the only difference in the form)
| >> | > | > |
| >> | > | > | The challenge is, again...if this is even possible, to make
| >> that link on
| >> | > | > | their detail results page point to a unqiue form file name.
| >> | > | > |
| >> | > | > | Maybe I'm making this more complicated, as I'm thinking it
| >> through as i type
| >> | > | > | this. I can just add the filename in the db colum, right?
| >> Then, link to it
| >> | > | > | like I do with a photo file or whatever, right?
| >> | > | > |
| >> | > | > | Thanks for any guidance, as always.
| >> | > | > |
| >> | > | > | -jz
| >> | > | >
| >> | > | >
| >> | > | >
| >> | >
| >> | >
| >> | >
| >>
| >>
| >>
|

 

[jz]

Hi, Stefan, Ronx...

not sure if you were aware, but the 2 above have details that I need help on
regarding the form submit not working.

ANy help is appreciated, as I'm just that one step away for this particular
endeavor.

Thanks! -jz

Thanks Ronx
- My error on the Request.Query.String vs Request.QueryString
(don't know how I added that .)

--

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


| 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
| >
| >
| >
| > "Stefan B Rusynko" wrote:
| >
| >> 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
| >> their email address
| >> | > | > | that is already in the result set, that would be
| >> awesome...since that would
| >> | > | > | be the only difference in the form)
| >> | > | > |
| >> | > | > | The challenge is, again...if this is even possible, to make
| >> that link on
| >> | > | > | their detail results page point to a unqiue form file name.
| >> | > | > |
| >> | > | > | Maybe I'm making this more complicated, as I'm thinking it
| >> through as i type
| >> | > | > | this. I can just add the filename in the db colum, right?
| >> Then, link to it
| >> | > | > | like I do with a photo file or whatever, right?
| >> | > | > |
| >> | > | > | Thanks for any guidance, as always.
| >> | > | > |
| >> | > | > | -jz
| >> | > | >
| >> | > | >
| >> | > | >
| >> | >
| >> | >
| >> | >
| >>
| >>
| >>
|

 

[Ronx]

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
their email address
| > | > | that is already in the result set, that would be
awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make
that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it
through as i type
| > | > | this. I can just add the filename in the db colum, right?
Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[Stefan B Rusynko]

You need to be more specific on what is not working in what .asp page
- since your site is framed don't provide the home page URL
(provide the .asp page URL starting with the form page)
I checked the find link and it displayed the states and then the rep on the next page apparently passing the query string

--

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


| Hi, Stefan, Ronx...
|
| not sure if you were aware, but the 2 above have details that I need help on
| regarding the form submit not working.
|
| ANy help is appreciated, as I'm just that one step away for this particular
| endeavor.
|
| Thanks! -jz
|
| "Stefan B Rusynko" wrote:
|
| > Thanks Ronx
| > - My error on the Request.Query.String vs Request.QueryString
| > (don't know how I added that .)
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | 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
| > | >
| > | >
| > | >
| > | > "Stefan B Rusynko" wrote:
| > | >
| > | >> 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
| > | >> their email address
| > | >> | > | > | that is already in the result set, that would be
| > | >> awesome...since that would
| > | >> | > | > | be the only difference in the form)
| > | >> | > | > |
| > | >> | > | > | The challenge is, again...if this is even possible, to make
| > | >> that link on
| > | >> | > | > | their detail results page point to a unqiue form file name.
| > | >> | > | > |
| > | >> | > | > | Maybe I'm making this more complicated, as I'm thinking it
| > | >> through as i type
| > | >> | > | > | this. I can just add the filename in the db colum, right?
| > | >> Then, link to it
| > | >> | > | > | like I do with a photo file or whatever, right?
| > | >> | > | > |
| > | >> | > | > | Thanks for any guidance, as always.
| > | >> | > | > |
| > | >> | > | > | -jz
| > | >> | > | >
| > | >> | > | >
| > | >> | > | >
| > | >> | >
| > | >> | >
| > | >> | >
| > | >>
| > | >>
| > | >>
| > |
| >
| >
| >

 

[Ronx]

Just responded to your midnight (GMT) post a few seconds ago.

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

Hi, Stefan, Ronx...

not sure if you were aware, but the 2 above have details that I need help
on
regarding the form submit not working.

ANy help is appreciated, as I'm just that one step away for this
particular
endeavor.

Thanks! -jz

Thanks Ronx
- My error on the Request.Query.String vs Request.QueryString
(don't know how I added that .)

--

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


| 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
| >
| >
| >
| > "Stefan B Rusynko" wrote:
| >
| >> 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
| >> their email address
| >> | > | > | that is already in the result set, that would be
| >> awesome...since that would
| >> | > | > | be the only difference in the form)
| >> | > | > |
| >> | > | > | The challenge is, again...if this is even possible, to
make
| >> that link on
| >> | > | > | their detail results page point to a unqiue form file
name.
| >> | > | > |
| >> | > | > | Maybe I'm making this more complicated, as I'm thinking
it
| >> through as i type
| >> | > | > | this. I can just add the filename in the db colum,
right?
| >> Then, link to it
| >> | > | > | like I do with a photo file or whatever, right?
| >> | > | > |
| >> | > | > | Thanks for any guidance, as always.
| >> | > | > |
| >> | > | > | -jz
| >> | > | >
| >> | > | >
| >> | > | >
| >> | >
| >> | >
| >> | >
| >>
| >>
| >>
|

 

[jz]

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
their email address
| > | > | that is already in the result set, that would be
awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to make
that link on
| > | > | their detail results page point to a unqiue form file name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking it
through as i type
| > | > | this. I can just add the filename in the db colum, right?
Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[Ronx]

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
their email address
| > | > | that is already in the result set, that would be
awesome...since that would
| > | > | be the only difference in the form)
| > | > |
| > | > | The challenge is, again...if this is even possible, to
make
that link on
| > | > | their detail results page point to a unqiue form file
name.
| > | > |
| > | > | Maybe I'm making this more complicated, as I'm thinking
it
through as i type
| > | > | this. I can just add the filename in the db colum,
right?
Then, link to it
| > | > | like I do with a photo file or whatever, right?
| > | > |
| > | > | Thanks for any guidance, as always.
| > | > |
| > | > | -jz
| > | >
| > | >
| > | >
| >
| >
| >

 

[jz]

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