After almost 10 days of fighting with PHP and Flex, I found my solution. It is one of the most embarrassing, humiliating, and time-wasting things I have ever run into in programming, but I feel like I should post the solution just in case anybody ever reads this (smh). The solution had nothing to do with a problem with PDO, mysqli, or PHP at all, and it had nothing to do with Flex at all either. The solution was simply:
Quotes ' ' When you try and set return values from the database into valueObjects, you have to give Flex a set of input variables in order for it to obtain some data from the database to analyze. I put in integers for ints, numbers for nums, and for strings, I put in characters between single quotes like 'Indianapolis'. That was my mistake. Flash Builder just wants you to put in characters, no quotes. If you include quotes, you don't get an error, but I guess the database gives you back no data, and Flex interprets the results as a primitive object since there is no appreciable data stream to analyze. If you take out the quotes, Flex sees all the fields and sets up valueObjects with the appropriate data types. What a colossal waste of time!!! On the bright side, I sure can program a service in PHP in both mysqli and PDO now LOL -- View this message in context: http://apache-flex-users.2333346.n4.nabble.com/PDO-vs-mysqli-Web-Service-Return-Values-tp14970p15004.html Sent from the Apache Flex Users mailing list archive at Nabble.com.
