I have an application running on FreeBSD Unix that is running just fine. I want to move it to an ubuntu server (11.10).
The query resides in a function that looks up a permit using the permit number. I call the function with the permit number. If the query returns no result, everything works.
If the query returns a result, strange things happen.
Run from the CLI, the script will display the results, but will NOT return from the function. It just ends when the function ends.
Run from a web browser, it returns an undefined response code.
If I move the query from the function into the main code, the script continues until the end in CLI, but still returns an undefined response code in a web browser.
I have another script on the same machine that query's another mssql server that works just fine - no problems whatsoever in either CLI or from a web browser.
As I don't have much hair left to pull out, please accept my thanks in advance.