pass database result field

S

Sharon Gano

I've written the following code to extract a phone from my database. I want
to pass this field to the order form. However, I also need to send the price
field too. Any ideas how to send both fields at the same time? I want to
click "Add to Order" and send both fields to the order form. See code below:

<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="_private/form_results.csv"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<p>
<input type="hidden" name="modelname" size="50"
value="<%=fp_rs("modelname")%>">
<input type="submit" value="Add to Order" name="B1"></br>
</form>
 
S

Stefan B Rusynko

Your form is sending to a text file (.csv) if that is what you mean by sending both fields to the order form

Just add your price field from your database as you have your hidden modelname field

--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've written the following code to extract a phone from my database. I want
| to pass this field to the order form. However, I also need to send the price
| field too. Any ideas how to send both fields at the same time? I want to
| click "Add to Order" and send both fields to the order form. See code below:
|
| <form method="POST" action="--WEBBOT-SELF--">
| <!--webbot bot="SaveResults" U-File="_private/form_results.csv"
| S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| <p>
| <input type="hidden" name="modelname" size="50"
| value="<%=fp_rs("modelname")%>">
| <input type="submit" value="Add to Order" name="B1"></br>
| </form>
 
S

Sharon Gano

That was the next piece of the puzzle....sending to the order page
(order.asp) instead of a text file. Do you know how I make that change?
 
S

Stefan B Rusynko

Just change your form properties to send to other and add the asp page as the destination
- But then your receiving page (order.asp) will need to be hand coded to do something w/ it
Suggest you either use a commercial cart application or start learning ASP

--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| That was the next piece of the puzzle....sending to the order page
| (order.asp) instead of a text file. Do you know how I make that change?
|
| "Stefan B Rusynko" wrote:
|
| > Your form is sending to a text file (.csv) if that is what you mean by sending both fields to the order form
| >
| > Just add your price field from your database as you have your hidden modelname field
| >
| > --
| >
| > _____________________________________________
| > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | I've written the following code to extract a phone from my database. I want
| > | to pass this field to the order form. However, I also need to send the price
| > | field too. Any ideas how to send both fields at the same time? I want to
| > | click "Add to Order" and send both fields to the order form. See code below:
| > |
| > | <form method="POST" action="--WEBBOT-SELF--">
| > | <!--webbot bot="SaveResults" U-File="_private/form_results.csv"
| > | S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| > | <p>
| > | <input type="hidden" name="modelname" size="50"
| > | value="<%=fp_rs("modelname")%>">
| > | <input type="submit" value="Add to Order" name="B1"></br>
| > | </form>
| >
| >
| >
 
S

Sharon Gano

Hi Stefan. Thanks for your response. Ok, I've written the following code to
retrieve the model name from the database and pass it to the order form (see
below). The order form has a field for receiving the model name. However,
I'd like to pass the model name to the order form, but go to the rateplan.asp
page next. Can I do that, or do I have to pass the model name to the rate
plan page and then pass both the model name and rate plan to the order page?
You can see my application at http://www.estreetbetatest.com. Thanks!

<form onSubmit="return false">
<input type="button" value="Add to Order"
onClick="window.location.href='order.asp?' + this.form.modelname.value"
style="font-size: 8pt; color: #148AB2; font-weight: bold">
<input type="hidden" name="modelname" size="50"
value="<%=fp_rs("modelname")%>">
</form>

Stefan B Rusynko said:
Just change your form properties to send to other and add the asp page as the destination
- But then your receiving page (order.asp) will need to be hand coded to do something w/ it
Suggest you either use a commercial cart application or start learning ASP

--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| That was the next piece of the puzzle....sending to the order page
| (order.asp) instead of a text file. Do you know how I make that change?
|
| "Stefan B Rusynko" wrote:
|
| > Your form is sending to a text file (.csv) if that is what you mean by sending both fields to the order form
| >
| > Just add your price field from your database as you have your hidden modelname field
| >
| > --
| >
| > _____________________________________________
| > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | I've written the following code to extract a phone from my database. I want
| > | to pass this field to the order form. However, I also need to send the price
| > | field too. Any ideas how to send both fields at the same time? I want to
| > | click "Add to Order" and send both fields to the order form. See code below:
| > |
| > | <form method="POST" action="--WEBBOT-SELF--">
| > | <!--webbot bot="SaveResults" U-File="_private/form_results.csv"
| > | S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| > | <p>
| > | <input type="hidden" name="modelname" size="50"
| > | value="<%=fp_rs("modelname")%>">
| > | <input type="submit" value="Add to Order" name="B1"></br>
| > | </form>
| >
| >
| >
 
S

Stefan B Rusynko

Suggest again you start learning ASP or use a commercial cart

The below passes modelname to order.asp w/o exposing the parameter to the user for change

<form action"order.asp" method="Post">
<input type="Submit" value="Add to Order">
<input type="hidden" name="modelname" size="50" value="<%=fp_rs("modelname")%>">
</form>

You could just as well pass to rateplan and from there pass more info to order

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi Stefan. Thanks for your response. Ok, I've written the following code to
| retrieve the model name from the database and pass it to the order form (see
| below). The order form has a field for receiving the model name. However,
| I'd like to pass the model name to the order form, but go to the rateplan.asp
| page next. Can I do that, or do I have to pass the model name to the rate
| plan page and then pass both the model name and rate plan to the order page?
| You can see my application at http://www.estreetbetatest.com. Thanks!
|
| <form onSubmit="return false">
| <input type="button" value="Add to Order"
| onClick="window.location.href='order.asp?' + this.form.modelname.value"
| style="font-size: 8pt; color: #148AB2; font-weight: bold">
| <input type="hidden" name="modelname" size="50"
| value="<%=fp_rs("modelname")%>">
| </form>
|
| "Stefan B Rusynko" wrote:
|
| > Just change your form properties to send to other and add the asp page as the destination
| > - But then your receiving page (order.asp) will need to be hand coded to do something w/ it
| > Suggest you either use a commercial cart application or start learning ASP
| >
| > --
| >
| > _____________________________________________
| > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | That was the next piece of the puzzle....sending to the order page
| > | (order.asp) instead of a text file. Do you know how I make that change?
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Your form is sending to a text file (.csv) if that is what you mean by sending both fields to the order form
| > | >
| > | > Just add your price field from your database as you have your hidden modelname field
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > | I've written the following code to extract a phone from my database. I want
| > | > | to pass this field to the order form. However, I also need to send the price
| > | > | field too. Any ideas how to send both fields at the same time? I want to
| > | > | click "Add to Order" and send both fields to the order form. See code below:
| > | > |
| > | > | <form method="POST" action="--WEBBOT-SELF--">
| > | > | <!--webbot bot="SaveResults" U-File="_private/form_results.csv"
| > | > | S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| > | > | <p>
| > | > | <input type="hidden" name="modelname" size="50"
| > | > | value="<%=fp_rs("modelname")%>">
| > | > | <input type="submit" value="Add to Order" name="B1"></br>
| > | > | </form>
| > | >
| > | >
| > | >
| >
| >
| >
 
S

Sharon Gano

Hi Stefan. I'll give this a try, thanks!
Do you have recommendations for any good self-help ASP books? :)

Stefan B Rusynko said:
Suggest again you start learning ASP or use a commercial cart

The below passes modelname to order.asp w/o exposing the parameter to the user for change

<form action"order.asp" method="Post">
<input type="Submit" value="Add to Order">
<input type="hidden" name="modelname" size="50" value="<%=fp_rs("modelname")%>">
</form>

You could just as well pass to rateplan and from there pass more info to order

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi Stefan. Thanks for your response. Ok, I've written the following code to
| retrieve the model name from the database and pass it to the order form (see
| below). The order form has a field for receiving the model name. However,
| I'd like to pass the model name to the order form, but go to the rateplan.asp
| page next. Can I do that, or do I have to pass the model name to the rate
| plan page and then pass both the model name and rate plan to the order page?
| You can see my application at http://www.estreetbetatest.com. Thanks!
|
| <form onSubmit="return false">
| <input type="button" value="Add to Order"
| onClick="window.location.href='order.asp?' + this.form.modelname.value"
| style="font-size: 8pt; color: #148AB2; font-weight: bold">
| <input type="hidden" name="modelname" size="50"
| value="<%=fp_rs("modelname")%>">
| </form>
|
| "Stefan B Rusynko" wrote:
|
| > Just change your form properties to send to other and add the asp page as the destination
| > - But then your receiving page (order.asp) will need to be hand coded to do something w/ it
| > Suggest you either use a commercial cart application or start learning ASP
| >
| > --
| >
| > _____________________________________________
| > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | That was the next piece of the puzzle....sending to the order page
| > | (order.asp) instead of a text file. Do you know how I make that change?
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Your form is sending to a text file (.csv) if that is what you mean by sending both fields to the order form
| > | >
| > | > Just add your price field from your database as you have your hidden modelname field
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > | I've written the following code to extract a phone from my database. I want
| > | > | to pass this field to the order form. However, I also need to send the price
| > | > | field too. Any ideas how to send both fields at the same time? I want to
| > | > | click "Add to Order" and send both fields to the order form. See code below:
| > | > |
| > | > | <form method="POST" action="--WEBBOT-SELF--">
| > | > | <!--webbot bot="SaveResults" U-File="_private/form_results.csv"
| > | > | S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| > | > | <p>
| > | > | <input type="hidden" name="modelname" size="50"
| > | > | value="<%=fp_rs("modelname")%>">
| > | > | <input type="submit" value="Add to Order" name="B1"></br>
| > | > | </form>
| > | >
| > | >
| > | >
| >
| >
| >
 
S

Sharon Gano

Stefan, it works!!!! I can't thank you enough. Please, take a
look...http://www.estreetbetatest.com. I don't think I could have pulled
this off without your help!

Hey, do you know how to disable the back button per chance? I want to force
users to utilize the menu from the order page. Thanks :)

Stefan B Rusynko said:
Suggest again you start learning ASP or use a commercial cart

The below passes modelname to order.asp w/o exposing the parameter to the user for change

<form action"order.asp" method="Post">
<input type="Submit" value="Add to Order">
<input type="hidden" name="modelname" size="50" value="<%=fp_rs("modelname")%>">
</form>

You could just as well pass to rateplan and from there pass more info to order

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi Stefan. Thanks for your response. Ok, I've written the following code to
| retrieve the model name from the database and pass it to the order form (see
| below). The order form has a field for receiving the model name. However,
| I'd like to pass the model name to the order form, but go to the rateplan.asp
| page next. Can I do that, or do I have to pass the model name to the rate
| plan page and then pass both the model name and rate plan to the order page?
| You can see my application at http://www.estreetbetatest.com. Thanks!
|
| <form onSubmit="return false">
| <input type="button" value="Add to Order"
| onClick="window.location.href='order.asp?' + this.form.modelname.value"
| style="font-size: 8pt; color: #148AB2; font-weight: bold">
| <input type="hidden" name="modelname" size="50"
| value="<%=fp_rs("modelname")%>">
| </form>
|
| "Stefan B Rusynko" wrote:
|
| > Just change your form properties to send to other and add the asp page as the destination
| > - But then your receiving page (order.asp) will need to be hand coded to do something w/ it
| > Suggest you either use a commercial cart application or start learning ASP
| >
| > --
| >
| > _____________________________________________
| > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | That was the next piece of the puzzle....sending to the order page
| > | (order.asp) instead of a text file. Do you know how I make that change?
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Your form is sending to a text file (.csv) if that is what you mean by sending both fields to the order form
| > | >
| > | > Just add your price field from your database as you have your hidden modelname field
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > | I've written the following code to extract a phone from my database. I want
| > | > | to pass this field to the order form. However, I also need to send the price
| > | > | field too. Any ideas how to send both fields at the same time? I want to
| > | > | click "Add to Order" and send both fields to the order form. See code below:
| > | > |
| > | > | <form method="POST" action="--WEBBOT-SELF--">
| > | > | <!--webbot bot="SaveResults" U-File="_private/form_results.csv"
| > | > | S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| > | > | <p>
| > | > | <input type="hidden" name="modelname" size="50"
| > | > | value="<%=fp_rs("modelname")%>">
| > | > | <input type="submit" value="Add to Order" name="B1"></br>
| > | > | </form>
| > | >
| > | >
| > | >
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top