Re: HELP: I cannot understand this

FWX files are executed sequentially in the order they appear. In fact, they are converted to PRG files, with all static code being sent via Response.Write. If you want to see one of these PRG files, you can simply enable the Keep PRG Files option in the FoxWeb Control Center. Once you do so, delete the corresponding FXP file (to force re-compilation) and call your FWX file.

Assuming that you have none of the caveats mentioned in our previous message are the cause (mixing old-style html_out code with the new Response, Session and Auth objects, and using PUBLIC variables), then the behavior you are experiencing must be caused by a scripting bug. Try creating a copy of your main page that is as simple as possible. Ideally you will remove all code other than what's necessary to read the cookie, query the table and display the results. If you can duplicate the problem with this script, please post it here (or send it to support@foxweb.com), so that we can take a look at it.

FoxWeb Support Team
support@foxweb.com email

Sent by Bob Keller on 04/19/2005 07:08:01 PM:

I'm running FoxWeb 2.6 and am attempting to understand how this series of events can be happening with an application I was passed to re-host:

1) The first page receives a query string to extract a user's information and access level from a database.

2) This information is stored in cookies on the client's machine.

3) Each time a page is called, the values of the cookies are placed into memory variables in order to maintain the user's state throughout their session.

4) These memory variables are used throughout the application

Problem:

I've observed the following just on the FIRST page alone, and it would explain some of the problems in my previous postings to this list:

1) For debugging purposes I have the values of the cookies displayed at the bottom of each page.

2) On the initial page when it is first initiated the 'cookie' line states there are no values posted in ANY cookie.

3) Pressing 'Refresh' the values in the cookies appear, however, the username is correct, the other values do NOT match the information for that record in the database, but the first record. This data is extracted with a SQL Select statement WHERE the username=QUERYSTRING value

4) Pressing 'Refresh' a SECOND time on the SAME page, the 'cookie' line now shows all the values as they should be for that particular user.

Now I have 'inherited' this from another person who has been running it for some time with no trouble. He's been most helpful. My server's settings match his exactly, yet he's never (so he says) encountered this.

My question is: what is the 'firing order' of an FWX file. Currently, I have the first page HTML embedded at the end of FoxPro code that takes the querystring and performs validation. It appears the fox code is not firing before the HTML.