|
| |
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
 |
Confirmation fields on a results page? - 10/3/2003 22:43:05
I'm using DRW (thank you, Spooky - your tutorials have helped immensely!!) and I have the results on a page separate from the search. I'd like to be able to show at the top of the results page what their search criteria was. I tried using confirmation fields, but that didn't work. 
The search page is at Search1
The form properties on this page are "Send to Other: Custom ISAPI.... ASP Script" and under Options, it has "Action: results1.asp" and "Method; POST"
Thanks for any suggestions you might offer. I appreciate all your help!
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
|
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/3/2003 23:45:53
What is the name of the search variable that you are passing to the result page?
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 0:45:43
I went into your results page and found the code.
I added some asp lines to your existing lines.
Here it is...
Find this area of your page and replace the existing code with this:
<tr>
<td width="562"><!--mstheme--><font face="Verdana, Arial, Helvetica">
<p style="line-height: 100%; margin: 0">From: <%=Request.Form ("From")%> To: <%=Request.Form ("To")%>
</p>
<p style="line-height: 100%; margin: 0">
Bedroom: <%=Request.Form ("Bedrooms")%></p>
<p style="line-height: 100%; margin: 0">
Bathrooms: <%=Request.Form ("Bathrooms")%></p>
<p style="line-height: 100%; margin: 0">Area(s): <%=Request.Form ("Areas")%>
<!--mstheme--></font></td>
</tr>
< Message edited by Long Island Lune -- 10/4/2003 12:46:46 AM >
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 0:51:46
quote:
Is there a simple way to get the values that the visitor enters to stay in the search box when it brings up the results? When I had them on one page (originally), after pressing submit, my results came up OK but the search box reverted to the default values and I thought it would confuse my visitors. (Many of our visitors aren't very 'techie' yet.)
Do you mean once a search has completed and your ON the RESULTS page, and you want to go back to the SEARCH page?
< Message edited by Long Island Lune -- 10/4/2003 12:52:31 AM >
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 0:55:53
quote:
Find this area of your page and replace the existing code with this:
If you can't find this code, you'll have to email me the entire page.
_____________________________
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 18:34:04
Hi again. I'm afraid I have a new problem. I can't get a form to work on the bottom of the results page - http://www.wesellstlouis.com/test/results3.asp
Is it a problem to have a FrontPage form on an .asp page? If so, then I'll have to come up with an alternative. In case that's not the problem, the code for the form is as follows:
quote:
<td width="562" bordercolorlight="#90B09C" bordercolor="#90B09C" bordercolordark="#90B09C"><form method="POST" action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)" name="FrontPage_Form1">
<!--webbot bot="SaveResults" startspan
U-File="_private/homedetails.txt" S-Format="TEXT/CSV"
S-Label-Fields="TRUE" B-Reverse-Chronology="FALSE"
S-Email-Format="TEXT/PRE"
S-Email-Address="penny@wesellstlouis.com"
B-Email-Label-Fields="TRUE"
B-Email-ReplyTo-From-Field="TRUE"
S-Email-ReplyTo="email"
B-Email-Subject-From-Field="FALSE"
S-Email-Subject="Homeowner Search Request"
S-Date-Format="%m/%d/%Y" S-Time-Format="%H:%M"
S-Builtin-Fields="REMOTE_NAME REMOTE_USER HTTP_USER_AGENT Date Time"
S-Form-Fields="ML1 ML2 ML3 email phone " --><strong>[FrontPage Save Results Component]</strong><!--webbot
bot="SaveResults" endspan -->
<p style="line-height: 100%; margin: 0"><font size="2" color="#333300">Want
more details? Fill out this simple form:</font></p>
<p style="line-height: 100%; margin: 0"><font size="2" color="#333300"><!--webbot
bot="Validation" S-Data-Type="Integer"
S-Number-Separators="x" B-Value-Required="TRUE"
I-Minimum-Length="6" I-Maximum-Length="6" --><input type="text" name="ML1" size="6" maxlength="6">
Listing
Number</font></p>
<p style="line-height: 100%; margin: 0"><font size="2" color="#333300"><!--webbot
bot="Validation" S-Data-Type="Integer"
S-Number-Separators="x" B-Value-Required="TRUE"
I-Minimum-Length="6" I-Maximum-Length="6" --><input type="text" name="ML2" size="6" maxlength="6">
Listing
Number</font></p>
<p style="line-height: 100%; margin: 0"><font size="2" color="#333300"><!--webbot
bot="Validation" S-Data-Type="Integer"
S-Number-Separators="x" B-Value-Required="TRUE"
I-Minimum-Length="6" I-Maximum-Length="6" --><input type="text" name="ML3" size="6" maxlength="6">
Listing
Number</font></p>
<p style="line-height: 100%; margin: 0"><font size="2" color="#333300"><!--webbot
bot="Validation" B-Value-Required="TRUE"
I-Minimum-Length="7" --><input type="text" name="email" size="20">
Your
email address</font></p>
<p style="line-height: 100%; margin: 0"><font size="2" color="#333300"><!--webbot
bot="Validation" B-Value-Required="TRUE"
I-Minimum-Length="7" --><input type="text" name="phone" size="20">
Phone
number</font></p>
<p><font size="2" color="#333300"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></font></p>
</form>
I've used forms a lot using FrontPage (and love the feature.) But does the asp extension make them unworkable? Thanks for your help!!
Hope you're having a great day.... Cheers!
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 18:51:35
Uh Ohhhh. A new problem???
This is the error I see:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '([Listing Price] >= AND [Listing Price] <= AND Bathrooms >= AND Bedrooms >= AND [Area Desc] = '' AND [Property Type] = 'RESI')'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
You CAN use a FP form on an ASP page.
No problem.
The problem is one of your values is missing...
This does not look like the same page I saw in the last problem.
Are you:
Page 1 - Excepting user SEARCH Input
Page 2 - Displaying the Results
Page 3 - Bringing them to another page after the results page.
If you are, you have to carry the values contained in your search fields to the third page.
OR..............
Is this the RESULT page we were working on last time?
Just clarify first. I work on many problems... Sometimes it hard to remember what's what.
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 19:10:42
pmagas,
Gotchya...
Okay, what do you want this form to do?
1): Save the contents in a file.
2): Jump the user to another page.
What is the problem?
1): Will not save?
2): Error on SUBMITT and will not jump to another page.
3): Values typed in are not being carried to the next page?
_____________________________
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 19:17:33
I want it to:
email contents to me
save the contents to a file (backup in case there's a problem with the email)
In other forms I've created, it automatically goes to another page - I honestly don't care. I'd rather they stay on this page, but no big deal.
It's not giving me any errors, but it's not sending the email to me. :( It's not saving it to the file either, so apparently there's a disconnect somewhere. (I've posted to it a few times to test it.) However, it has created the file.... hmmmm... ???
Thanks!!
PS - this most recent test, it still doesn't send email but it does change the page such that I get an error message. I'm thinking I should have it go to a confirmation page - and I can have another search form in that page. That way it doesn't mess up my results page. What do you think??
< Message edited by pmagas -- 10/4/2003 7:24:12 PM >
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 19:35:43
So you want it to:
1): Be saved in a file.
2): The contents emailed to you.
I'm looking into it now.
What version of FP are you using?
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 19:58:06
So am I.
One more question:
Have you ever saved files from a form on your site before? (like your trying to do now)?
_____________________________
| |
|
|
|
pmagas
Posts: 367
Joined: 3/26/2002
From: St. Louis MO USA
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 20:07:53
I wonder.....
I have this going to a subdirectory because I'm trying to test it there before having it go live. I wonder if I need to put it in the root. I think I'll try that and see if it works there. I can just move these two pages over easily enough.
I'll let you know what happens when I do that.
_____________________________
Penny
humble webmaster of
We Sell St. Louis
http://www.WeSellStLouis.com
http://www.MarkSellsStLouis.net
http://www.St-Louis-Mo.info
http://www.NealSellsStLouis.com
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 20:11:14
Okay.
That might help. Try the root.
And remember:
Permissions must be set for every directory that you want to write too. Many times sub's are not included even if you permit writing to the root.
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 22:52:12
Just got back.
I saw your latest post.
Many things.
1): You don't have to move your pages from their directory. If you want, you could put them right back where they were. It's where you tell the form to write your file too that is important. Most place them in _private. And as long as _private has permissions set to R/W/D, your fine.
2): I never use frames. AAMOF, I try to avoid them.
3): Putting the form in a pop-up window is not a bad idea. It will separate the form mechanics from the DRW mechanics on that page. Is this what you want to do?
You could place a button down near the buttom where it says; "Search Again" and that button could pop-up the window.
quote:
If I have them click for it, will the pop-up blockers mess it up?
Not sure. I guess it depends on if they have a pop-up blocker. If they do and it blocks the window, they will temporaily have to turn it off. At this stage, it's up to the user. If they want to convey additional info to you, they will have to turn it off.
You can have a window popup from a link, or button. Which do you prefer?
< Message edited by Long Island Lune -- 10/4/2003 10:53:34 PM >
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 23:09:17
Yes, nice dinner. We have the leftovers during the week!!!
Probably a button would work better. There more definable on a page than a link. But, the grey isn't the most appealing. You could start with one, and change to a graphic or a link at a later date.
Why don't you put it in a button for now.
I will provide the button for you in my code.
Are you ready for the Pop-Up code?
_____________________________
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Confirmation fields on a results page? - 10/4/2003 23:47:02
Backup the results page first in case you ever change your mind, or there are problems, or until the system is in and working correctly.
--------------------------------------------------------------------------------------------
Cut and copy the following Java code snipit, then paste it at the TOP of the page that you want to launch your pop-up from (result page). Make sure this is pasted before the <html> tag on your page.
The Java Script code:
<script TYPE="text/javascript">
<!--
function popupform(myform, windowname)
{
if (! window.focus)return true;
window.open('MYpopupPAGE.asp', windowname, 'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no, width=420,height=628');
myform.target=windowname;
return true;
}
//-->
</script>
Notes:
1): Replace the MYPopupPAGE.asp page address (above) with the page you want to appear in the pop-up window. Your making a new page right? Create the page so you have the address, then insert the address of that page in place of MYPopUpPAGE.asp.
2): If you want to alter the size of the window that pops up, change the HEIGHT and WIDTH properties to reflect the size you want your window to be.
3): If you want scrollbars to appear in the pop-up, change the SCROLLBARS=NO to YES. The same goes for RESIZABLE, etc…
The Button:
The button code below can be pasted inside your html page. Make sure you change the “MypopupPAGE.asp” with the page you want to appear in the pop-up window. It should be the SAME as the name of the new page you just created (above).
<form method="POST" action="'MYpopupPAGE.asp'" name="In1" onSubmit="popupform(this, 'join')">
<input type="submit" value="Search Again" name="B1">
</form>
Place the code (above) near the bottom of your page where you have the "Search Again" form.
You can save the page and test it now.
Once it works nice, you can remove the old (non-working) form.
On your new page:
This will be the page that will appear in the pop-up window. Do a new form. I suggest not to cut, copy and paste the old form. There is something wrong with it. This is the only area where you will have to create from scratch again. Do it like you did with all your other forms that work correctly.
This is about all there is too it.
If you decide to later put a graphic in (from your daughter), let me know and I'll give you the code to link a graphic instead.
I will be online for another 30 minutes, then machine goes off.
Post if you can, if not, I'll check tomorrow afternoon to see how things went.  
_____________________________
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
) 
(oops - forgot that before.) Most are pull-down choices; the only ones not pull-down are the price range amounts - 'From' and 'To' (yep - those are my variable names.) Believe it or not the variable names are those in my earlier post: 
Well, consider yourself hugged and kissed. 
Oh dear!! I did a google search for cyber muffins - found some recipes for blueberry muffins, etc. But it said at the top, do you mean "cybermuffins"? I clicked on it and oh, my..... that's not what I meant!! I'm so very embarrassed! 
