"jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
| 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" 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!"  (-;
> _____________________________________________
>
>
> "jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> | 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" <j*@discussions.microsoft.com> wrote in message news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
| 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!"  (-;
| > _____________________________________________
| >
| >
| > "jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
| > | 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" 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!"  (-;
> _____________________________________________
>
>
> "jz" <j*@discussions.microsoft.com> wrote in message news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> | 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!"  (-;
> | > _____________________________________________
> | >
> | >
> | > "jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> | > | 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" <j*@discussions.microsoft.com> wrote in message news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
| 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!"  (-;
| > _____________________________________________
| >
| >
| > "jz" <j*@discussions.microsoft.com> wrote in message news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
| > | 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!"  (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > "jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
| > | > | 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" 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!"  (-;
> _____________________________________________
>
>
> "jz" <j*@discussions.microsoft.com> wrote in message news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> | 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!"  (-;
> | > _____________________________________________
> | >
> | >
> | > "jz" <j*@discussions.microsoft.com> wrote in message news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> | > | 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!"  (-;
> | > | > _____________________________________________
> | > | >
> | > | >
> | > | > "jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> | > | > | 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" <j*@discussions.microsoft.com> wrote in message
news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> 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!"  (-;
>> _____________________________________________
>>
>>
>> "jz" <j*@discussions.microsoft.com> wrote in message
>> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
>> | 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!"  (-;
>> | > _____________________________________________
>> | >
>> | >
>> | > "jz" <j*@discussions.microsoft.com> wrote in message
>> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
>> | > | 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!"  (-;
>> | > | > _____________________________________________
>> | > | >
>> | > | >
>> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
>> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
>> | > | > | 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" wrote:

> 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
>
> "jz" <j*@discussions.microsoft.com> wrote in message
> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> > 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!"  (-;
> >> _____________________________________________
> >>
> >>
> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> >> | 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!"  (-;
> >> | > _____________________________________________
> >> | >
> >> | >
> >> | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> >> | > | 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!"  (-;
> >> | > | > _____________________________________________
> >> | > | >
> >> | > | >
> >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> >> | > | > | 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" wrote:

> 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
>
> "jz" <j*@discussions.microsoft.com> wrote in message
> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> > 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!"  (-;
> >> _____________________________________________
> >>
> >>
> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> >> | 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!"  (-;
> >> | > _____________________________________________
> >> | >
> >> | >
> >> | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> >> | > | 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!"  (-;
> >> | > | > _____________________________________________
> >> | > | >
> >> | > | >
> >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> >> | > | > | 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" <j*@discussions.microsoft.com> wrote in message
news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
> 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
>
> "Ronx" wrote:
>
>> 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
>>
>> "jz" <j*@discussions.microsoft.com> wrote in message
>> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
>> > 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!"  (-;
>> >> _____________________________________________
>> >>
>> >>
>> >> "jz" <j*@discussions.microsoft.com> wrote in message
>> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
>> >> | 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!"  (-;
>> >> | > _____________________________________________
>> >> | >
>> >> | >
>> >> | > "jz" <j*@discussions.microsoft.com> wrote in message
>> >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
>> >> | > | 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!"  (-;
>> >> | > | > _____________________________________________
>> >> | > | >
>> >> | > | >
>> >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
>> >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
>> >> | > | > | 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" wrote:

> 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
>
> "jz" <j*@discussions.microsoft.com> wrote in message
> news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
> > 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
> >
> > "Ronx" wrote:
> >
> >> 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
> >>
> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> >> > 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!"  (-;
> >> >> _____________________________________________
> >> >>
> >> >>
> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> >> >> | 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!"  (-;
> >> >> | > _____________________________________________
> >> >> | >
> >> >> | >
> >> >> | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> >> >> | > | 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!"  (-;
> >> >> | > | > _____________________________________________
> >> >> | > | >
> >> >> | > | >
> >> >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> >> >> | > | > | 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" <j*@discussions.microsoft.com> wrote in message
news:0E55EA7B-F51F-41E8-B471-20F490A1D666@microsoft.com...
> 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
>
> "Ronx" wrote:
>
>> 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
>>
>> "jz" <j*@discussions.microsoft.com> wrote in message
>> news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
>> > 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
>> >
>> > "Ronx" wrote:
>> >
>> >> 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
>> >>
>> >> "jz" <j*@discussions.microsoft.com> wrote in message
>> >> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
>> >> > 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!"  (-;
>> >> >> _____________________________________________
>> >> >>
>> >> >>
>> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
>> >> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
>> >> >> | 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!"  (-;
>> >> >> | > _____________________________________________
>> >> >> | >
>> >> >> | >
>> >> >> | > "jz" <j*@discussions.microsoft.com> wrote in message
>> >> >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
>> >> >> | > | 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!"  (-;
>> >> >> | > | > _____________________________________________
>> >> >> | > | >
>> >> >> | > | >
>> >> >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
>> >> >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
>> >> >> | > | > | 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" wrote:

> 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
>
> "jz" <j*@discussions.microsoft.com> wrote in message
> news:0E55EA7B-F51F-41E8-B471-20F490A1D666@microsoft.com...
> > 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
> >
> > "Ronx" wrote:
> >
> >> 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
> >>
> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
> >> > 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
> >> >
> >> > "Ronx" wrote:
> >> >
> >> >> 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
> >> >>
> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> >> >> > 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!"  (-;
> >> >> >> _____________________________________________
> >> >> >>
> >> >> >>
> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> >> >> >> | 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!"  (-;
> >> >> >> | > _____________________________________________
> >> >> >> | >
> >> >> >> | >
> >> >> >> | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> >> >> >> | > | 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!"  (-;
> >> >> >> | > | > _____________________________________________
> >> >> >> | > | >
> >> >> >> | > | >
> >> >> >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> >> >> >> | > | > | Ok, I have a good one, here.  Maybe it's possible; maybe
> >> >> >> not.
> >> >> >> Make sure
> >> >> >> | > | > | you've had your coffee or ginko drink before tackling
> >> >> >> this
> >> >> >> one:-)
> >> >> >> | > | > |
> >> >> >> | > | > | So, I have this one form to book an appointment.  I
> >> >> >> would
> >> >> >> like
> >> >> >> be able to
> >> >> >> | > | > | have each detail page for a person, which of course is
> >> >> >> generated using a
> >> >> >> | > | > | unique id and results page, point to their own, specific
> >> >> >> appointment form.
> >> >> >> | > | > |
> >> >> >> | > | > | I am guessing that I would need to take my main
> >> >> >> appointment
> >> >> >> form and
> >> >> >> | > | > | manually create a unique form for each person, which I
> >> >> >> can
> >> >> >> do.
> >> >> >> (If this can
> >> >> >> | > | > | be automated, as far as the form results being emailed
> >> >> >> to

"jz" <j*@discussions.microsoft.com> wrote in message
news:6C8CA15D-466B-4548-9092-FB441D8C219A@microsoft.com...
> 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
>
> "Ronx" wrote:
>
>> 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
>>
>> "jz" <j*@discussions.microsoft.com> wrote in message
>> news:0E55EA7B-F51F-41E8-B471-20F490A1D666@microsoft.com...
>> > 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
>> >
>> > "Ronx" wrote:
>> >
>> >> 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
>> >>
>> >> "jz" <j*@discussions.microsoft.com> wrote in message
>> >> news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
>> >> > 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
>> >> >
>> >> > "Ronx" wrote:
>> >> >
>> >> >> 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
>> >> >>
>> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
>> >> >> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
>> >> >> > 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!"  (-;
>> >> >> >> _____________________________________________
>> >> >> >>
>> >> >> >>
>> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
>> >> >> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
>> >> >> >> | 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!"  (-;
>> >> >> >> | > _____________________________________________
>> >> >> >> | >
>> >> >> >> | >
>> >> >> >> | > "jz" <j*@discussions.microsoft.com> wrote in message
>> >> >> >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
>> >> >> >> | > | 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!"
>> >> >> >> (-;
>> >> >> >> | > | > _____________________________________________
>> >> >> >> | > | >
>> >> >> >> | > | >
>> >> >> >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
>> >> >> >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
>> >> >> >> | > | > | 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

"Ronx" wrote:

> Sounds like the extensions were used to process the form data before you
> added the ID bit.
>
> I suggest you either go back to the original,  learn how to program asp
> pages, or pay someone to build the necessary code for you.
>
> There are articles on http://irt.org that explain how to read in
> querystrings using JavaScript, and place that value in a form field.
>
> As it stands, if you stay on the .asp route, you need to get and validate
> all the form fields, combine them in an email, and programatically send
> that email.  Then either display a confirmation note (on the same page) or
> redirect to a confirmation page.
> There are ready made asp form handlers (some free) if you search for them.
>
> --
> Ron Symonds - Microsoft MVP (Expression)
> Reply only to group - emails will be deleted unread.
> http://www.rxs-enterprises.org/fp
>
> "jz" <j*@discussions.microsoft.com> wrote in message
> news:6C8CA15D-466B-4548-9092-FB441D8C219A@microsoft.com...
> > 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
> >
> > "Ronx" wrote:
> >
> >> 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
> >>
> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:0E55EA7B-F51F-41E8-B471-20F490A1D666@microsoft.com...
> >> > 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
> >> >
> >> > "Ronx" wrote:
> >> >
> >> >> 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
> >> >>
> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
> >> >> > 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
> >> >> >
> >> >> > "Ronx" wrote:
> >> >> >
> >> >> >> 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
> >> >> >>
> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> >> >> >> > 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!"  (-;
> >> >> >> >> _____________________________________________
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> >> >> >> >> | 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)

"Ronx" wrote:

> Sounds like the extensions were used to process the form data before you
> added the ID bit.
>
> I suggest you either go back to the original,  learn how to program asp
> pages, or pay someone to build the necessary code for you.
>
> There are articles on http://irt.org that explain how to read in
> querystrings using JavaScript, and place that value in a form field.
>
> As it stands, if you stay on the .asp route, you need to get and validate
> all the form fields, combine them in an email, and programatically send
> that email.  Then either display a confirmation note (on the same page) or
> redirect to a confirmation page.
> There are ready made asp form handlers (some free) if you search for them.
>
> --
> Ron Symonds - Microsoft MVP (Expression)
> Reply only to group - emails will be deleted unread.
> http://www.rxs-enterprises.org/fp
>
> "jz" <j*@discussions.microsoft.com> wrote in message
> news:6C8CA15D-466B-4548-9092-FB441D8C219A@microsoft.com...
> > 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
> >
> > "Ronx" wrote:
> >
> >> 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
> >>
> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:0E55EA7B-F51F-41E8-B471-20F490A1D666@microsoft.com...
> >> > 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
> >> >
> >> > "Ronx" wrote:
> >> >
> >> >> 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
> >> >>
> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
> >> >> > 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
> >> >> >
> >> >> > "Ronx" wrote:
> >> >> >
> >> >> >> 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
> >> >> >>
> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> >> >> >> > 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!"  (-;
> >> >> >> >> _____________________________________________
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> >> >> >> >> | 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)

"Ronx" wrote:

> Sounds like the extensions were used to process the form data before you
> added the ID bit.
>
> I suggest you either go back to the original,  learn how to program asp
> pages, or pay someone to build the necessary code for you.
>
> There are articles on http://irt.org that explain how to read in
> querystrings using JavaScript, and place that value in a form field.
>
> As it stands, if you stay on the .asp route, you need to get and validate
> all the form fields, combine them in an email, and programatically send
> that email.  Then either display a confirmation note (on the same page) or
> redirect to a confirmation page.
> There are ready made asp form handlers (some free) if you search for them.
>
> --
> Ron Symonds - Microsoft MVP (Expression)
> Reply only to group - emails will be deleted unread.
> http://www.rxs-enterprises.org/fp
>
> "jz" <j*@discussions.microsoft.com> wrote in message
> news:6C8CA15D-466B-4548-9092-FB441D8C219A@microsoft.com...
> > 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
> >
> > "Ronx" wrote:
> >
> >> 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
> >>
> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> news:0E55EA7B-F51F-41E8-B471-20F490A1D666@microsoft.com...
> >> > 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
> >> >
> >> > "Ronx" wrote:
> >> >
> >> >> 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
> >> >>
> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> news:F011721E-C28D-4474-9C45-91AD73B0EB79@microsoft.com...
> >> >> > 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
> >> >> >
> >> >> > "Ronx" wrote:
> >> >> >
> >> >> >> 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
> >> >> >>
> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> >> >> >> > 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!"  (-;
> >> >> >> >> _____________________________________________
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message
> >> >> >> >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> >> >> >> >> | 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)

"Ronx" <ronx***@hotmail.com> wrote in message news:emON7Y3kJHA.5124@TK2MSFTNGP03.phx.gbl...
| 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
|
| "jz" <j*@discussions.microsoft.com> wrote in message
| news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
| > 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!"  (-;
| >> _____________________________________________
| >>
| >>
| >> "jz" <j*@discussions.microsoft.com> wrote in message
| >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
| >> | 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!"  (-;
| >> | > _____________________________________________
| >> | >
| >> | >
| >> | > "jz" <j*@discussions.microsoft.com> wrote in message
| >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
| >> | > | 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!"  (-;
| >> | > | > _____________________________________________
| >> | > | >
| >> | > | >
| >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
| >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
| >> | > | > | 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" 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!"  (-;
> _____________________________________________
>
>
> "Ronx" <ronx***@hotmail.com> wrote in message news:emON7Y3kJHA.5124@TK2MSFTNGP03.phx.gbl...
> | 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
> |
> | "jz" <j*@discussions.microsoft.com> wrote in message
> | news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
> | > 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!"  (-;
> | >> _____________________________________________
> | >>
> | >>
> | >> "jz" <j*@discussions.microsoft.com> wrote in message
> | >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> | >> | 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!"  (-;
> | >> | > _____________________________________________
> | >> | >
> | >> | >
> | >> | > "jz" <j*@discussions.microsoft.com> wrote in message
> | >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> | >> | > | 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!"  (-;
> | >> | > | > _____________________________________________
> | >> | > | >
> | >> | > | >
> | >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
> | >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> | >> | > | > | 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" <j*@discussions.microsoft.com> wrote in message news:9F60B225-DA41-436D-B4BE-07A735A88746@microsoft.com...
| 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!"  (-;
| > _____________________________________________
| >
| >
| > "Ronx" <ronx***@hotmail.com> wrote in message news:emON7Y3kJHA.5124@TK2MSFTNGP03.phx.gbl...
| > | 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
| > |
| > | "jz" <j*@discussions.microsoft.com> wrote in message
| > | news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
| > | > 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!"  (-;
| > | >> _____________________________________________
| > | >>
| > | >>
| > | >> "jz" <j*@discussions.microsoft.com> wrote in message
| > | >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
| > | >> | 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!"  (-;
| > | >> | > _____________________________________________
| > | >> | >
| > | >> | >
| > | >> | > "jz" <j*@discussions.microsoft.com> wrote in message
| > | >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
| > | >> | > | 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!"  (-;
| > | >> | > | > _____________________________________________
| > | >> | > | >
| > | >> | > | >
| > | >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
| > | >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
| > | >> | > | > | 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" <j*@discussions.microsoft.com> wrote in message
news:9F60B225-DA41-436D-B4BE-07A735A88746@microsoft.com...
> 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!"  (-;
>> _____________________________________________
>>
>>
>> "Ronx" <ronx***@hotmail.com> wrote in message
>> news:emON7Y3kJHA.5124@TK2MSFTNGP03.phx.gbl...
>> | 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
>> |
>> | "jz" <j*@discussions.microsoft.com> wrote in message
>> | news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@microsoft.com...
>> | > 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!"  (-;
>> | >> _____________________________________________
>> | >>
>> | >>
>> | >> "jz" <j*@discussions.microsoft.com> wrote in message
>> | >> news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
>> | >> | 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!"  (-;
>> | >> | > _____________________________________________
>> | >> | >
>> | >> | >
>> | >> | > "jz" <j*@discussions.microsoft.com> wrote in message
>> | >> news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
>> | >> | > | 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!"  (-;
>> | >> | > | > _____________________________________________
>> | >> | > | >
>> | >> | > | >
>> | >> | > | > "jz" <j*@discussions.microsoft.com> wrote in message
>> | >> news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
>> | >> | > | > | 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" 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!"  (-;
> _____________________________________________
>
>
> "jz" <j*@discussions.microsoft.com> wrote in message news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> | 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!"  (-;
> | > _____________________________________________
> | >
> | >
> | > "jz" <j*@discussions.microsoft.com> wrote in message news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> | > | 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!"  (-;
> | > | > _____________________________________________
> | > | >
> | > | >
> | > | > "jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> | > | > | 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" 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!"  (-;
> _____________________________________________
>
>
> "jz" <j*@discussions.microsoft.com> wrote in message news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@microsoft.com...
> | 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!"  (-;
> | > _____________________________________________
> | >
> | >
> | > "jz" <j*@discussions.microsoft.com> wrote in message news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@microsoft.com...
> | > | 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!"  (-;
> | > | > _____________________________________________
> | > | >
> | > | >
> | > | > "jz" <j*@discussions.microsoft.com> wrote in message news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@microsoft.com...
> | > | > | 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
> | > | >
> | > | >
> | > | >
> | >
> | >
> | >
>
>
>