Date:  09/20/2007 07:58:04 AM Msg ID:  003515
From:  George Gambill Thread:  003510
Subject:  Re: DemoNameSearch Source Code Fails
I am not finding a fwx\NameSearch sub-folder, or a fwx\ sub-folder for that matter.  We did just buy (by credit card) the package yesterday (9/19) and your folks informed us that we would receive something in the next few days.  Maybe we need to do something with whatever we will receive shortly.

In the mean time, I installed the 3.x.x eval download to c:\Program Files\FoxWeb3 so as to not fight with your 4 Beta version which I had installed to c:\Program Files\FoxWeb. 

Long story short ... my  c:\Program Files\FoxWeb3 directory has only two subfolders (Docs and Static) and I'm not finding a fwx\ subfolder anywhere.

In hopes of making our friday efforts as productive as possibel, are these sorce file files availavle on the web?  

TIA

George
Sent by FoxWeb Support on 09/19/2007 09:11:56 PM:
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
support@foxweb.com email
Sent by George Gambill on 09/19/2007 02:52:45 PM:
Unable to get the DemoNameSearch source code (from ://www.foxweb.com/DemoNameSearch.asp ) 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.

Help!!!

The Html used is a follows:

<html>
<head>
<title>Name Search</title>
</head>
<body>
<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">
Name:
<input name="name" maxlength="30" value="<%=Request.Form("name")%>">
<input type="submit" value="Search">
</form>
<hr>
<%
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><%
        SCAN
            Response.Write(results.name + "<br>")
        ENDSCAN
    ELSE
        %><h3>Your Search Yielded No Results</h3><%
    ENDIF
ENDIF
%>
</body>
</html>