Date:  09/19/2007 09:11:56 PM Msg ID:  003511
From:  FoxWeb Support Thread:  003510
Subject:  Re: DemoNameSearch Source Code Fails
The source code must be pasted in an fwx file in the FoxWeb Program  Root, or one of its sub-folders.  You actually don’t need to get the source code from our site.  The same sample can be found in the NameSearch sub-folder of the FoxWeb Program Root (by default c:\Program Files\FoxWeb\fwx\NameSearch).
FoxWeb Support Team email
Sent by George Gambill on 09/19/2007 02:52:45 PM:
Unable to get the DemoNameSearch source code (from :// ) to work.

It blows by the <input type="submit" value="Search"> line and claims "Your Search Yielded No Results" before any names can be entered and before the search can be clicked.

Also the name object used to enter the name displays "<%=Request.Form(" when the form first comes up. Once that is cleared out and the first letter of a name is entered the pulldown does display the correct names from the table. 

We are running from the VFP 9 DLL.


The Html used is a follows:

<title>Name Search</title>
<h3>Search Criteria:</h3>
<p>This example illustrates how simple it is to write FoxWeb
applications. The code searches a FoxPro table for matches on the
name entered by the user. Partial matches also yield results. For
Example "mo" will find both "Monroe" and "Morrison." The search is
not case sensitive. To see all the names in the database just leave
the Name entry blank.</p>
<form action="NameSearch.fwx" method="post">
<input name="name" maxlength="30" value="<%=Request.Form("name")%>">
<input type="submit" value="Search">
IF Request.FormCount("name") <> 0
    SET EXACT OFF && So that partial names will work
    SELECT * FROM Names;
        WHERE UPPER(name) = UPPER(Request.Form("name"));
        ORDER BY name INTO CURSOR results
    * Check if there were any hits
    IF _TALLY > 0
        %><h3>Search Results:</h3><%
            Response.Write( + "<br>")
        %><h3>Your Search Yielded No Results</h3><%