Request statement question

I

Ian

I have a minor irritation with FP2003 and was wondering if anybody can help, I have added the line below to a HTML page:
The results of your search for <%=Request("AZ")%> are:The value for AZ is passed from another sheet and used to filter data from a database, this works OK and the data is returned.The problem is that the request statement is not picking up the value and just returns the above line. I've tried changing the " to ',this didn't work. I have put the Request statement in a text box and this populated the request with the correct value, only problemis the text box doesn't look right, I've changed the colours for the background and text, but the field is always surrounded by the border.Does anybody know how to remove the border on a text box or know hot to get the above statement to work as straight HTML?Many thanksIan
 
K

Kathleen Anderson [MVP - FP]

There are a couple of things that I can think of that might be causing
this - without seeing the HTML for the page, it's really hard to day.
First, the page needs to be an ASP page, not HTML. Second, the statement you
are adding must be outside both the Database Results Region and the Form (if
you have one on the page).
 
C

clintonG

It can also be a matter of assigning the value of the parameter to a
variable and then passing the variable to the object.

Dim sQsParameter
sQsParameter = "AZ"
SomeObject(sQsParameter)

SELECT *
FROM SomeTable
WHERE SomeColumn = ' sQsParameter '

As for the border on the textbox I would suggest you continue to
hunt the FrontPage user interface or over-ride whatever FrontPage
seems to be doing by using a CSS stylesheet, embed, or write an
inline style declaration for the textbox where you can determine if
the border-style:none; attribute in the declaration will resolve the
border you observe.

CSS Reference
http://javascriptkit.com/dhtmltutors/cssreference.shtml

I have no idea how to understand what you mean by asking
"how to get the above statement to work as straight HTML."

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/
 
I

Ian

I resolved the problem below using the following code, works fine!

<% Dim x
x =Request("AZ")%>
<p style="margin-top: 0; margin-bottom: 6px">The results of your search for&nbsp;<% =x %>
are:</p>

I have a minor irritation with FP2003 and was wondering if anybody can help, I have added the line below to a HTML page:
The results of your search for <%=Request("AZ")%> are:The value for AZ is passed from another sheet and used to filter data from a database, this works OK and the data is returned.The problem is that the request statement is not picking up the value and just returns the above line. I've tried changing the " to ',this didn't work. I have put the Request statement in a text box and this populated the request with the correct value, only problemis the text box doesn't look right, I've changed the colours for the background and text, but the field is always surrounded by the border. Does anybody know how to remove the border on a text box or know hot to get the above statement to work as straight HTML? Many thanks Ian
 
Top