A
Augie Dawg
A few weeks ago I created a few test records with some new data manipulation
screens I had created using the DRW in FP 2002. When I went to delete the
test records, I got an error message indicating "internal server error".
Knowing that this delete function had worked flawlessly in the past, I
started stripping out parts of the page, then parts of the custom query
code, only to discover that the addition of an "AS" clause in the SELECT
statement was causing the failure. I then went on to discover that EVERY
SELECT statement in my whole site with an AS clause was also failing. When
I contacted tech support at my hosting provider, they suggested my code was
at fault, which is hard to believe, since code that had worked for the last
two years was now failing consistently. Tech support then suggested
uninstalling and reinstalling FP extensions. That made matters worse, as
now I can't even get to the DB pages, as I first get challenged for a
password at my main menu of available functions (which is consistent with
past behavior), enter my user name and password to successfully get to the
next screen, then get challenged again, which never happened before.
Any ideas what could cause all DRW-generated code to fail on the AS clause?
Thanks
A.D.
screens I had created using the DRW in FP 2002. When I went to delete the
test records, I got an error message indicating "internal server error".
Knowing that this delete function had worked flawlessly in the past, I
started stripping out parts of the page, then parts of the custom query
code, only to discover that the addition of an "AS" clause in the SELECT
statement was causing the failure. I then went on to discover that EVERY
SELECT statement in my whole site with an AS clause was also failing. When
I contacted tech support at my hosting provider, they suggested my code was
at fault, which is hard to believe, since code that had worked for the last
two years was now failing consistently. Tech support then suggested
uninstalling and reinstalling FP extensions. That made matters worse, as
now I can't even get to the DB pages, as I first get challenged for a
password at my main menu of available functions (which is consistent with
past behavior), enter my user name and password to successfully get to the
next screen, then get challenged again, which never happened before.
Any ideas what could cause all DRW-generated code to fail on the AS clause?
Thanks
A.D.