Button - Hyperlink

The Button properties allow setting a hyperlink. When you mouse over the Button the hyperlink is displayed but clicking on the Button does nothing. What else do I need to do? I want to send a user filled field (zip code) as a property, to my .ASP to match near by vendors. Everything works if I use a click here line. The Buttons look a lot better.
DonH040699Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mgoergenCommented:
Please add your html code, then I will have a look at it
0
jgoodierCommented:
the page with the textbox1 should point to thepage.asp
on the next page, you should have in the sql "where zip="&request.querystring("textbox1")
can you give the url?
0
DonH040699Author Commented:
The problem is with the first page. It never calls the second page. Clicking on a button won't follow the hyperlink the button shows. I was just hoping there was a simple way to have the button use the hyperlink property. Could I submit to a conformation page to call my next page with parameters?
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

MarineCommented:
I don't understand this question. The process is the same. You send the value taken from the zip field. To get that value you use request.querystring(parametername).
0
jgoodierCommented:
the form action should look like this
<form method="post" action="secondpage.asp">
enter your zip code: <input type="textbox">
<input type="submit" value="submit">
</form>
0
bigelosCommented:
Copy and paste the HTML code and your question will be answered.
0
DonH040699Author Commented:
Here is the code:
 <form method="POST" action="--WEBBOT-SELF--" target="_top" onSubmit="referralbody.asp" name="zip">
    <!--webbot bot="SaveResults" S-Label-Fields="TRUE"
    B-Reverse-Chronology="FALSE" S-Builtin-Fields S-Form-Fields="zip "
    U-Confirmation-Url U-File="zipforref.txt" S-Format="HTML/BR" -->
When I try to change action="--WEBBOT-SELF--" to action="referralbody.asp", it changes back by itself!
0
SiteSeeCommented:
strip out ALL that web-bot stuff and it'll work great...
in Form properties...instead of clicking the first option...click the one that says..:
Send to Other...and in Options...put referralbody.asp
in Advanced...make sure you are POSTing the text field...
click OK...done...

Steve
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SiteSeeCommented:
I didn't mean advanced...I should've looked before I blabbed...
The METHOD field in the Options part is where you specify POST...
if you want to pass Hidden form field values to the receiving asp page, like FormName, or Timestamp, or whatever put it in Advanced...

Steve
0
DonH040699Author Commented:
This now gets me to referralbody.asp when I click the submit button.
<form method="POST" action="referralbody.asp" target="_top" onSubmit="referralbody.asp" name="Zip">
    <div align="left">
      <table border="0" width="99%">
        <tr>
          <td width="35%">
            <p align="right"><font color="#808000">Please enter a zip code </font></td>
          <td width="10%"><!--webbot bot="Validation" S-Display-Name="Zip Code"
            S-Data-Type="String" B-Allow-Digits="TRUE" B-Value-Required="TRUE"
            I-Minimum-Length="5" I-Maximum-Length="5" --><input type="text" name="zip" size="15" maxlength="5"></td>
          <td width="30%" valign="bottom">
            <input type="submit" value="Submit" name="B3"> <input type="reset" value="Reset" name="B2">
          </td>
My query string in referralbody.asp contains WHERE Zip=zip and verifies.
The list shows all records matching or not. As my original question is answered, I could post this as another.
0
SiteSeeCommented:
I'd need to see your whole SQL query to tell you what's wrong with it..
but try
Where Zip LIKE (<%ZIP%
instead of...
   Where Zip= (<%ZIP%>

Steve
0
DonH040699Author Commented:
Adjusted points to 150
0
DonH040699Author Commented:
Here's the sql line:
fp_sQry="SELECT * FROM Attorney WHERE Zip LIKE zip"
It still lists all records.
0
jgoodierCommented:
you probably should do
where zip > zip-500 AND zip < zip +500
0
SiteSeeCommented:
As written above, that should work...
you may want to add an Order By DESC to the end of it to sort  alphabetically..but only do this in the databasase region properties gui interface...your code will be re-written by FP everytime if you try to do it in HTML view..

If you are getting ALL records in that table, then you can try this:

in access, make a query that ONLY queries the zip fields in the table you want to query from on the web...
....and in FP, when you are selecting the source table/query from which to query, select the new Query you made...instead of the table itself...don't ask me why, but this has helped me immensely when fighting it out with FP...

Steve
0
DonH040699Author Commented:
I tried both suggestions with no success. It still shows all records. Should I append a parameter to referralbody.asp like: ?zip=zip
0
SiteSeeCommented:
Shouldn't be necessary...

only if your method is GET do you append in a string...

can you post your entire code for the referralbody.asp please...?

Steve
0
DonH040699Author Commented:
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Attorney List</title>
</head>

<body bgcolor="#F0F1BC">

<h1><font color="#008000">Select an Attorney.</font> </h1>
<p><font color="#808000">You can select as many Attorneys to speak with as you
like. Click on a name to select. </font></p>

<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-columntypes="200,200,200,200,200,200,200,200,200,200,200,200"
s-dataconnection="Alist" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice="F_Name" s-menuvalue="F_Name" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="TRUE" s-recordsource
s-displaycolumns="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-criteria s-order s-sql="SELECT Attorney.F_Name,Attorney.M_Name, Attorney.L_Name, Attorney.Address, Attorney.Address2, Attorney.City, Attorney.State, Attorney.Zip, Attorney.Area_Code, Attorney.Phone, Attorney.Fax, Attorney.Email<br>FROM Attorney<br>WHERE (((Attorney.Zip)=&quot;zip&quot;));<br>"
b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="0"
BOTID="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY"
local_preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;Database Results regions will not preview unless this page is fetched from a Web server using a web browser. The section of the page from here to the end of the Database Results region will repeat once for each record returned by the query.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
b-WasTableFormat="FALSE" b-ReplaceDatabaseRegion="FALSE" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT Attorney.F_Name,Attorney.M_Name, Attorney.L_Name, Attorney.Address, Attorney.Address2, Attorney.City, Attorney.State, Attorney.Zip, Attorney.Area_Code, Attorney.Phone, Attorney.Fax, Attorney.Email FROM Attorney WHERE (((Attorney.Zip)=""zip"")); "
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Alist"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="F_Name"
fp_sMenuValue="F_Name"
fp_iDisplayCols=12
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="13942" endspan -->
<p style="margin-left: 0; margin-right: 0; margin-top: 2; margin-bottom: 2"><b>Name:</b><a href="alist.asp">&nbsp;<!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="F_Name" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;F_Name&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;F_Name&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"F_Name")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="13457" endspan -->
 &nbsp;<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="M_Name" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;M_Name&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;M_Name&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"M_Name")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="13905" endspan -->
 &nbsp;<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="L_Name" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;L_Name&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;L_Name&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"L_Name")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="13841" endspan -->
</a></p>
<p style="margin-left: 0; margin-right: 0; margin-top: 2; margin-bottom: 2"><b>Address:</b>&nbsp;<!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="Address" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Address&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Address&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"Address")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="12103" endspan -->
</p>
<p style="margin-left: 0; margin-right: 0; margin-top: 2; margin-bottom: 2"><b>Address2:</b>&nbsp;<!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="Address2" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Address2&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Address2&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"Address2")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="12778" endspan -->
</p>
<p style="margin-left: 0; margin-right: 0; margin-top: 2; margin-bottom: 2"><b>City:</b>&nbsp;<!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="City" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;City&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;City&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"City")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="4267" endspan -->
 <b>State:</b>&nbsp;<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="State" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;State&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;State&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"State")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="10114" endspan -->
 <b>Zip:</b>&nbsp;<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="Zip" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Zip&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Zip&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"Zip")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="3973" endspan -->
</p>
<p style="margin-left: 0; margin-right: 0; margin-top: 2; margin-bottom: 2"><b>Area
Code:</b>&nbsp;<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="Area_Code" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Area_Code&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Area_Code&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"Area_Code")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="19259" endspan -->
 <b>Phone:</b>&nbsp;<!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="Phone" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Phone&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Phone&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"Phone")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="8388" endspan -->
</p>
<p style="margin-left: 0; margin-right: 0; margin-top: 2; margin-bottom: 2"><b>Fax:</b>&nbsp;<!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="Fax" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Fax&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Fax&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"Fax")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="1677" endspan -->
</p>
<p style="margin-left: 0; margin-right: 0; margin-top: 2; margin-bottom: 2"><b>Email:</b>&nbsp;<!--webbot
bot="DatabaseResultColumn" startspan
s-columnnames="F_Name,M_Name,L_Name,Address,Address2,City,State,Zip,Area_Code,Phone,Fax,Email"
s-column="Email" b-tableformat="FALSE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Email&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Email&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"Email")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="8328" endspan -->
</p>
<hr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
tag="BODY"
local_preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End of Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->

<p style="margin-top: 4; margin-bottom: 0"><font color="#000000" size="1">(c)Copyright
2000 Donald F. Holthe,</font></p>
<p style="margin-top: 4; margin-bottom: 0"><font color="#000000" size="1">all
rights reserved.</font></p>

</body>

</html>
0
SiteSeeCommented:
there's nothing wrong with that query...
it should be working...
....are you ABSOLUTELY sure that the preceding pages field is named "zip"...and that there are not any extra spaces in it..etc..?
0
DonH040699Author Commented:
I let FP do the query by record. It used (zip='::zip::'). Now it works! Thanks to all who helped with their input and a special thanks to Steve who answered my original question and more.
0
SiteSeeCommented:
no problem..forgot about FP preferring those object enclosers best... "::"

Cheers...

Steve
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.