Re: DBRW link to frontpage form

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks, Ronx...

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

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

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

thanks for any feedback and for your last one! -jz

"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" <jz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F15BF838-0B16-411D-AD47-FE3106B5ACD0@xxxxxxxxxxxxxxxx
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" <jz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A46466D3-DD03-4F98-B8CD-3BA6CA6A42E5@xxxxxxxxxxxxxxxx
| 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" <jz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7313690B-5478-4E50-B1BA-AB7CF2E819CB@xxxxxxxxxxxxxxxx
| > | 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" <jz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A8B0B6A-196D-4079-A12C-5A600190DE3E@xxxxxxxxxxxxxxxx
| > | > | 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
| > | >
| > | >
| > | >
| >
| >
| >





.

Quantcast