Database Search Box problem

[Ian Bull]

1. I have asked FrontPage to generate a Database Results Display form
preceded by a Query box - all linked to an existing database.

It has done this with no error messages, producing the following code for
the Query box -

<form BOTID="0" METHOD="POST" ACTION="Database%20AllCaptures.asp">
<table BORDER="0">
<tr>
<td><b>Surname</b></td>
<td>
<input TYPE="TEXT" NAME="Surname" VALUE="<%=Request("Surname")%>"
size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --></p>
<p>&nbsp;</p>
</form>

however when this is previewed it displays as -

Surname " size="20">


which suggests to me, with almost non-existent knowledge of HTML that there
is a problem with the code generated.

2. When following the wizard producing the Results & Query/Search forms I am
not clear about what I should entry in the 'Value' box - when I enter
'Surname' as above the wizard puts that to the left of the query entry box
and superficially that seems fine however I suspect I simply haven't got the
concept of what should be entered here.

Any assistance much appreciated.

Thank you & Regards
Ian Bull

 

[Kathleen Anderson [MVP - FP]]

Are you using the Preview tab at the bottom of the screen? Try using Preview
in Browser instead.

 

[Ian Bull]

Kathleen - many thanks for the prompt response.

I get the same in 'Preview' & 'Preview in Browser' i.e. -
Surname " size="20">

In 'Normal' I get - Surname " size="20">

only difference being 'Surname' is bold in the first.

Incidentally - in 'Preview in Browser' I also get the following which appears to be unrelated but no doubt an upcoming problem -

The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.

The page is a .asp

Thank you & Regards
Ian Bull

Are you using the Preview tab at the bottom of the screen? Try using Preview
in Browser instead.

 

[Kathleen Anderson [MVP - FrontPage]]

And is the web on a server that supports Active Server Pages? In order for
this to work, you need to be able to open the web via http:// from a server.
--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Ian Bull]

Kathleen,

Thanks - it appears our ISP's web server is Apache & does not support Active
Server Pages. They tell me I will need MySQL which will be a whole new
ballgame!

Regards
Ian Bull

message And is the web on a server that supports Active Server Pages? In order for
this to work, you need to be able to open the web via http:// from a server.
--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/