5 Replies Latest reply on Jun 1, 2006 7:19 AM by Newsgroup_User

    POSTNETTEXT on a Mac

    Ben Danis Level 1
      I am having issues with postNetText on a Mac
      what we are doing is using PostNetText to communicate with a php/my SQL server. we make the net call using net lingo and pass a parameter list as such
      iNetId= PostNetText(phpPath, ["query": "SELECT * FROM TABLE"])
      where phpPath is the path to my php file that executes the passed query
      this works fine although exponentially slower than on a PC.
      The problem occurs when we pass queries that are longer (over 150 characters), it takes either over 40 seconds or never returns
      this has never been an issue on PC, is there a way around this without having a different php page for every query that i have to execute?

      thanks for the help
        • 1. Re: POSTNETTEXT on a Mac
          Level 7
          Hi Ben,

          Try preprocessing the data string before you pass it to the post...
          function. Build you data string and assign it to a variable. Then use
          that variable as the argument to the function.

          That will probably speed up the process for both platforms.

          --
          Rob
          _______
          Rob Dillon
          Adobe Community Expert
          http://www.ddg-designs.com
          412-243-9119

          http://www.macromedia.com/software/trial/
          • 2. Re: POSTNETTEXT on a Mac
            Ben Danis Level 1
            Thanks for the reply
            the property list that is passed as a parameter is already assigned to a variable
            I have also tried using the URLencode feature and it didn't do anything more
            • 3. Re: POSTNETTEXT on a Mac
              Level 7
              Are you using the variable in the postNetText() function? As in:

              postNetText("urlToCGI",variableName)

              If you are doing that, and you are still having a problem, then you may
              want to look at the variables and values that you are sending to the php
              file. You might need to send the variables one at a time until you find
              the problematic one.

              --
              Rob
              _______
              Rob Dillon
              Adobe Community Expert
              http://www.ddg-designs.com
              412-243-9119

              http://www.macromedia.com/software/trial/
              • 4. Re: POSTNETTEXT on a Mac
                Ben Danis Level 1
                that is how i am sending the variables actually (the variable is a property list)
                I remember reading that lists were always heavy in director, i'm thinking that the problem lies with mac memory. i've encountered problems with that before (i'm not a mac fan)
                it might have to do with browser settings now that i think about it. I know that when you call a php file with parameters, they are embedded in the address. Maybe the problem lies with the parameters being too long and not being fully processed by the php script.
                I think i will have to fork over the money and call macromedia support. They probably won't help much though, they haven't been very successful in the past
                • 5. Re: POSTNETTEXT on a Mac
                  Level 7
                  I doubt that memory is the problem. I've sent posts with hundreds of
                  characters to CGIs with no problems at all. The problem may be with the
                  way that you are building the list that you are sending. It may be
                  useful to use a put statement to look at the result.

                  Once you have that string, you could try and use a post method out of an
                  HTML doc on a Mac to see if it works from there.

                  You might also place an editable text sprite on your stage and have the
                  function that posts your list place the list as a string in the text
                  sprite. Try that on a Mac and on a Windows machine. See if you can find
                  any difference in the output.

                  --
                  Rob
                  _______
                  Rob Dillon
                  Adobe Community Expert
                  http://www.ddg-designs.com
                  412-243-9119

                  http://www.macromedia.com/software/trial/