8 Replies Latest reply on Jul 27, 2010 11:15 PM by Brad Lawryk

    Datagrid from a recordset?

    Brad Lawryk Adobe Community Professional & MVP

      Hello,

       

      Everything I have seen shows how to connect a Datagrid to a database table. Thats fine and good. But is it possible to add a datagrid to a recordset somehow?

       

      Brad Lawryk

      Adobe Community Professional: Dreamweaver

      Northern British Columbia Adobe Usergroup: Manager

      My Adobe Blog: http://blog.lawryk.com

        • 1. Re: Datagrid from a recordset?
          SunilAdobe Adobe Employee

          If you are referring to the recordsets available on the server side, then there are 2 ways to accomplish this.

           

          1. You could convert that to XML and access it on the client in Flex (Its heavy but works smoothly as Flex has tools to access XML data using the Data Wizards or through E4X)

           

          2. Depending on your backend, if it's say ASP.NET then you could use tools like FluorineFx or WebOrb to send recordset data using AMF (which is a binary protocol and lightweight)

           

          The following links should help

           

          http://sujitreddyg.wordpress.com/flash-builder-4/#dotnet

          http://www.google.co.in/search?hl=en&q=FlexAMF.NET&aq=f&aqi=&aql=&oq=&gs_rfai=

           

           

          Thanks

          -Sunil

          • 2. Re: Datagrid from a recordset?
            Brad Lawryk Adobe Community Professional & MVP

            Thanks Sunil,

             

            I still can't even get a basic Datagrid to work on a live server. So

            basically I am pretty much giving up on Flash Builder. If you can't

            deploy projects to the web - there really is no point to using it or

            wasting any more time on it. I'll tinker around a bit when I get spare

            time, but for now I have all but given up on the product.

             

            However, I really do appreciate your time.

             

            Thanks,

            Brad Lawryk

            Adobe Community Professional: Dreamweaver

            Northern British Columbia Adobe Usergroup: Manager

            My Adobe Blog: http://blog.lawryk.com

            • 3. Re: Datagrid from a recordset?
              SunilAdobe Adobe Employee

              Hi Brad,

               

              Sorry to hear that you are facing issues with this. To help you, we need to understand exactly what those issues are. I know that

               

              a. you are having a recordset on your server

              b. you want to populate that in a Flex datagrid

               

              I need to know the following

               

              a. What is the backend you are using

              b. How are you calling the service from Flex, Is it HTTPService, WebService or RemoteObject

              c. related to question b, What is the exact error you are getting when you run your flex application

               

               

              Thanks

              -Sunil

              • 4. Re: Datagrid from a recordset?
                Brad Lawryk Adobe Community Professional & MVP

                Hi Sunil,

                 

                What I have set up is so basic a child should be able to do it. Its a simple PHP/MySQL table with 5 records in it (an authour and a quote in each record). All it is is a simple thing I did up real quick for practice and trying to get something actually working. Its basically just a datagrid listing the authours and when you click on a name in the grid it displays a quote below the grid. Works great locally, just like any other project I have been playing around with to learn. But does not work live.

                 

                You can see it all its lovely errors at http://www.auroragraphix.com/quotes/Quotes.html

                 

                Ryan Stewart @ Adobe has already been awesome enough to help with what he could in private and it is certainly appreciated. But even within the Adobe Community Professionals groups no one seems to know how to put a project live on the web and there is no documentation. Took five minutes to throw the little test app together ..... almost two weeks to try and get it to work live on a server and counting.

                 

                Brad Lawryk

                Adobe Community Professional: Dreamweaver

                Northern British Columbia Adobe Usergroup: Manager

                • 5. Re: Datagrid from a recordset?
                  SunilAdobe Adobe Employee

                  Hi Brad,

                   

                  What is the version of MySQL that you are using in your production server? I believe this error can come when you are using 4.x, you should be using 5.1 or above.

                  Also what is the PHP version, Flash Builder requires 5.1 or above ?

                   

                  Thanks

                  -Sunil

                  • 6. Re: Datagrid from a recordset?
                    Brad Lawryk Adobe Community Professional & MVP

                    Hi Sunil,

                     

                    Already checked into that and it should be fine. First server I tried didn't meet the requirements but this one does according to the Flash Builder pge

                     

                    PHP:  5.2.13

                    MySQL: 5.0.67

                     

                    Brad

                    • 7. Re: Datagrid from a recordset?
                      SunilAdobe Adobe Employee

                      Hi Brad,

                       

                      The mentioned version numbers are fine. The MySQL error that you are getting is typically a unsupported command in that version of MySQL. Actually in Line 59, the error where it is coming, it is telling that there is an error while preparing the statement. This can happen only when that statement is not supported or the SQL is wrong, I suspect the former, just use this command to find the version select version(); (Also make sure your SQL is also correct)

                       

                      Also To confirm the issue: I think you should try to directly execute the SQL, rather than FB generated code which uses prepare statement (which is much safer and avoids sql injection etc.). A sample would be like this

                       

                      mysql_connect(localhost,$username,$password);

                      @mysql_select_db($database) or die( "Unable to select database");

                      $query = "SELECT * FROM AUTHORS";

                      mysql_query($query);

                      mysql_close();

                       

                      Let me know, otherwise we can try to solve this by having a adobe acrobat connect session.

                       

                      Thanks

                      -Sunil

                      • 8. Re: Datagrid from a recordset?
                        Brad Lawryk Adobe Community Professional & MVP

                        Hi Sunil,

                         

                        Once again, I appreciate your help. I have the database set up identical

                        on my local machine as the live server and it works locally just fine. I

                        wouldn't have a clue where to put that code right off hand although.

                         

                        I am leaving for Vegas in the morning and won't be back at a computer

                        until Tuesday sometime. I'll give it a try when I get back.

                         

                        Thanks again,

                        Brad