RE: [Flashcoders] RE: [Flash_Tiger] Actionscript Exploit very bad news

[Francis Cheng]

Yes, I'm sure we do test it on Mac OS X. Sorry you're having problems
with it. I'll pass this information along to the Flash Player team.

Francis Cheng | Senior Technical Writer | Adobe Systems, Inc.
http://blogs.adobe.com/fcheng

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
Kawamoto
Sent: Friday, April 18, 2008 2:58 PM
To: Flash Coders List
Subject: Re: [Flashcoders] RE: [Flash_Tiger] Actionscript Exploit very
bad news

My Intel Mac at work invoked ExpressInstall today for your new security 
update 9.0.124.0 but failed (again and again), so that I had to do the 
manual FP download and install.

I said this before, but your ExpressInstall never worked on my G5 
either. This is stopping us from deploying AS3 in the commercial 
environment (apart from AIR/JANUS etc), because I cannot say to my 
clients that their audience will have no problem viewing AS3 contents.

Do you (Adobe) actually test your ExpresInstall on Mac ever???

Kenneth Kawamoto
http://www.materiaprima.co.uk/

Francis Cheng wrote:
> This is a good opportunity to remind everyone to upgrade to Flash
Player
> 9.0.124.0, which addresses this vulnerability.
> 
> http://www.adobe.com/support/security/bulletins/apsb08-11.html
> 
> Here's a link to the debugger versions of 9.0.124.0:
> 
> http://www.adobe.com/support/flashplayer/downloads.html#fp9
> 
> 
> Francis Cheng | Senior Technical Writer | Adobe Systems, Inc.
> http://blogs.adobe.com/fcheng
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] RE: [Flash_Tiger] Actionscript Exploit very bad news

[Kenneth Kawamoto]

My Intel Mac at work invoked ExpressInstall today for your new security 
update 9.0.124.0 but failed (again and again), so that I had to do the 
manual FP download and install.


I said this before, but your ExpressInstall never worked on my G5 
either. This is stopping us from deploying AS3 in the commercial 
environment (apart from AIR/JANUS etc), because I cannot say to my 
clients that their audience will have no problem viewing AS3 contents.


Do you (Adobe) actually test your ExpresInstall on Mac ever???

Kenneth Kawamoto
http://www.materiaprima.co.uk/

Francis Cheng wrote:

This is a good opportunity to remind everyone to upgrade to Flash Player
9.0.124.0, which addresses this vulnerability.

http://www.adobe.com/support/security/bulletins/apsb08-11.html

Here's a link to the debugger versions of 9.0.124.0:

http://www.adobe.com/support/flashplayer/downloads.html#fp9


Francis Cheng | Senior Technical Writer | Adobe Systems, Inc.
http://blogs.adobe.com/fcheng

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Actionscript Exploit very bad news

[Matt S.]

But what does it actually mean for the lay flasher?

.m

On Fri, Apr 18, 2008 at 5:03 PM, Ricky Bacon <[EMAIL PROTECTED]> wrote:
> Steven Sacks wrote:
>
> >
> http://www.matasano.com/log/1032/this-new-vulnerability-dowds-inhuman-flash-exploit/
> >
>
>  That's the most amusing write up of an exploit I've ever read.  I
> especially like the answer at the end of the follow up post:
>
>  Has Mark Dowd simply outclassed us? Should we pack it up and quit?
>
>  Yes. But don't feel bad about that. You're a human being, and he's a
> remorseless killing machine. Big Blue crushed Kasparov, and now he's not the
> prime minister of Russia! At a certain point, you have to concede the field,
> moving on to games where human beings still have the advantage. Computers
> haven't solved Go, for instance. For us researchers, I suggest we take
> advantage of Mark Dowd's robotic inability to love, and take up the arts,
> such as watercolors or interpretive dance.
>
>  
>
>  Hilarious.
>
>  -Ricky
>
>
>  ___
>  Flashcoders mailing list
>  Flashcoders@chattyfig.figleaf.com
>  http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
>
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

[Flashcoders] RE: [Flash_Tiger] Actionscript Exploit very bad news

[Francis Cheng]

This is a good opportunity to remind everyone to upgrade to Flash Player
9.0.124.0, which addresses this vulnerability.

http://www.adobe.com/support/security/bulletins/apsb08-11.html

Here's a link to the debugger versions of 9.0.124.0:

http://www.adobe.com/support/flashplayer/downloads.html#fp9


Francis Cheng | Senior Technical Writer | Adobe Systems, Inc.
http://blogs.adobe.com/fcheng

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Steven Sacks
Sent: Friday, April 18, 2008 1:29 PM
To: [EMAIL PROTECTED]; Flash Coders List
Subject: [Flash_Tiger] Actionscript Exploit very bad news

http://www.matasano.com/log/1032/this-new-vulnerability-dowds-inhuman-fl
ash-exploit/

http://documents.iss.net/whitepapers/IBM_X-Force_WP_final.pdf



___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Actionscript Exploit very bad news

[Ricky Bacon]

Steven Sacks wrote:
http://www.matasano.com/log/1032/this-new-vulnerability-dowds-inhuman-flash-exploit/ 


That's the most amusing write up of an exploit I've ever read.  I 
especially like the answer at the end of the follow up post:


Has Mark Dowd simply outclassed us? Should we pack it up and quit?

Yes. But don’t feel bad about that. You’re a human being, and he’s a 
remorseless killing machine. Big Blue crushed Kasparov, and now he’s not 
the prime minister of Russia! At a certain point, you have to concede 
the field, moving on to games where human beings still have the 
advantage. Computers haven’t solved Go, for instance. For us 
researchers, I suggest we take advantage of Mark Dowd’s robotic 
inability to love, and take up the arts, such as watercolors or 
interpretive dance.




Hilarious.

-Ricky
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

[Flashcoders] Actionscript Exploit very bad news

[Steven Sacks]

http://www.matasano.com/log/1032/this-new-vulnerability-dowds-inhuman-flash-exploit/

http://documents.iss.net/whitepapers/IBM_X-Force_WP_final.pdf
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Double lines from PHP

[robert]

no idea what your form data in php looks like, but you could probably  
use nl2br in there and the output (xml?) doesn't include \n or \r but  
simply  as needed.


Anyway I think on Windows you get a \r\n combo. for flash, you need to  
strip out the \r. then \n remains and as far as I recall for AS2, the  
\n is still interpreted regardless of htmlText. so finally you need to  
strip out the \n and replace that with .





On Apr 18, 2008, at 10:08 AM, Elia Morling wrote:


Thanks, but it didn't work. :(

- Original Message - From: "Muzak" <[EMAIL PROTECTED]>
To: "Flash Coders List" 
Sent: Friday, April 18, 2008 5:37 PM
Subject: Re: [Flashcoders] Double lines from PHP



str.split("\n").join("");

- Original Message - From: "Elia Morling" <[EMAIL PROTECTED] 
>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 3:55 PM
Subject: [Flashcoders] Double lines from PHP


I'm sending some form data from PHP to flash and all line feeds  
turn out to be double lines in flash.


I'm using a textfield and htmlText. I tried to conver chr(13) and  
chr(10) to  but it doesn't work.

I also tried turning chr(13) to chr(10) and vice versa without luck.

Any ideas?

Elia


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Double lines from PHP

[Ibrahim Y]

how you send data from PHP to flash ?
& how you manipulate them in flash?

On Fri, Apr 18, 2008 at 4:55 PM, Elia Morling <[EMAIL PROTECTED]> wrote:

> I'm sending some form data from PHP to flash and all line feeds turn out
> to be double lines in flash.
>
> I'm using a textfield and htmlText. I tried to conver chr(13) and chr(10)
> to  but it doesn't work.
> I also tried turning chr(13) to chr(10) and vice versa without luck.
>
> Any ideas?
>
> Elia ___
> Flashcoders mailing list
> Flashcoders@chattyfig.figleaf.com
> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
>
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Double lines from PHP

[Elia Morling]

Sorry, yes it did work! Thx!

Elia

- Original Message - 
From: "Muzak" <[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 5:37 PM
Subject: Re: [Flashcoders] Double lines from PHP



str.split("\n").join("");

- Original Message - 
From: "Elia Morling" <[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 3:55 PM
Subject: [Flashcoders] Double lines from PHP


I'm sending some form data from PHP to flash and all line feeds turn out 
to be double lines in flash.


I'm using a textfield and htmlText. I tried to conver chr(13) and chr(10) 
to  but it doesn't work.

I also tried turning chr(13) to chr(10) and vice versa without luck.

Any ideas?

Elia


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders 

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Double lines from PHP

[Elia Morling]

Thanks, but it didn't work. :(

- Original Message - 
From: "Muzak" <[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 5:37 PM
Subject: Re: [Flashcoders] Double lines from PHP



str.split("\n").join("");

- Original Message - 
From: "Elia Morling" <[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 3:55 PM
Subject: [Flashcoders] Double lines from PHP


I'm sending some form data from PHP to flash and all line feeds turn out 
to be double lines in flash.


I'm using a textfield and htmlText. I tried to conver chr(13) and chr(10) 
to  but it doesn't work.

I also tried turning chr(13) to chr(10) and vice versa without luck.

Any ideas?

Elia


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders 

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

RE: [Flashcoders] byteArray x/y

[I Go Geo]

John,

Doesn't work. It works for one number and repeats that number 10 x 15 times.
But what I am trying to do is see the numbers, in this case 0 to 7 repeated
10 x 15 times.

I can also get this to work with one column repeating and at the same time
one row repeating. But not the correct numeric order repeating.

I think you set of files are different from what I have. It is not material
but your bitmap (tiles.gif not spacemap.gif because if you use tiles.gif you
can see the results better) seems to be 64 x 48 and mine is 64 x 32. I
imported my tiles.gif into FlashPro and did the "Info" bit to see the size.
The reason I mention it is: if that is different what else is?

I had already traced out numTilesH/numTilesV to see the results: 4 by 2. Up
to this point we are in agreement (other than your bitmap being a different
size).

One thing that is going to be extremely confusing to anyone reading this
thread later is the fact that Glen seems to think that numRows should be
used "April 10th: setTile(j, i, (i * numRows) + j); and you seem to think
numCols should be used (April 17th: setTile(j, i, (i * numCols) + j);".

My reading of Moock's book seems to say the byteArray will be from left to
right column first. That would seem to indicate we need numCols in there? Is
that something we can agree on?

After that can I ask you or Glenn: Have you (no matter the size bitmap) got
the code to set the tiles so they are in correct numeric order and repeated
10 x 15? If you have and you have randomize correctly changed to do what I
am trying to do then it is time I downloaded a new set of files.

Silly question but if you go to Colin Moock site and send him an email will
he answer it?

Thanks,
Terry





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of John
McCormack
Sent: Friday, April 18, 2008 10:17 AM
To: Flash Coders List
Subject: Re: [Flashcoders] byteArray x/y


Terry,

I think I know what might be going wrong for you.
You might be expecting something different.

Try this...
Instead of setTile(j, i, (i * numCols) + j);
Let's use tile 1 or tile 9...

Change that line to setTile(j, i, 1) or setTile(j, i, 9)
You see a 16x16 pattern repeated.

The 12 tiles are extracted from spacetiles.gif, which is  64x48 pixels

In SpaceMap.as the size of the square is 16x16...
tiles.loadTiles("spacetiles.gif", 16);

So in TileSet.as the size is 16 and the data from spacetiles.gif, is 64x48
and numTilesH become 64/16 =4 across and
numTilesV becomes 48/16 =3 down
giving 12 tiles in the set

TileSet.as, line 73...
public function convertBitmapToTiles (size:int,
  data:BitmapData):Array {
  var newTileSet:Array = new Array();
  var numTilesH:int = data.width/size;
  var numTilesV:int = data.height/size;

  for (var i:int = 0; i < numTilesV; i++) {
for (var j:int = 0; j < numTilesH; j++) {
  newTileSet.push(data.getPixels(new Rectangle(j*size, i*size,
   size, size)));
}
  }
  return newTileSet; // 12 tiles in the set
}

The tiles are the 16x16 and these make the star field.
The drag field is separate to that.

I have benefited from looking at this code, and other code,
and I am pleased to be able to give something back
Moock did a great job. Hope that helps.

John


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Double lines from PHP

[Muzak]

str.split("\n").join("");

- Original Message - 
From: "Elia Morling" <[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 3:55 PM
Subject: [Flashcoders] Double lines from PHP


I'm sending some form data from PHP to flash and all line feeds turn out to 
be double lines in flash.


I'm using a textfield and htmlText. I tried to conver chr(13) and chr(10) to 
 but it doesn't work.

I also tried turning chr(13) to chr(10) and vice versa without luck.

Any ideas?

Elia 


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] byteArray x/y

[John McCormack]

Terry,

I think I know what might be going wrong for you.
You might be expecting something different.

Try this...
Instead of setTile(j, i, (i * numCols) + j);
Let's use tile 1 or tile 9...

Change that line to setTile(j, i, 1) or setTile(j, i, 9)
You see a 16x16 pattern repeated.

The 12 tiles are extracted from spacetiles.gif, which is  64x48 pixels

In SpaceMap.as the size of the square is 16x16...
tiles.loadTiles("spacetiles.gif", 16);

So in TileSet.as the size is 16 and the data from spacetiles.gif, is 64x48
and numTilesH become 64/16 =4 across and
numTilesV becomes 48/16 =3 down
giving 12 tiles in the set

TileSet.as, line 73...
public function convertBitmapToTiles (size:int, 
 data:BitmapData):Array {

 var newTileSet:Array = new Array();
 var numTilesH:int = data.width/size;
 var numTilesV:int = data.height/size;
 
 for (var i:int = 0; i < numTilesV; i++) {

   for (var j:int = 0; j < numTilesH; j++) {
 newTileSet.push(data.getPixels(new Rectangle(j*size, i*size,
  size, size)));
   }
 }
 return newTileSet; // 12 tiles in the set
   }

The tiles are the 16x16 and these make the star field.
The drag field is separate to that.

I have benefited from looking at this code, and other code,
and I am pleased to be able to give something back
Moock did a great job. Hope that helps.

John


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

[Flashcoders] System.totalMemory value is always going up.

[Abe Pazos]

Hi all, this is my first post here, even I usually read the threads with 
much interest. I've been following the discussion about the FP9 problem 
regarding to memory use and removing loaded assets, which I find very 
important since I work in a large project with hundreds of large loaded 
assets.


I've been doing an experiment today with a simple movie. You can 
download it from http://www.hamoid.com/RamTest.fla
If you run it in the IDE, it traces memory increase since the beginning, 
and it is pretty stable (does increase very little).


BUT if you edit the MC found in the library called "Inside" and drag all 
key frames from frame 3 to frame 1 and run the experiment again, the 
used ram increases at a few Kb / sec. all the time. Is this something I 
should worry about? We have lots of these assets loaded and if each uses 
more and more ram...


I found out about this ram increase while trying to develop a small 
class our designers could use to pause movieclips for a random amout of 
time. You can see the code "new Pause(this, 1, 10);" commented at frames 
1 and 12 of the MC "Inside". The source code for the Pause class is:


package {
   import flash.display.*;
   import flash.events.TimerEvent;
   import flash.utils.Timer;

   public class Pause {
   private var pDisp:MovieClip;
  
   public function Pause(tDisp:MovieClip, tMin:Number, tMax:Number) {

   pDisp = tDisp;
   pDisp.stop();

   var tDiff:Number = tMax - tMin;
   var tTimer:Timer = new Timer(1000 * (tMin + Math.random() * 
tDiff), 1);

   tTimer.addEventListener(TimerEvent.TIMER, onTimer);
   tTimer.start();   
   }

   private function onTimer(tEvent:TimerEvent):void {
   pDisp.play();
   pDisp = null;
   }
   }
}

Some questions: If I use "new Pause(this, 1, 10);" in a frame, without 
storing it into a variable, it could be garbage collected right? Testing 
this file alone works as expected, but maybe in a large project I should 
do "var p:Pause = new Pause(this, 1, 10);" so it's not removed by 
accident. But in this second case, aren't we piling lots of Pause 
objects? Or are the old ones recycled automatically because no one 
references them?


What happens to all the "new Timer"? Are they deleted for the same 
reason? They only run 1 time, and are stored in a temporary variable...


I wish we could have a callback executed when an object is garbage 
collected, then we could know what's going on, otherwise we don't know 
if things get deleted or not (execept if we use the profiler in FB).


Thanks, Abe
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

[Flashcoders] Flex PrintJob image scaling...

[Glen Pike]

Hi

   I am having problems printing a scaled image using the printjob class.

   tracing reports that my image has scaled, but it never prints scaled...

   I have tried setting either the width / height or scale properties 
of the image and the image container, but nothing seems to work.  Can 
anyone spot any "deliberate" (ahem) mistakes??


   As a test, I put this on the stage - the image is scaled on stage 
when setting width / height or scale.


   Here is some code (printedImage is declared in mxml).

   public function printPages():void {
   var pj:PrintJob = new PrintJob();
   var pagesToPrint:int = 0;
   var options:PrintJobOptions = new PrintJobOptions();
   options.printAsBitmap = true;

   if(pj.start()) {
  
   //what's the orientation?

   if(PrintJobOrientation.LANDSCAPE == pj.orientation) {
   printedImg.rotation = -90;
   }
  
   //scale the width / height... is this affected by 
rotation??

   var w:int = pj.pageWidth;
   var h:int = pj.pageHeight;
  
   var printWidth:int = printedImg.width;

   var printHeight:int = printedImg.height;
  
   var origWidth:int = printWidth;

   var origHeight:int = printHeight;
  
   //If we are printing on twoPages we only want to 
scale the image to fit half on one page.

   if(true == twoPages) {
   printWidth = Math.ceil(Number(printWidth) / 
2);   
   }
  
   var pScaleX:Number = w / printWidth;

   var pScaleY:Number = h / printHeight;
   //
   trace("w " + w  + " h " + h + " printW " + 
printWidth + " printH " + printHeight + " pScaleX " + pScaleX + " 
pScaleY " + pScaleY);

   if(pScaleX < pScaleY) {
   /*printedImg.width = Math.floor(pScaleX * 
printedImg.width);
   printedImg.height = Math.floor(pScaleX * 
printedImg.height);*/

   printedImg.scaleX = pScaleX;
   printedImg.scaleY = pScaleX;
   } else {
   /*printedImg.width = Math.floor(pScaleY * 
printedImg.width);
   printedImg.height = Math.floor(pScaleY * 
printedImg.height);*/

   printedImg.scaleX = pScaleY;
   printedImg.scaleY = pScaleY;
   }
  
   trace("will print w " + printedImg.width + " h " + 
printedImg.height + " scale " + printedImg.scaleX + "," + 
printedImg.scaleY);

   try
   {
   var rect:Rectangle = new Rectangle(0, 0, 
(this.width / 2), this.height);
  
   if(true == twoPages) {

   pj.addPage(printedImg, rect, options);
   } else {
   rect.width = printedImg.width;
   pj.addPage(printedImg, rect, options);
   }
   pagesToPrint++;
   if(true == twoPages) {
   rect.x = rect.width = (printedImg.width / 2);
   pj.addPage(printedImg, rect, options);
   pagesToPrint++;
   }
   }
   catch (error:Error)
   {
   trace("printJob error " + error.message);
   }
   if(0 < pagesToPrint) {
   pj.send();   
   }

   printedImg.width = origWidth;
   printedImg.height = origHeight;
  
   } else {

   trace("print job cancelled");
   }
   }
--

Glen Pike
01326 218440
www.glenpike.co.uk 

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

[Flashcoders] Double lines from PHP

[Elia Morling]

I'm sending some form data from PHP to flash and all line feeds turn out to 
be double lines in flash.


I'm using a textfield and htmlText. I tried to conver chr(13) and chr(10) to 
 but it doesn't work.

I also tried turning chr(13) to chr(10) and vice versa without luck.

Any ideas?

Elia 
___

Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Question AIR Sqlite api

[Jiri Heitlager]

Thanx Muzak, I will try your solution

Muzak wrote:

I think I had a similar error when one of the statements wasn't valid.
In this case I'd think that one of the tables already exists (which ends 
the transaction) and when the next statement is exectuted it throws the 
error you see.


Here's something I used:

  try {
   _sqlConnection.begin();
   //
   // sql statements here
   //
   _sqlConnection.commit();
  }catch(e:SQLError) {
   trace("- message; ", e.message);
   trace("- details: ", e.details);
   _sqlConnection.rollback();
  }

 }

When creating a table it is a good idea to check if the table already 
exists.


'CREATE TABLE IF NOT EXISTS ...'

regards,
Muzak

- Original Message - From: "Jiri Heitlager" 
<[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 10:19 AM
Subject: Re: [Flashcoders] Question AIR Sqlite api


OK, I relplied a bit in a hurry and didnt make myself clear. That is 
stupid of me, and I am sorry.
The situation is like so. I open a connection using OpenAsync. I have 
listeners listening to the Open event. When that is fired, I response 
with a method that creates 3 tables in one go, see code below. I keep 
getting an error, also shown below. If in the whole story I use open 
instead of openAsync, everything works perfect. I have now idea why 
that is??




Error: Error #3105: Operation is only allowed if a connection has an
open transaction.
at Error$/throwError()
at flash.data::SQLConnection/commit()
at
classes.models::SQLProxy/createDatabase()[/Users/Jiri/Documents/_Flash/SmsApp/SmsApplication/src/classes/models/SQLProxy.as:128] 


Debug session terminated.




private function createDatabase(e:Event):void
{

Sql_conn.addEventListener(SQLEvent.COMMIT , onDatabaseCreated);

Sql_conn.begin();

var createTable:SQLStatement =  new SQLStatement()
createTable.sqlConnection = Sql_conn
createTable.text = 'CREATE TABLE contacts (index_id INTEGER PRIMARY
KEY , name TEXT , phone NUMBER )';
createTable.execute();

var createErrors:SQLStatement =  new SQLStatement()
createErrors.sqlConnection = Sql_conn
createErrors.text = 'CREATE TABLE errors (index_id INTEGER PRIMARY
KEY , error_id INTEGER , type TEXT )';
createErrors.execute();

var createArchive:SQLStatement =  new SQLStatement()
createArchive.sqlConnection = Sql_conn
createArchive.text = 'CREATE TABLE sms_archive (index_id INTEGER
PRIMARY KEY , sms TEXT , receiver NUMBER , sender NUMBER )';
createArchive.execute();

Sql_conn.commit();

}


Muzak wrote:

Then I'm not sure I understand what your problem is.
You said it works when using openAsync()..


The weird thing is that when I use openAsync instead of open, it does 
work?



- Original Message - From: "Jiri Heitlager" 
<[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Thursday, April 17, 2008 10:52 PM
Subject: Re: [Flashcoders] Question AIR Sqlite api


weird...I will have to look into that and see if there is a work 
around, because I would really like to work with openAsync.


J.

Muzak wrote:

Because when adding listeners you are implying asynchronous mode.
In other words, as soon as you add listeners, you have to use 
openAsync().


I've found the use of synchronous mode to be alot easier.

regards,
Muzak



___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders



___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] RE: Zend Framework PHP question

[Glen Pike]

Hi,

   If you are changing the php.ini file, you may need to restart your 
webserver.  Make sure changes have taken effect by running phpinfo(); ?> and searching for the include path.


   If it still ain't working, watch out for multiple php.ini files - 
XAMPP and some other "all-in-one-webdev" packages use more than one - 
the output from phpinfo() should tell you which php.ini file is being 
used (sometimes this is in OS directory).  If you are on hosting, you 
will need to see if you are allowed to override the include path, etc.


   If this does not work, you may have to do a normal include / 
include_once / require / require_once at the top of your application.


   HTH

   Glen

Anthony Cintron wrote:

Hi All, this is a far fetched question, but I'll give it a try. Anyone
familiar with the Zend framework? I want to add the library to the PHP
include, but I don't fully understand what it is I need to do. I added the
directory and also switch out the php lib for the zend lib. I'm not seeing
any results. Has anyone had an experience with this?

  


--

Glen Pike
01326 218440
www.glenpike.co.uk 

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

[Flashcoders] 64 bit OS and FMS

[Hans Wichman]

Hi,

does n1 have any experience with running FMS on a 64bit Vista OS?
We are migrating one of our testservers shortly and we are trying to
identify possible bottlenecks.

greetz
JC
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Question AIR Sqlite api

[Muzak]

I think I had a similar error when one of the statements wasn't valid.
In this case I'd think that one of the tables already exists (which ends the transaction) and when the next statement is exectuted 
it throws the error you see.


Here's something I used:

  try {
   _sqlConnection.begin();
   //
   // sql statements here
   //
   _sqlConnection.commit();
  }catch(e:SQLError) {
   trace("- message; ", e.message);
   trace("- details: ", e.details);
   _sqlConnection.rollback();
  }

 }

When creating a table it is a good idea to check if the table already exists.

'CREATE TABLE IF NOT EXISTS ...'

regards,
Muzak

- Original Message - 
From: "Jiri Heitlager" <[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Friday, April 18, 2008 10:19 AM
Subject: Re: [Flashcoders] Question AIR Sqlite api



OK, I relplied a bit in a hurry and didnt make myself clear. That is stupid of 
me, and I am sorry.
The situation is like so. I open a connection using OpenAsync. I have listeners listening to the Open event. When that is fired, I 
response with a method that creates 3 tables in one go, see code below. I keep getting an error, also shown below. If in the whole 
story I use open instead of openAsync, everything works perfect. I have now idea why that is??




Error: Error #3105: Operation is only allowed if a connection has an
open transaction.
at Error$/throwError()
at flash.data::SQLConnection/commit()
at
classes.models::SQLProxy/createDatabase()[/Users/Jiri/Documents/_Flash/SmsApp/SmsApplication/src/classes/models/SQLProxy.as:128]
Debug session terminated.




private function createDatabase(e:Event):void
{

Sql_conn.addEventListener(SQLEvent.COMMIT , onDatabaseCreated);

Sql_conn.begin();

var createTable:SQLStatement =  new SQLStatement()
createTable.sqlConnection = Sql_conn
createTable.text = 'CREATE TABLE contacts (index_id INTEGER PRIMARY
KEY , name TEXT , phone NUMBER )';
createTable.execute();

var createErrors:SQLStatement =  new SQLStatement()
createErrors.sqlConnection = Sql_conn
createErrors.text = 'CREATE TABLE errors (index_id INTEGER PRIMARY
KEY , error_id INTEGER , type TEXT )';
createErrors.execute();

var createArchive:SQLStatement =  new SQLStatement()
createArchive.sqlConnection = Sql_conn
createArchive.text = 'CREATE TABLE sms_archive (index_id INTEGER
PRIMARY KEY , sms TEXT , receiver NUMBER , sender NUMBER )';
createArchive.execute();

Sql_conn.commit();

}


Muzak wrote:

Then I'm not sure I understand what your problem is.
You said it works when using openAsync()..


The weird thing is that when I use openAsync instead of open, it does work?


- Original Message - From: "Jiri Heitlager" <[EMAIL PROTECTED]>
To: "Flash Coders List" 
Sent: Thursday, April 17, 2008 10:52 PM
Subject: Re: [Flashcoders] Question AIR Sqlite api



weird...I will have to look into that and see if there is a work around, 
because I would really like to work with openAsync.

J.

Muzak wrote:

Because when adding listeners you are implying asynchronous mode.
In other words, as soon as you add listeners, you have to use openAsync().

I've found the use of synchronous mode to be alot easier.

regards,
Muzak



___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders



___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Re: [Flashcoders] Question AIR Sqlite api

[Jiri Heitlager]

OK, I relplied a bit in a hurry and didnt make myself clear. That is 
stupid of me, and I am sorry.
The situation is like so. I open a connection using OpenAsync. I have 
listeners listening to the Open event. When that is fired, I response 
with a method that creates 3 tables in one go, see code below. I keep 
getting an error, also shown below. If in the whole story I use open 
instead of openAsync, everything works perfect. I have now idea why that 
is??




Error: Error #3105: Operation is only allowed if a connection has an
open transaction.
at Error$/throwError()
at flash.data::SQLConnection/commit()
at
classes.models::SQLProxy/createDatabase()[/Users/Jiri/Documents/_Flash/SmsApp/SmsApplication/src/classes/models/SQLProxy.as:128]
Debug session terminated.




private function createDatabase(e:Event):void
{

Sql_conn.addEventListener(SQLEvent.COMMIT , 
onDatabaseCreated);

Sql_conn.begin();

var createTable:SQLStatement =  new SQLStatement()
createTable.sqlConnection = Sql_conn
createTable.text = 'CREATE TABLE contacts (index_id 
INTEGER PRIMARY
KEY , name TEXT , phone NUMBER )';
createTable.execute();

var createErrors:SQLStatement =  new SQLStatement()
createErrors.sqlConnection = Sql_conn
createErrors.text = 'CREATE TABLE errors (index_id 
INTEGER PRIMARY
KEY , error_id INTEGER , type TEXT )';
createErrors.execute();

var createArchive:SQLStatement =  new SQLStatement()
createArchive.sqlConnection = Sql_conn
createArchive.text = 'CREATE TABLE sms_archive 
(index_id INTEGER
PRIMARY KEY , sms TEXT , receiver NUMBER , sender NUMBER )';
createArchive.execute();

Sql_conn.commit();

}


Muzak wrote:

Then I'm not sure I understand what your problem is.
You said it works when using openAsync()..


The weird thing is that when I use openAsync instead of open, it does work?


- Original Message - From: "Jiri Heitlager" 
<[EMAIL PROTECTED]>

To: "Flash Coders List" 
Sent: Thursday, April 17, 2008 10:52 PM
Subject: Re: [Flashcoders] Question AIR Sqlite api


weird...I will have to look into that and see if there is a work 
around, because I would really like to work with openAsync.


J.

Muzak wrote:

Because when adding listeners you are implying asynchronous mode.
In other words, as soon as you add listeners, you have to use 
openAsync().


I've found the use of synchronous mode to be alot easier.

regards,
Muzak



___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders


___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders