[FX.php List] Script executes, but hangs web page

[Jon & Jane Montgomery]

Bradley,
    All of my experience with FX.PHP and the web are related to my real job
in education, and I have not always practiced what I am about to preach.
But having read almost every post on this site since I started work with FX
three or more years ago, I have picked up a lot of good information, but
because of my real job in life, teaching kids music, have not had time to
use them all, yet.  So here are a couple of things to think about and then
some of the true geniuses on here, and they are geniuses, will give you more
detailed or better ways.

    I learned from my first time using FX.PHP that Global fields from
FileMaker do not work well on the web, sometimes not at all, so I have I
have always avoided them like the plague. So there are ways around that to
accomplish the same thing as a Global field.

    I have also learned from the real geniuses here, but still do not
practice this as of yet, that it is not the always the best thing to let web
users delete anything in your database.  But as an alternative, MARK them
for deletion by setting a field.  It is my understanding then you hide those
records from the user, so the appear deleted, and then you, or the database
administer routinely deletes those records.  As I understand it, that will
keep the web user from deleting records that really should not be deleted.
Again, I have not put that into practice in my own system yet.  My apologies
to Tim ³Webko² Booth, it is on the list just have not gotten to it yet. ;-)

    As to the hang your are getting, my guess is that the global the
problem.  If I am wrong, someone will correct me.

Jon Montgomery, soon to be retired middle school band director hoping to
turn FileMaker/Web developer


On 10/29/10 6:32 PM, "Bradley Creamer" <creamerbradley at fhda.edu> wrote:

>    Hi FX folks,
>  
>  I have a script that deletes a found set of records. I've found the script
> executes fine from a Web page call, but the resulting Web page hangs, in other
> words, after many seconds, a blank page is returned.
>  
>  Having converted the database from FMP6 to FMP11/FMPSA11, I've updated the
> script to have the "Confirm" statement and I even added the "Exit Script"
> directive after that; still it hangs.
>  
>  But, again, the script does execute in the background, deleting all found
> records, so I'm pretty sure I have the permissions set correctly. However, I
> set a global field to capture script results (as stated in the "Exit Script"
> directive) but nothing is captured.
>  
>  So, it's deleting the found records, not returning the result, and hangs the
> Web page. 
>  
>  Any thoughts? Below is the script in it's entirety.
>  
>  Thanks for any and all help,
>  Bradley
>  
>  **************** Script:
>  
>  Delete All Records [No dialog]
>  Commit Records/Requests [Skip data entry validation; no dialog]
>  Exit Script [Result: "All Deleted"]
>  
>  
>  
>  
>  
>  
>  
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20101029/773c1ef9/attachment-0001.html