Copy link to clipboard
Copied
Hi,
I am using wamp server (php and mysql) as a datasource for my flex application. I am try to access all the colums with PatientID:(txtpatientid) --> this patientID is coming from a textbox and display them in a datagrid at button_click function, which calls the getmydataByID.lastresult function. If I use getAllmydata() function, it does work and displays all the data in the table, but when I try to use getmydataByID.lastresult, it shows only the first column in datagrid with that specific ID and ignores rest all colums with the same patientID.
For example:
ID PatientID Surname Firstname Weight(kg)
1 1024 Jon Kelly 50
2 1024 Mike Jim 55
3 1025 Jackson Kim 49
I want to show both first and second colums with PatientID 1024, but getmydatabyID function only shows the first column and ignores second one.
Please help, as I am badly stuck.
Thanks in advance.
Copy link to clipboard
Copied
Kindly let me know if further details required. Thanks
Copy link to clipboard
Copied
Hi Uzair,
It is very hard to figure out what exactly the logic behind you application, especially if getmydataByID.lastresult and getAllmydata() calls are invoked from your PHP or Flex. It will be great to see the full picture with code snippets.
As for your question, I would suggest to use the debugging tool, to better understand what information is retrieved per each call and by this pin point the logic of your application.
See this page for more information on debugging: http://files.zend.com/help/Flash-Builder-for-PHP/Help/debugging_a_flex_mobile_php_application.htm
Roy
Copy link to clipboard
Copied
Hi RoyGanor,
Thanks for your reply and all the guidance. I have actually tried doing debug but wasn't able to find the issue. Let me try to explain the scenario. I just want to show all the columns with PatientID of 1024 into a datagrid. There is a function, which is created automatically at the time of creating a DataService and its called getmydataByID (where mydata is just the name I have given to my DataService and "get & ByID" are pre-defined keywords for this fuction). I have tried to use this function but this functions works like searching on the Primary key only, and as the values of PatientID is not unique, so I can't define it as primary key to get use of this function.
Can you please give me an idea that how can I achieve this?
Thanks RoyGanor