PHP :: MySQLI Values Returning Bits And Ints As String
Feb 24, 2012
I have a project made in flex, using php data services to access a sql server database, and I need to convert it to mysql, I have changed all my php services from sqlsrv to mysqli. Something like this:
It worked fine on sqlsrv but with mysqli it returns to flex the INT, BIT or DATE values as string the main Datatypes on mysql are INT,VARCHAR,BIT(1),DATETIME,DATE (same as sqlsrv)
and on the flex the return types are mainly as object[]
Everything seems to be a string right now & that kinda ruins the whole xml as an internal data structure thing, I don't need a big tree of string I need typed data :-/ Are there any changes I can make to either my XML files or my AS3 code that will force it to cast ints as ints and Numbers as Numbers? Or maybe some kind of type schema I can impose? Not really worked with XML til recently so chances are I'm just ignorant of the canonical way to deal with this...
I need to load data from a database, so I created the following function and placed it in frame 2 on the main timeline.
Code: getQuestionSet = function (category:String, subject:String, level:Number, count:Number):Array { var questionSet:Array = new Array(); var writeV:LoadVars = new LoadVars();
[Code]...
Whenever I try to call the function, it fails to set the value of the questions array. It always appears empty(questions[0]-questions[10] have the value undefined). But, if I check the values from within the function after I have set them, it works, so I know that it is receiving the values. What am I doing wrong?
Code: questions = getQuestionSet("Art and Music", "Art", 1, 10);
Here is an example of how I have would call the function.
I am getting variaables from a mysql database and then returning them back to the main file. However, the script is going faster than the query. is there a function that can make the file wait until it has finished loading in the variables.
I'm trying to take an xml object, parse through it, turn the appropriate elements in object properties. Then, finally, pushing each object an array. Then I need this array accessible outside of the XML.onLoad() function (since it returns nothing, I lose my array).
Here's the code from my timeline: #include "functions.as" XML.prototype.ignoreWhite = true; var top_nav:Array = new Array(); var my_xml:XML = new XML(); var xml_url:String = "nav/top_nav.xml"; [Code] ..... How I can get needed values out of the onLoad function?
I'm running some script using the charAt() function, that is supposed to return the character at specific indexes in a string, however for some reason it is returning ASCII values.
Let's start with the following XML: Code: <swatches> <swatch> <swatchName>Plaid</swatchName> <swatchColors> <color>black</color> [Code] ..... I want to return a list of the <color> values without having any duplicates.
I'm making an activity that involves measuring the depth of a fictitious river at various points. I have an array containing those depths at the various points and a slider for traversing through the depths and outputting to a textfield.
As the user moves the slider up and down, they can see the depth of the river at that point and plot it onto a graph. What I would like to do is be able to figure out the depths inbetween the explicitly defined values.
here is the code, it's pretty simple:
[Code].....
How would I go about figuring out the values inbetween?
In C you can pass a reference to a data item as a parameter to a function. then within the function you can write to that address thus passing back a value to the caller. Can you do anything similar in AS3?
I know you can use the return statement but I want to return a status by that mechanism plus a value in a parameter.
I am trying to connect to an FMS application without flash (no SWF). To the best of my knowledge,the only way to accomplish this is thru the admin APIs, is that correct? If so, how do I return meaningful values from the admin API? I can call functions and stuff using the broadcastMsg API call but I can't seem to get back any values. All that is returned is a useless "Success" type message. I have tried using shared objects and the getSharedObjects API call, but the call doesn't return any info on the contents of the shared objects, just their names and some info on their persistance.
Is there another way of accomplishing my goal outside of the Admin API? If not how do I return meaningful variables from the Admin API? Is there a way to hack or extend the admin API?
I am working on my open source project Downloadify, and up until now it simply handles returning Strings in response to ExternalInterface.call commands.
I am trying to put together a test case using JSZip and Downloadify together, the end result being that a Zip file is created dynamically in the browser, then saved to the disk using FileReference.save. However, this is my problem:
The JSZip library can return either a base64 encoded string of the Zip, or the raw byte string. The problem is, if I return that byte string in response to the ExternalInterface.call command, I get this error:
Error #1085: The element type "string" must be terminated by the matching end-tag "</string>"
ActionScript 3:
var theData:* = ExternalInterface.call('Downloadify.getTextForSave',queue_name);
Where queue_name is just a string used to identify the correct instance in JS.
JavaScript:
var zip = new JSZip(); zip.add("test.txt", "Hello world! "); var content = zip.generate(true); return content;
If I instead return a normal string instead of the byte string, the call works correctly.I would like to avoid using base64 as I would have to include a base64 decoder in my swf which will increase its size.
Finally: I am not looking for a AS3 Zip generator. It is imperative to my project to have that part run in JavaScript
when cacheAsBitmap is true, do x and y suddenly become ints? im ok with them being drawn this way, but my calculations require x and y to be numbers, because else strange behaviour occurs, which is happening now.
Or... how do you XOR doubles without getting integer results? I am using Actionscript 3.0 and found the following:
var a:Number = 3.000000004; var b:Number = 29.999999999; trace ("a: " + a); //3.000000004[code]..........
Clearly, the XOR operation is converting my Numbers into ints. I am a bit surprised by this and don't exactly understand the reason behind it. But I do know that other bitwise operations will also change Number into int, so I am not that surprised.Be that as it may, is there a way to XOR doubles (aka Numbers) without having them get truncated to integers?I used the above XOR originally for performance optimization (these number switches are executed millions of times in an array).I assumed if I skipped the temporary variable, I would see a speed increase.Alas, if the Number data gets changed to int, it is all for naught.
public static function reversePairs(values:Vector.<Number>):void { //1, 2, 3, 4, 5, 6 -> 5, 6, 3, 4, 1, 2 var l:int = values.length;[code].........
Flash is known to behave in very unpredictable ways ways when it comes to manipulating data. I'm curious that if there is any performance/memory benefit to using Numbers instead of ints aside from values that need precision. I have heard that some basic operations in Flash may convert multiple times between the two type to resolve the expression. I've also heard that Flash runtime, under the hood, actually maps ints to non-precision Numbers/Floats during runtime. Is any of this true?
What to use when 32 bit ints or even 53 bit Numbers arent large enough by far? Im thinking of just using a 256 bit array but theres prolly a better way.
I am trying to encode certain values that I receive from keyboard event. Basically I want to check if a certain key combination has been pressed or not, so for that I am converting the key codes into sequence/pattern and store it in an object and a value(function) against each code sequence. Now I have to use four bytes and in first byte(MSB) I've to store shift, alt, ctrl respectively and in the last(LSB) I have to store the keycode of the key pressed.
Here is the code: private function m_encodeValue(key:String, Ctrl:Boolean = true, Alt:Boolean = true, Shift:Boolean = false):uint { var encodedValue:uint; encodedValue = uint(Shift) << 2 | uint(Alt) << 1 | uint(Ctrl); encodedValue = encodedValue | (uint(key.toUpperCase().charCodeAt(0)) << 24); return encodedValue; }
I'm trying to get the values contained in the following XML <user> <id type="integer">122</id> <name>newuser</name> <email>newuser@user.com</email> <created_at type="datetime">2011-08-31T19:16:52Z</created_at> [Code] ..... But in the debugger I can see that the vars XMLNAME< XMLEMAIL & XMLPoints are all being created but they are empty strings. How can I navigate to their values?
I was wondering if Flash was able to handle PNG files with 16 bits per channel. I seem to remember (quite clearly actually) from some official blog post on Pixel Bender, that since Flash only handles 8 bits per channel and Pixel Bender works at 24, a conversion occurs when data is passed from Flash to PB and vice versa. (this thread is totally unrelated with Pixel Bender though) So if I'm correct, Flash uses 8 bits per channel even if you try to load a 16 bits per channel PNG. Do you guys have any experience whether this is a fact or not?econdly, assuming this is a fact...could I still load a 16 bits per channel into Flash, not to display it but to convert the data to a 8 bits per channel PNG that I would save as a file. For instance the 16 BpC PNG could be loaded in a ByteArray and I'd work from here, however I have to know whether the PNG would still be 16 BpC once it reach the ByteArray.
I meant to call it "Convert a value to a variable". Using CS3, AS2: If I have a variable that's a string value = the name of another variable, can I extract the value and then look for the extracted value's matching variable name to get it's value?
Ex:
color = "blue" box = "color"
(Assuming I don't know the value of box) How would I get the value of "box" out so I could search for the value "color" as if it were a variable? I need to convert a value to a variable name is what i'm getting at... I think.
When you want to split a string in to an array, seperated by the letter "e" for example. So string: 0e5e8e7 would become 0,5,8,7..[code]Is there a way you could split a string by multiple values? So instead of it splitting the string when it comes across "e", could you have it split when it comes across "e", or another character.
I meant to call it "Convert a value to a variable".Using CS3, AS2:If I have a variable that's a string value = the name of another variable, can I extract the value and then look for the extracted value's matching variable name to get it's value?[code](Assuming I don't know the value of box) How would I get the value of "box" out so I could search for the value "color" as if it were a variable? I need to convert a value to a variable name is what i'm getting at.
i am trying to tell flash to put some text on a dynamic textfield on stage based on some variables written on the URL in the browsers address bar, sort of like how PHP uses $_GET.so for example, i have a file called "embed_page.php" and embedded in it is a swf file called "dynamic.swf"UrL>..trace("name is: " + n + " and color of choice is: " + c + " and gender is: " + g);if only i could get access to the URL in the address bar, i could play around with indexOf and slice to get the values i want...