Unable to retrieve request() information

[Steve Howie]

I am admittedly new to this sort of thing so I'll explain what I'm trying to
do in Frontpage XP:

I have a page with a form intended to collect information from the user.
Upon pressing save, the form posts the information to a SQL server database.
This all works fine.

Then, a confirmation page is supposed to come up and show the fields from
the newly saved database. However, when I setup the confirmation page, I
can't get the database results region to select only the record that was
just saved. Upon looking further, I noticed that using request("Cust_name")
shows nothing. I believe it should be retrieving the form field from the
previous page, which has a field of the same name.

The problem is that the SQL server will do some calcs on the server side so
I want to show the fields.....how can I pass the parameter from the first
ASP page to the next for use as a SQL statement parameter? So far, all
attempts to get the parameter information return blanks.

I'll pass code on if it's helpful.

thanks in advance!

 

[Stefan B Rusynko]

Look at http://www.frontpagehowto.com/Add_Shipper.htm
Or to get form field values (form field name: Cust_name) to a page w/ ASP use
Request.QueryString("Cust_name")




| I am admittedly new to this sort of thing so I'll explain what I'm trying to
| do in Frontpage XP:
|
| I have a page with a form intended to collect information from the user.
| Upon pressing save, the form posts the information to a SQL server database.
| This all works fine.
|
| Then, a confirmation page is supposed to come up and show the fields from
| the newly saved database. However, when I setup the confirmation page, I
| can't get the database results region to select only the record that was
| just saved. Upon looking further, I noticed that using request("Cust_name")
| shows nothing. I believe it should be retrieving the form field from the
| previous page, which has a field of the same name.
|
| The problem is that the SQL server will do some calcs on the server side so
| I want to show the fields.....how can I pass the parameter from the first
| ASP page to the next for use as a SQL statement parameter? So far, all
| attempts to get the parameter information return blanks.
|
| I'll pass code on if it's helpful.
|
| thanks in advance!
|
|

 

[Steve Howie]

That doesn't work in this situation. The only thing I see that can pull the
item from the previous page is under the insert-web
component-advanced-confirmation field. In the code, I see the following:

<!--webbot bot="ConfirmationField" S-Field="Cust_name" -->

I'm not sure how to use this to populate a variable, though for a SQL
statement. So far the wizards are making life rather difficult!

 

[Stefan B Rusynko]

You can't mix FP webbots (require html pages) and ASP/DB and can't pass webbots to SQL

If your page is a .asp page it works




| That doesn't work in this situation. The only thing I see that can pull the
| item from the previous page is under the insert-web
| component-advanced-confirmation field. In the code, I see the following:
|
| <!--webbot bot="ConfirmationField" S-Field="Cust_name" -->
|
| I'm not sure how to use this to populate a variable, though for a SQL
| statement. So far the wizards are making life rather difficult!
|
|
|
|
|
| | > Look at http://www.frontpagehowto.com/Add_Shipper.htm
| > Or to get form field values (form field name: Cust_name) to a page w/ ASP
| > use
| > Request.QueryString("Cust_name")
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | I am admittedly new to this sort of thing so I'll explain what I'm
| > trying to
| > | do in Frontpage XP:
| > |
| > | I have a page with a form intended to collect information from the user.
| > | Upon pressing save, the form posts the information to a SQL server
| > database.
| > | This all works fine.
| > |
| > | Then, a confirmation page is supposed to come up and show the fields
| > from
| > | the newly saved database. However, when I setup the confirmation page,
| > I
| > | can't get the database results region to select only the record that was
| > | just saved. Upon looking further, I noticed that using
| > request("Cust_name")
| > | shows nothing. I believe it should be retrieving the form field from
| > the
| > | previous page, which has a field of the same name.
| > |
| > | The problem is that the SQL server will do some calcs on the server side
| > so
| > | I want to show the fields.....how can I pass the parameter from the
| > first
| > | ASP page to the next for use as a SQL statement parameter? So far, all
| > | attempts to get the parameter information return blanks.
| > |
| > | I'll pass code on if it's helpful.
| > |
| > | thanks in advance!
| > |
| > |
| >
| >
|
|

 

[Steve Howie]

Thanks. I was afraid of that. I'll work to get the data connection done
manually in ASP, then. I've never been too fond of all these wizards
anyway, but was in a hurry and hoped they could do something simple....

You can't mix FP webbots (require html pages) and ASP/DB and can't pass
webbots to SQL

If your page is a .asp page it works




| That doesn't work in this situation. The only thing I see that can pull
the
| item from the previous page is under the insert-web
| component-advanced-confirmation field. In the code, I see the
following:
|
| <!--webbot bot="ConfirmationField" S-Field="Cust_name" -->
|
| I'm not sure how to use this to populate a variable, though for a SQL
| statement. So far the wizards are making life rather difficult!
|
|
|
|
|
| | > Look at http://www.frontpagehowto.com/Add_Shipper.htm
| > Or to get form field values (form field name: Cust_name) to a page w/
ASP
| > use
| > Request.QueryString("Cust_name")
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | I am admittedly new to this sort of thing so I'll explain what I'm
| > trying to
| > | do in Frontpage XP:
| > |
| > | I have a page with a form intended to collect information from the
user.
| > | Upon pressing save, the form posts the information to a SQL server
| > database.
| > | This all works fine.
| > |
| > | Then, a confirmation page is supposed to come up and show the fields
| > from
| > | the newly saved database. However, when I setup the confirmation
page,
| > I
| > | can't get the database results region to select only the record that
was
| > | just saved. Upon looking further, I noticed that using
| > request("Cust_name")
| > | shows nothing. I believe it should be retrieving the form field
from
| > the
| > | previous page, which has a field of the same name.
| > |
| > | The problem is that the SQL server will do some calcs on the server
side
| > so
| > | I want to show the fields.....how can I pass the parameter from the
| > first
| > | ASP page to the next for use as a SQL statement parameter? So far,
all
| > | attempts to get the parameter information return blanks.
| > |
| > | I'll pass code on if it's helpful.
| > |
| > | thanks in advance!
| > |
| > |
| >
| >
|
|