Duplicate (and Unwanted) Inserts Occur In MySQL
Oct 19, 2010
The strangest thing has occurred with one of my apps (Flash/Coldfusion/mySQL). I use a simple INSERT statement to save member details into my table. The table has a Primary Key on the memberID. Recently, one of my entries was saved multiple times (not supposed to happen). The datetimestamp shows the save occurred at the identical time. This has never happened before. I've read on Stackoverflow that there are alternatives to INSERT e.g. REPLACE INTO, but I'm wondering why this would have occurred in the first place?
View 3 Replies
Similar Posts:
Apr 9, 2010
I have a button with a list of _global settings:
_global.practiceName = pName.text;
_global.practiceStreet = pStreet.text;
_global.practiceCity = pCity.text;[code]....
Then I have a MC with a dynamic text box with some AS:
practiceInfo.text = practiceName+' - '+practiceStreet+", "+practiceCity+", "+practiceState+" "+practiceZip+" - "+practicePhone+" - "+practiceSite;
The problem I am having is it ONLY inserts the FIRST _global property! Only the pName.text goes in. Am I missing something here?The practiceInfo.text works great if I manually state:
practiceName = "AbC";
practiceStreet = "1235 Way";
View 1 Replies
Jul 18, 2007
When I create an empty input text-field and compile, the curser starts at the 2'nd line when I click the text field! Is there a work-around to get the initial curser position at the top?
View 2 Replies
Nov 28, 2011
I would like to make a flash banner which inserts City name depending on ip address of user viewing the banner!
View 3 Replies
Feb 2, 2011
I have a typical Flex-based application that was written to use a Java/Hibernate/MySQL backend. The client changed the requirements - now they want to distribute it on a CD where the user can just run the app without any installation or a network connection.
To do this, I certainly need to eliminate the web server and the database server and adapt my application (with as few changes as possible, of course) to a stand-alone application that will fit on a CD/DVD. I've managed to export the data to XML and read it into Flex, but I'm wondering if there's a way to recreate the Hibernate data structures in Flex so I could change as little code as possible. Failing that, is there any way to keep the existing Java/Hibernate external to the Flex code but retrievable without installing Apache Tomcat or MySQL?
View 3 Replies
Jan 13, 2010
I have a Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
View 1 Replies
May 25, 2010
I have downloaded MySQL JDBC driver from [URL]... How do I configure it?
View 1 Replies
Oct 22, 2011
In my table the Collation is:latin1_swedish_ci (but i tried UTF8_unicode too).In my flex application when it shows the table,it displays it correct,with all accent and pointing correct,but in the table is like :
View 1 Replies
Dec 2, 2010
I have a project where I am loading in an external swf and when it error loading I want it to show the error on screen which I have accomplished and then I want to provent it from going any further . i.e no more frames entered no more axtionscript run
I tried this and got nothing
function ioError(e:IOErrorEvent):void {
error_txt.text = e.text;
trace(e.target.loaderURL);
stop();
}
View 1 Replies
Nov 11, 2009
I've got a lovely little drawing of a tree, and when I hover over it, the leaves turn from green to brown, which is exactly what I want it to do, however, I only want it to do it once. At the moment, once it's finished it's colour change, it stays that shade of brown, but if I hover over it again, it starts the little green to brown animation again. Is there any way to make it only listen once? ie once it turns brown, it stays brown forever?[code]
View 6 Replies
Mar 20, 2010
My problem is that when I click the letter movieclip it does create the duplicate as it should and it starts to drag the duplicate mc. However, when I release the clip it doesn't stop dragging? I realized that if I put onMouseUP event instead of onRelease it actually does stop dragging when I release the mouse. I would, however not like to use the onMouseUP event if possible.
[Code]...
View 2 Replies
May 4, 2010
If I have an object that calls
addEventListener(Event.ENTER_FRAME, update);
addEventListener(Event.ENTER_FRAME, update);
will that add 2 listeners?
View 2 Replies
May 21, 2010
I have a main swf with a button that loads a simple Papervison3D cube swf.It loads just fine...but when i click a different button on my main swf (which removes the Papervision swf and loads a different swf) i see endless repeating lines of the same error build up in my error window. Visually, everything works (the Papervision swf is removed immediately and a new swf replaces it) but these errors suggest otherwise It looks like the Papervision swf has not completely been unloaded or something...i dunno. Is there some removal step that i'm not doing?
[Code]...
View 10 Replies
Jun 29, 2010
How to check in as3 if there was a roll_over occurred on one of the mc?
View 4 Replies
Apr 26, 2010
here's my string....
var shapeString:String = "Princess,Round,Radiant,Princess,Heart,Round,Radiant,Emerald,Radiant,Radiant,Pear";
I need to figure out how to return the the 3 items that occur most in the order of highest to lowest. In this example it would end up being.
newString = "Radient,Princess,Round";
I imagine I would use indexOf somehow but I am not going to know what pattern I am searching for in the string so it is just based on the items that end up in shapeString based on a bunch of selected elements.
View 4 Replies
May 27, 2008
I have a problem with some code. Its in the else statement below. Essentially I am trying to make sure I can read in the mc._height value before I continue with the code, I use a listener to check that I can get the value which I can,however it seems to do all the code after the loadListner.onLoadInit function before this function.
[Code]...
View 4 Replies
Oct 1, 2003
I have many movieclips -I have 10 movieclips for each type-and i have around 7 types of movie clips (ex. 10 red squares, 10 green triangles, 10 blue circles movieclips) now I want a different action to occur if any of the movieclips get clicked-but the same action should occur if the same type gets clicked (ex. if the user clicks on any of the blue circle-it should get dragged, if they click on any of the green triagles-it should get deleted and so on)what's an efficient way of doing it except for
if square1.onclick=square2.onlick=function()...
if triangle1.onclick=triangle2.onlick=function()...
there's a prototype-but that affects all the movieclips-is there a way for me to make each of the movie clips-sort of a different category (object) so that way I can use prototype keyword-or anything else-to have the same affect? and not have to write repetitious code?(maybe some sort of inheritence to movieclip)
View 4 Replies
Oct 30, 2009
I had a function that occured on mouseclick called go_out. I want this function to occur when the timer fires after 5 seconds. After the 5 secons I receive this error:
[Code].....
View 4 Replies
Nov 10, 2006
How do I make an MC or other object listen always for an action to occur. I know that sounds vague and I don't mean it to be. I'm wanting to dynamically load MCs into another base MC. The deal is the amount of child MCs is not defined. I want each MC to be "listening" for an action to occur in a base MC and in other child MCs. I tried using localConnection, but it doesn't do the above.
View 4 Replies
Jun 24, 2009
Is there a way to make event flow occur synchronously?
Basically this is my scenario. I have a single method call that gets triggered by a server request. I want to be able to notifiy subscribers that the method has/is executing so that they may return a result. By modifying an attribute of the actual event object, the method can return that result to the server dynamically. Eg:
Code:
//method invoked by server
public function whatever(...parameters):* {
var event:MyEvent = new MyEvent(MyEvent.TYPE);
[Code]....
This code works around 70% of the time, but sometimes I see things are really happening asynchronously in Flash Player's event flow. Is there anything I can do to regulate this and make sure it happens synchronously?
View 4 Replies
Aug 15, 2009
I'm trying to have an animation occur on a timeline and not on Enter frame, so instead of it doing a continuous loop it just does the animation twice then stops. Currently this code is on the movie clip itself and I want to move it to the main as code line so it animates then stops.
onClipEvent (enterFrame) {
rpm = 35
}
onClipEvent (enterFrame) {
[code]....
View 1 Replies
Sep 26, 2000
I am having problems dupliating a movie clip. I can make a duplicate from an original but when I edit the duplicate it also modifies what is in the original. (I am just changing the text, thats the only difference between the 2) How come it effects both clips when I only change one?
View 6 Replies
Jan 25, 2010
I am getting the error message: flash cs3 "Motion tweening will not occur on layers with ungrouped shapes or on layers with more than one group or symbol".I have only one symbol in the layer, a graphic.Does anyone know how I can correct the "problem"?
View 2 Replies
Sep 3, 2009
The jist of what I'd like to know and focus on understanding, is details on how binary deserialization occurs in Flex 3. When is the constructor called, when are properties set, are private members serialized or does all deserialization occur on and through setters, etc? I'm having a hard time finding information on this.In a Flex 3 AIR application, I have a pretty complex object graph(just a bunch of objects referencing one another, kinda like a big data model except a bit more complex) that I serialize to a file using a single call on the FileStream.writeObject and readObject on a root object, which serializes and deserializes the entire object graph.I found that I needed to always have a default constructor, else I would get exceptions on the objects when deserializing if they were part of an ArrayCollection. So I had to eleminate the constructor parameters or set default values. I now have many setters like this in my classes, such as the below where mConnection accumulates some information it needs through different setters, where as before I had this all packed into the constructor since all of the information is really necesary for the Connection to function:[code]So the connection's serverIP is still an empty string because the server was assigned to the client's property before the server was completely initialized.
I could probably resolve this by using binding so that updates to the serverip in the server are bound to the connection, but I find binding properties to be fairly complicated (it's really simple on UI in mxml cause you just use the curly bracket syntax but doing it by code is what I found complicated). I have also resolved some cases by removing the constructor parameters entirely, so that there is no default values. All that aside, I still really need a deeper understanding of the details of binary serialization as far as how it rebuilds the object graph. I even have circular references, and it seems to handle those fine and maintain multiple references without duplicating objects. It's just when my constructors/setters are more complex that I'm running into these problems because of the order of what occurs during deserialization. It is really inconsistent though, as adding breakpoints in various places seems to influence the order that things occur, making it more difficult to debug.On a side note for anyone that might sidetrack the topic because I am serializing a class called Connection. I added some code to address some things, like in the Connection class there is an instance of a Socket. Of course my socket would not be connected after I close and reopen the application and deserialize it, so before I serialize my object graph, I go through and close the socket and set the reference in the Connection class to null, so that there is no longer a reference to the socket and thus it will not get serialized. After deserialization on the next application run I create a new socket.
View 1 Replies
Apr 14, 2011
I have an application with a Google Map, an Area Chart, and an accordion containing a list.When the selection in the list is changed, the application fetches data from the server and updates the chart and map, repositioning the map to contain all markers within its viewport and kicking off a SeriesEffect to animate the chart data redraw.When a user changes selections and continues to mouse over the items in the list while the map and chart are redrawing, the labels on the item renderers disappear.The item renderer code is the following:
<s:ItemRenderer xmlns:fx = "http://ns.adobe.com/mxml/2009"
xmlns:s = "library://ns.adobe.com/flex/spark"
xmlns:mx = "library://ns.adobe.com/flex/mx"
[code]....
View 2 Replies
Mar 5, 2012
I've some very old Flash applications, which we don't want to rebuild to add a new feature. We simply need to detect when the user has become idle. So, if the Flash application receives no key or mouse events after 3 minutes, we want to track that time till the user interacts with the application again.
We've considered wrapping the applications in newer Flash applications to include the key/mouse event tracking; however, early research shows that some of our apps are so old that they use event systems or AVM's (ActionScript Virtual Machines) that are incompatible. Also, it seems that mouse events on the inner application don't bubble up to the outer application. (I think the direction of event processing is backwards in versions of Flash prior to 8)
Anyhow, the next idea on the table is to see if we can determine when the user stops interacting with the old Flash applications using JavaScript. Can anyone confirm whether or not it is possible to detect, using JavaScript only, when a swf in an HTML document loses focus or key and mouse events stop and start occurring on the swf?
View 1 Replies
Feb 3, 2011
I have three buttons on screen that navigate to different places on the timeline. I have set them all up as buttons using a generic button in the library and then given them all different instance names. I selected the button and changed the text colour for each state in the timeline (up, over, down) to keep it simple. The buttons are all, as far as I can analyse, identical in all but instance name.
When I test the movie, the first button changes text colour on 'over' and, when I click (i.e. down state) the colour changes again as designed. The navigation action doesn't occur until I release the mouse button, giving the feel of having 'clicked' the button.
With the other two buttons, which have been set up as far as I can tell in exactly the same way, when the down state occurs, I see a momentary flash of the text colour change and it performs the nav straight away. I really want it to perform the same way as the first button but cannot for the life of me see why they're behaving differently.
View 1 Replies
Dec 21, 2009
I'm building my portfolio in as3 with a 3D panel effect with a class called panel taht i get as my main class in my the publish window. This class uses GS tweening class ton rotate on a 3D axis and to enlarge the pictures from my portfolio all this is working relatively well. Now i got an image to also turn 90 dergees for it is horizontal image nd the gallery has vertical thumbnails so i just coded this simple function to make it flip with GS of course
[Code]....
View 1 Replies
Oct 14, 2009
I have a web design for a client that was pretty much complete. They decided that they wanted to replace one of the graphics with a flash animation. When I added the swf file to the layout in Dreamweaver it apparently is adding some space around the swf which breaks the rest of the design. It looks to be about 4 pixels or so of space that is getting added. I experimented with padding, margins, borders on every element in the design. I tried changing the Scale parameter of the swf to "no border" and "exact fit". I tried enclosing the elements in a table. To simplify things I created a new blank page in Dreamweaver and added the two elements that are giving me grief. The original width of the design was 792.
On the top I had 2 graphics, the first was 212 wide and the second was 580 wide. The first graphic is the one that got replaced with the swf file. The swf is also 212 wide. But for some reason there is that extra space on the right side of the swf that forces the second graphic to the next line. You can see the example here: [URL]. This shows what happens when the original graphic was replaced with the swf. (The swf doesn't do anything as I actually replaced the client's swf with one I made that has the original graphic as the only item in the movie). If you look here: [URL]. I changed the width of the second graphic to 574 wide. That kept the graphic on the same line, but you can clearly see that the swf has the unwanted space to the right.
View 2 Replies
Apr 11, 2010
Problem embedding CS4 Flash Movie - Player 10. I am embedding a Flash Movie into an HTML doc. The doc was created in DW CS4 and has a table with 3 columns and 5 rows. Each cell will have content. I put a flash movie in the center cell, three rows down from top. Everything looks great in Safari. However, in IE, FF, and IE Chrome, there is space along the top and bottom of the movie -- have not tried the AOL browser. About 10 px each. I've tried everything to fix it. I published the HTML in Flash and tried integrating the generated HTML with my table -- same problem. Maybe publish settings could be tweaked.
I've tried 0 margins in CSS header tag, and HTML too. I thought I had this problem about a year ago with a different site ... been that long ... and resolved it.
View 1 Replies