[flexcoders] Opening open office document (calc) inside iframe

2012-06-12 Thread isa_loyer
Hi,
I search a solution to open a calc document (Ooo) inside my AIR application, 
perhaps inside an iFrame?
But I don't know how to do that.
Can you help me.

Thanks



[flexcoders] List item drag to datagrid

2012-05-29 Thread isa_loyer
Hi,

I work with AIR.

I have to window, one with list ( a glossary) and another with datagrid and 
editable cells.
The goal is to drag item on list and drop it on cursor position on itemEditor 
(datagrid).
I don't know how to do that.

Please, help me.
Thanks



[flexcoders] Apply style on text range in a Spark DataGrid?

2012-05-23 Thread isa_loyer
Does anyone know a way to apply style on text range in a Spark DataGrid?

I think that the best way is to have an itemrenderer with textarea but after, I 
don't know how to do.

My goal isn't to change color label if cell is selected. Indeed, in my dream, 
item is editable, and you can selected only some words inside cell and apply a 
specific style to the selected part of text (by click on a button, one for 
bold, one for italic...). Than, text may be store in database like html text.

I'd like use cell itemrenderer like a RichTextEditor but without ControlBar. In 
my case, I'd like to have only one control bar outside the datadgrid.

I'll happy, if you can help me.

Thanks



[flexcoders] mx:TileList : Why drag doesn't works if allowMultipleSelection is activate

2012-05-14 Thread isa_loyer
I work with TileList to display image like a gallery. At start, I activate only 
drag option.

mx:TileList xmlns:fx=http://ns.adobe.com/mxml/2009;
 xmlns:s=library://ns.adobe.com/flex/spark
 xmlns:mx=library://ns.adobe.com/flex/mx
 columnWidth=120
 rowHeight=150
 paddingLeft=2
 paddingRight=2
 paddingTop=2
 paddingBottom=2
 itemRenderer=fr.ui.display._43Imagerie.TileUnit2
 doubleClickEnabled=true
 dragEnabled=true
 dropEnabled=true
 dragMoveEnabled=true
 verticalScrollPolicy=on
 
Now I try to add multiple selection possibility.

If this option is true (allowMultipleSelection), drag stop to work, do you know 
why?

Thanks for helping.



[flexcoders] air customize about window

2012-05-14 Thread isa_loyer
I work with Flashbuilder 4.6 and Air application on Mas Os and I'd like to 
customize About MyApp window.

I know that all information about this window is in Adobe AIR Application 
Descriptor File, but I don't know how to customize.

Do you know how to do that?

Thanks for helping.



[flexcoders] Reduce time to load httpservice result

2012-03-29 Thread isa_loyer
Hi,

I do a query to mysql database with httpservice.
The result contains arround 6 records.
Time to create xml file is arround 40s, to slow for my customer.

I try to accelerate the process with different methods, on server side, to 
generate file
DOMDocument
XmlWriter
SimpleXMLElement

As customer must be able to sort datagrid, I can not use pagging.

So do you have an idea to load datagrid more speedly.

Thanks



[flexcoders] how to add nativemenu on topLevelApplication

2012-03-08 Thread isa_loyer
I developp a AIR application.

I try to add menu on it.

My application has custom chrome, and I like to have a transparent background 
on main application.

Today, I insert the nativemenu on a native window:

 FlexGlobals.topLevelApplication.visible = false;
var options:NativeWindowInitOptions = new 
NativeWindowInitOptions(); 
options.systemChrome = NativeWindowSystemChrome.STANDARD; 
options.transparent = false; 
options.maximizable= false;
options.resizable = false;
menuWindow = new NativeWindow(options); 
menuWindow.width = Capabilities.screenResolutionX; 
menuWindow.height = 55; 
menuWindow.x = 0;
menuWindow.y = 0;


menuWindow.title = MyApp;
menuWindow.menu = menuBarSE.initMenuOE();
menuWindow.alwaysInFront = true; 
menuWindow.activate();   
menuWindow.addEventListener(Event.CLOSING, 
applicationExitHandler);

But, with this approach is difficult to manage other window, like reduce or 
maximize action.

So, if it's possible I'd like to add the menu on the main window 
(topLevelApplication), but I don't know how!

If someone could help me.

thanks



[flexcoders] how to add nativemenu on topLevelApplication

2012-03-08 Thread isa_loyer
I developp a AIR application.

I try to add menu on it.

My application has custom chrome, and I like to have a transparent background 
on main application.

Today, I insert the nativemenu on a native window:

 FlexGlobals.topLevelApplication.visible = false;
var options:NativeWindowInitOptions = new 
NativeWindowInitOptions(); 
options.systemChrome = NativeWindowSystemChrome.STANDARD; 
options.transparent = false; 
options.maximizable= false;
options.resizable = false;
menuWindow = new NativeWindow(options); 
menuWindow.width = Capabilities.screenResolutionX; 
menuWindow.height = 55; 
menuWindow.x = 0;
menuWindow.y = 0;


menuWindow.title = MyApp;
menuWindow.menu = menuBarSE.initMenuOE();
menuWindow.alwaysInFront = true; 
menuWindow.activate();   
menuWindow.addEventListener(Event.CLOSING, 
applicationExitHandler);

But, with this approach is difficult to manage other window, like reduce or 
maximize action.

So, if it's possible I'd like to add the menu on the main window 
(topLevelApplication), but I don't know how!

If someone could help me.

thanks



[flexcoders] HttpService resultHandler in different Window

2012-02-13 Thread isa_loyer
I am working on an AIR application with 2 windows: One to create a new customer 
and another to display some information about the customer. On window 1, there 
is also a textfield to search for a customer by Id or name.

These are the steps to create a new customer:

with an add button on window 1, I open window 2.
on window 2, the user completes a form to create a new customer.
the information is saved in a MySQL Database over an HttpService.
The result handler method calls a public function on window 1:

result = new wWin1().resultSaveCustomer(event)
This part works well - the new customer Id is received.

In some cases, according customer data, I change the component color - this 
operation works well, if I load a customer after a using the search field, but 
if I search directly from the resultSaveCustomer function (after completion of 
step 3), a message appears:

Cannot access a property or method of a null object reference.

I don't understand why, because all the components in window 1, have an Id 
name! Or the property is a label with Id Name.

Thanks for helping me.



[flexcoders] Flex icon filed on list

2012-01-29 Thread isa_loyer
Hi,

I load label and icon from mysql database.

and i'd like to create a list with label and icon field.

So I try to do something like that but it doesn't work indeed each line contain 
label but icon is empty.

  

var xmllisteFamille:XMLList = XML(event.result).famille;
var xmlListCollFami = new 
XMLListCollection(xmllisteFamille);
for each (var item:Object in 
xmlListCollFami){
var vbox:VBox = new VBox;
vbox.label = item.sdfNom;
trace(vbox.label);
vbox.percentHeight=100;
vbox.percentWidth=100;
var xmlItem2:XMLList = 
item.commDent;
if(xmlItem2.length()0){

/*
var 
listAcc:List = new List();

listAcc.percentHeight = 100;

listAcc.percentWidth =100;

listAcc.labelField = name;

listAcc.dataProvider = xmlItem2;

vbox.addChild(listAcc);

accOnglet1.addChild(vbox); */
var urlImageRoot : 
urlManager = new urlManager();
var 
urlRootDental:String = urlImageRoot.urlDental();
trace(urlRootDental);
var list:Array = new 
Array();
var object:Object;

var 
xmlListdetail:XMLListCollection = new XMLListCollection(xmlItem2);
for each (var 
item2:Object in xmlListdetail)
{

object = new 
Object();
// -- --
object.label = 
item2.name;

var 
rootIcon:String= http://127.0.0.1:10088/Sys/OEMySQL/Dental/+item2.photo;
trace(rootIcon 
 + rootIcon);

object.icon = 
rootIcon;


trace(object.icon  + object.icon);


list.push(object);
}

/* var aNode:XML;
for each (aNode in 
xmlItem2)
{
object = new 
Object();
// -- --
object.label = 
aNode.name;
object.icon = 
new urlManager().urlDental()+aNode.photo;

list.push(object);
} */

var arrList:ArrayList;

arrList = new 
ArrayList(list);
var listAcc:List = new 
List();
listAcc.percentHeight = 
100;

[flexcoders] ToggleButtonBar - how to change color for only one button

2012-01-20 Thread isa_loyer
I have a tooglebuttonbar (with 4 buttons) and I'd like to change the color of 
only one or two button according particular data. Is someone has experience to 
do that.

I try to do like that

 var child:Button;
   child = Button(tbbAction2.getChildAt(0));
child.setStyle('color', '#CC33CC');
But there's no effect. Thanks a lot.



[flexcoders] AIR - Content resize according window

2012-01-17 Thread isa_loyer
Hi,

I have a window witch is resizing on creationcomplete phase according user 
preference.
This part woks well.
But inside this window a s:Group exists and even if width and height is in 
percent, the s:Group size is bigger that the new window measure.

I try to solve that with percentheigt and percentwidth but no result.
If somebody know how to solve that, I'll happy to read.

Thanks a lot



[flexcoders] Fill pdf form with Flex

2011-12-19 Thread isa_loyer
Hi,


I'd like to fill a pdf form with flex.
Data are on my air application and I want to use those to fill a pdf file store 
on my computer.
Do you have an idea to do that?

thanks



[flexcoders] Border container create generic mouseOver function

2011-12-15 Thread isa_loyer
Hi,

I try to create a function to change border property of border container.
To do that I create a function for each border container on my MXML.

But I'd to code better and to do a generic function.

Today my function is:

protected function bcContact_mouseOverHandler(event:MouseEvent):void
{
// TODO Auto-generated method stub
bcContact.setStyle(borderVisible,true);
bcContact.setStyle(borderWeight,2);
bcContact.setStyle(borderColor,'#99');
}

bcContact is one border container Id.

I try to replace bcContact by this but it doesn't work.

Can you help me to solve this beginner mistake.

Thanks



[flexcoders] AIR - Create windows skin accordind Os (Mac/Windows)

2011-11-28 Thread isa_loyer
Hi, 

I' create a window skin for my AIR application.
Close, maximise and minimise button are on top right and look like Windows 7.

But , mac user are desapointed, so my question is : is it possible to apply a 
different window skin according user Os.

If yes, how to do that.

Thanks



[flexcoders] Filter arraycollection with selected node

2011-11-21 Thread isa_loyer
Dear Flexer,

I have a tree with checkbox.
My tree has parent and children element.
I'd like to filter an arraycollection with consider only tree node selected.

Can you help me to do that.

Thank



[flexcoders] Flex HTTP Service Charset

2011-10-31 Thread isa_loyer
Dear Flexer, 

I'm a french user, and I have some problem with charset.

Indeed, I try to use httpservice to load data in datagrid.

To do that, I use the php file, you can read below.

?php
include 'functions.php';
require_once 'MySQL.php';
require_once 'conf.php';

header(Content-Type: text/xml; charset=ISO-8859-1); 


$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_DATABASE);
if (mysqli_connect_errno()) {
printf(Échec de la connexion : %s\n, mysqli_connect_error());
exit();
}

// If a connection was established, run the query:
if ($dbc) { 
// Define the query:
$q ='SELECT 14TypeRdv.trIndex, 14TypeRdv.trCode, 14TypeRdv.trNom, 
14TypeRdv.trDurDef, 14TypeRdv.trDurPrat, 14TypeRdv.trCouleur FROM 14TypeRdv';
}

// Run the query:
$r = mysqli_query($dbc, $q);

$reponse = typeRDVs;


// Confirm that some rows were returned:
if (mysqli_num_rows($r)  0) {
// Fetch every row and print it as XML:
while ($row = mysqli_fetch_array($r, MYSQLI_NUM)) {
 $reponse.=typeRDVid.$row[0]./id;
 $reponse.=code.$row[1]./code;
 $reponse.=nom.$row[2]./nom;
 $reponse.=duree.$row[3]./duree;
 $reponse.=tps.$row[4]./tps;
$reponse.=color.$row[5]./color;

  $reponse.=/typeRDV;
 
} 
} 

else
{
$reponse.=typeRDV/typeRDV;

}
$reponse.=/typeRDVs;

echo $reponse;

?



But when I test it in my brower the message xml file worth formatted appear.
In flex, an error appear.

Can you help me to solve that.

Thanks



[flexcoders] Flex 4.5 - Cell background color in datagrid

2011-10-29 Thread isa_loyer
Hi,
 
I load some data with httpservice.
In those data, I have a backgound color for each cell.
Can you explain how to do to change background color accordind data in 
dataprovider?
I thinks I must use itemrender but I don't found how to use dataprovider data 
to do that.
 
Thaks for helping.



[flexcoders] AIR Openwithdefaultapplication

2011-10-28 Thread isa_loyer
Hi,
 
I'd like to use Open with default application to open file located on my 
remote server.
But this command seems not working with path like 
http://127.0.0.1/MyAPP/Docs/Myvideo.docx.
 
Can you help me to solve that.

Thanks



[flexcoders] AIR how to complete and print a pdf file

2011-10-28 Thread isa_loyer
Hi, 

In my app, user has a pdf witch may use like a template.
It's an administrative form that may be complete with mysql data.

My goal is to create this pdf and insert field, all must be done inside my air 
application.

When people wants to print this document, field must be replace by good value 
after request to database.

My problem, is:
How to open pdf in air and store field name inside document,
Second, how replace field by good values during print job.

Thanks for helping.




[flexcoders] AIR and PDF

2011-10-25 Thread isa_loyer
Hi,

I'd like to complete and to print a pdf inside an air window.
Could you help me to find a solution.

Thanks



[flexcoders] AIR - PHP : How to load local file to remote server

2011-10-24 Thread isa_loyer
Dear Flex,

I search some idea to load local file to remote server with php.
I try to do that, but it didn't works

 var rq:URLRequest = new URLRequest(new urlManager().urlService() + 
upload.php);
rq.method = URLRequestMethod.POST;
var varphp:URLVariables = new 
URLVariables();
varphp.userID = monIdPatient;
varphp.url = myFileDir;

rq.data = varphp;
file.upload(rq, 'Filedata');


?php
if(isset($_POST['myFileDir']))  
$patRoot=$_POST['myFileDir'];

$file_temp = $_FILES['Filedata']['tmp_name'];
$file_name = $_FILES['Filedata']['name'];

$file_path = $_SERVER['DOCUMENT_ROOT'].$patRoot;

//checks for duplicate files
if(!file_exists($file_path./.$file_name)) {

 //complete upload 
 $filestatus = move_uploaded_file($file_temp,$file_path./.$file_name);

 if(!$filestatus) {
 $success = false;
 array_push($errors,Upload failed. Please try again.);
 }

}
else {
$success = false;
array_push($errors,File already exists on server.);
}

echo $file_path;



Thanks for helping.



[flexcoders] Why hhtpservice is too long

2011-10-21 Thread isa_loyer
Dear flexer,

I try to load a datagrid with httpservice.
But, I'm so desapointed because load about 17000 lines take around 5 sec.
So can you help me to optimize this time.

?php 

// Send the content-type header:
header('Content-Type: text/xml');


// Include the database information script:
require_once ('MySQL.php');
require_once ('conf.php');
include('functions.php');

// Connect to the database:
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_DATABASE);

// If a connection was established, run the query:
if ($dbc) { 

// Define the query:
$q ='SELECT 20Patients_1012.paIndex, 20Patients_1012.paNomP, 
20Patients_1012.paPrenom, 20Patients_1012.paCodePostal, 
20Patients_1012.paDossier1, 20Patients_1012.paDossier2, 
20Patients_1012.paNaissance, 20Patients_1012.paNumTel1, 
30Traitemnt_201223.ttTStatutP, 30Traitemnt_201223.ttDateStatut, 
12Praticien_02.prInitiales FROM 20Patients_1012 JOIN 30Traitemnt_201223 ON 
20Patients_1012.paIndex = 30Traitemnt_201223.ttIndex JOIN 12Praticien_02 ON 
30Traitemnt_201223.ttPraticien = 12Praticien_02.prIndex';
}

// Run the query:
$r = mysqli_query($dbc, $q);

$reponse = patients;

// Confirm that some rows were returned:
if (mysqli_num_rows($r)  0) {
// Fetch every row and print it as XML:
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
 $reponse.=id.$row[0]./idpr.$row[2]./prst
.$row[8]. .$row[9]./std1.$row[4]. / 

.$row[5]./d1dn.$row[6]./dnpr2.$row[10]./pr2
.dn.$row[6]./dn;

} // End of WHILE loop.


} // End of mysqli_num_rows() IF.

} // End of $dbc IF.

// Complete the XML:
$reponse.=/patients;
printf (%s,$reponse);

mysql_free_result($reponse);
?

Thanks



[flexcoders] How to create php/apache/mysql installer with AIR

2011-10-17 Thread isa_loyer
Dear Flexer,

I'd like to use AIR to create my own web tools installer (like mamp, wammp...).

But I have no idea how to do that.

Can you help me?

Thanks



[flexcoders] Preview a PDF inside your AIR application inside transparent and custom window

2011-09-20 Thread isa_loyer
I have a transparent windows (skinnable). Inside, I'd like to preview some pdf 
file. BUT, in the only a black screen appear, can you help me?

Thanks



[flexcoders] s:Group arrange component on the same center

2011-09-01 Thread isa_loyer
I use a s:Group to place my component in my form. I'd like all form item have 
the same horizontal align inside the group. I try to use horizontalcenter with 
value 0 but it doesn't work. So I don't know how to do and I hope you can help 
me to solve that.

s:Group width=100% resizeMode=noScale verticalCenter=0 
horizontalCenter=0


s:FormItem label=Naissance tabIndex=5 
x={cbQualite.x} id=fiNaissance
mx:DateField id=dfNaissance width=100 
editable=true 
  formatString=DD/MM/ 
yearNavigationEnabled=true
  /
/s:FormItem
s:RadioButton id=rbFem label=Féminin 
group={rbsex} tabIndex=7 
   x={fiNaissance.x + 
fiNaissance.width+5} 
   /

s:RadioButton id=rbMas label=Masculin 
group={rbsex} tabIndex=6 x={rbFem.width + rbFem.x + 5} y={fiNaissance.y 
+(fiNaissance.height)/2}/
s:DropDownList id=cbDossier2 
dataProvider={DP_PAT_DOS1} width=118 height=22 tabIndex=8 
x={cbDossier1.x}/
s:FormItem label= tabIndex=9 x={fiDossier1.x} 
s:TextInput id=fDossier2 width=90 
paddingRight=5 text=@{objectPatient.paDossier2} /
/s:FormItem

/s:Group



[flexcoders] Move on DropDownList with up or dow key (FB 4.5)

2011-08-10 Thread isa_loyer
Dear Flexer,

I have a form in custom titleWindow.
I this form, I place DropDownList.
In this list, I'd like to select item with up or down key, but it doesn't work.
Should I implement this?

**

s:Form x=0 y=94 id=foPerso width=100% height=100% 
includeInLayout=true includeIn=tb1 
backgroundColor=#F

s:layout
s:FormLayout gap=3 paddingLeft=0/ 

/s:layout



s:HGroup width=100% gap=3 horizontalAlign=left 
resizeMode=noScale
  verticalAlign=baseline 


s:DropDownList id=cbQualite dataProvider={DP_PAT_CIVIL}
selectedItem={getSelectedItem(DP_PAT_CIVIL, 
objectPatient.paQualPatient)} 
change=objectPatient.paQualPatient = 
event.currentTarget.selectedItem.label/

s:FormItem label=Nom 
s:TextInput id=fdNom width=200 
 text=@{objectPatient.paNomU}

 /
/s:FormItem
s:FormItem  label=Prénom 
s:TextInput id=fdPrenom width=200 
text=@{objectPatient.paPrenom}/
/s:FormItem
s:DropDownList id=cbDossier1 dataProvider={DP_PAT_DOS1} 
width=118 height=22 tabIndex=3
change=objectPatient.paQualPatient = 
event.currentTarget.selectedItem.label
/

s:FormItem label= 
s:TextInput id=fDossier1 width=90 paddingRight=5 
text=@{objectPatient.paDossier1}/
/s:FormItem
/s:HGroup

/s:Form
**

Thanks



[flexcoders] Flex 4.5 - Custom NativeWindow and problems

2011-08-10 Thread isa_loyer
I have a class FlexNativeWindow who extends to NativeWindow.
I use this method to create new window on my AIR app.
All works well but some keyboard interraction is not availaible.

For exemple focus arround textinput is not visible.
Key down and up don't work on DropDownList.
TabOrder doesn't work well!

Can you explain Why? Because I'm very desapointed!

Code to create the new window

var wdetcorr:wDetailCorrespondant = new wDetailCorrespondant();
wdetcorr.monIdCorresp = 
correspDG.selectedItem.crIndex;

var wOptions:NativeWindowInitOptions = new 
NativeWindowInitOptions();
wOptions.systemChrome = 
NativeWindowSystemChrome.NONE;
wOptions.transparent = false;
var fnwDetailPatient:FlexNativeWindow = new 
FlexNativeWindow(wdetcorr, wOptions);
fnwDetailPatient.active();



Code about my custom NativeWindow


package fr.int.ui.windowSkin
{
import flash.display.NativeWindow;
import flash.display.NativeWindowInitOptions;
import flash.events.Event;
import flash.events.KeyboardEvent;
import flash.ui.Keyboard;

import mx.core.IUIComponent;
import mx.core.IVisualElement;
import mx.core.IVisualElementContainer;
import mx.core.UIComponent;
import mx.events.*;
import mx.managers.WindowedSystemManager;

[Event(name=creationComplete, type=mx.events.FlexEvent)]

public class FlexNativeWindow extends NativeWindow implements 
IFlexNativeWindow
{
private var _systemManager:WindowedSystemManager;

private var _content:UIComponent;

private var _window:IVisualElementContainer;

public function 
FlexNativeWindow(window:IVisualElementContainer, 
initOptions:NativeWindowInitOptions = null)
{
super(initOptions);


_window = window;

addEventListener(Event.ACTIVATE, windowActivateHandler);

}

public function addElement(control:IVisualElement):void
{
_window.addElement(control);
}

public function removeElement(control:IVisualElement):void
{
_window.removeElement(control);
}

private function windowActivateHandler(event:Event):void
{
event.preventDefault();
event.stopImmediatePropagation();
removeEventListener(Event.ACTIVATE, 
windowActivateHandler);

if (stage)
{
if (!_systemManager)
_systemManager = new 
WindowedSystemManager(IUIComponent(_window));

stage.addChild(_systemManager);

dispatchEvent(new 
FlexEvent(FlexEvent.CREATION_COMPLETE));

stage.addEventListener(Event.RESIZE, 
windowResizeHandler);
stage.addEventListener(KeyboardEvent.KEY_DOWN, 
keyDownListener);

}
}

private function keyDownListener (e:KeyboardEvent):void {

if (e.keyCode == Keyboard.ESCAPE) {
stage.nativeWindow.dispatchEvent(new 
Event(myEventClose, true));
stage.nativeWindow.close();
}


}

private function windowResizeHandler(event:Event):void
{
// prise en compte de la valeur mini
UIComponent(_window).height = stage.stageHeight;
UIComponent(_window).width = stage.stageWidth;


}
}
}




[flexcoders] HTTPService e4x Error #1095: XML parser failure: Unterminated attribute

2011-08-08 Thread isa_loyer
Dear Flexer,

I'd like to load data from my database with an httpservice and result on e4x 
format.

If on php side, I add only 12 row all works well, but if I try to load more 
than 12 rows this errror appear Error #1095: XML parser failure: Unterminated 
attribute.


Can you help me to solve that?

Thanks


**  My Php code **

?php
require_once ('MySQL.php');
require_once ('conf.php');
include('functions.php');

// On commence par récupérer les champs 
//if(isset($_POST['idPatient']))  
//$id=$_POST['idPatient'];


$link = mysql_connect(DB_HOST,DB_USER, DB_PWD);
mysql_select_db(DB_DATABASE, $link);

$query = SELECT 20Customer_1012.paIndex, 20Customer_1012.paNomU, 
20Customer_1012.paPrenom,20Customer_1012.paDossier1, 
20Customer_1012.paDossier2, 20Customer_1012.paNaissance, 
20Customer_1012.paSexe, 20Customer_1012.paT_Qualite_P, 
20Customer_1012.paNomPar,20Customer_1012.paPrenomPar, 
20Customer_1012.T_AdrDefaut_P, 
20Customer_1012.paAdress1,20Customer_1012.paAdress2,20Customer_1012.paCodePostal,20Customer_1012.paT_Ville_P,20Customer_1012.paPays,20Customer_1012.pa1T_TypeTel_P,20Customer_1012.paSMS1,20Customer_1012.paNumTel1,20Customer_1012.paRemTel1,20Customer_1012.pa2T_TypeTel_P,20Customer_1012.paSMS2,20Customer_1012.paNumTel2,20Customer_1012.paRemTel2,20Customer_1012.pa3T_TypeTel_P,20Customer_1012.paSMS3,20Customer_1012.paNumTel3,20Customer_1012.paRemTel3,20Customer_1012.paFax,20Customer_1012.paEMail,
 20Customer_1012.paProfMere, 20Customer_1012.paProfPatient, 
20Customer_1012.paProfParent, 20Customer_1012.paUserZoneA1, 
20Customer_1012.paUserZoneA2, 20Customer_1012.paUserZoneA3, 
20Customer_1012.paUserZoneA4, 20Customer_1012.paUserZoneA5, 
20Customer_1012.paUserZoneA6, 30Traitemnt_201223.ttTStatutP, 
30Traitemnt_201223.ttDateStatut, 12Praticien_02.prInitiales, 
20Customer_1012.pa2T_Qualite_P
FROM 20Customer_1012
JOIN 30Traitemnt_201223 ON 20Customer_1012.paIndex = 30Traitemnt_201223.ttIndex
JOIN 12Praticien_02 ON 30Traitemnt_201223.ttPraticien = 12Praticien_02.prIndex
WHERE 20Customer_1012.paIndex='16';


$recordset = mysql_query($query, $link);

$dom = new DOMDocument('1.0', 'UTF-8');
$rootNode= $dom-appendChild($dom-createElement('OrthoExpertDB'));

while($row_recordset = mysql_fetch_array($recordset))
{

$record = new DomElement(p, );
$rootNode-appendChild($record);
$record-SetAttribute(id, $row_recordset[0]); //index
$record-SetAttribute(nU, $row_recordset[1]);//nom U
$record-SetAttribute(pr, $row_recordset[2]);//prenom
$record-SetAttribute(d1, $row_recordset[3]);//dossier1
$record-SetAttribute(d2, $row_recordset[4]);//dossier2
$record-SetAttribute(dn, datefr($row_recordset[5]));//naissance
$record-SetAttribute(sx, $row_recordset[6]); //sexe
$record-SetAttribute(paQ, $row_recordset[7]); //qualite patient
$record-SetAttribute(nPar, $row_recordset[8]);
$record-SetAttribute(pPar, $row_recordset[9]); 
$record-SetAttribute(adD, $row_recordset[10]); 
$record-SetAttribute(ad1, $row_recordset[11]); 
$record-SetAttribute(ad2, $row_recordset[12]); 
$record-SetAttribute(cp, $row_recordset[13]);//code postal
$record-SetAttribute(vi, $row_recordset[14]); 
$record-SetAttribute(pi, $row_recordset[15]); 
$record-SetAttribute(tT1, $row_recordset[16]); 
$record-SetAttribute(sms1, $row_recordset[17]); 
$record-SetAttribute(nT1, $row_recordset[18]); 
$record-SetAttribute(rT1, $row_recordset[19]);
$record-SetAttribute(tT2, $row_recordset[20]); 
$record-SetAttribute(sms2, $row_recordset[21]); 
$record-SetAttribute(nT2, $row_recordset[22]); 
$record-SetAttribute(rT2, $row_recordset[23]);
$record-SetAttribute(tT3, $row_recordset[24]); 
$record-SetAttribute(sms3, $row_recordset[25]); 
$record-SetAttribute(nT3, $row_recordset[26]); 
$record-SetAttribute(rT3, $row_recordset[27]);
$record-SetAttribute(fax, $row_recordset[28]); 
$record-SetAttribute(mail, $row_recordset[29]); 
$record-SetAttribute(prPa, $row_recordset[30]); 
$record-SetAttribute(prP, $row_recordset[31]); 
$record-SetAttribute(prMe, $row_recordset[32]); 
$record-SetAttribute(zA1, $row_recordset[33]); 
$record-SetAttribute(zA2, $row_recordset[34]); 
$record-SetAttribute(zA3, $row_recordset[35]); 
$record-SetAttribute(zA4, $row_recordset[36]); 
$record-SetAttribute(zA5, $row_recordset[37]); 
$record-SetAttribute(zA6, $row_recordset[38]); 
$record-SetAttribute(st, $row_recordset[39]);//statut
$record-SetAttribute(dst, $row_recordset[40]);//date statut
$record-SetAttribute(pr2, $row_recordset[41]);//initiale prat
$record-SetAttribute(parQ, $row_recordset[42]);//qualité parent

}
mysql_free_result($recordset);
mysql_close();


print $dom-saveXML();
//echo $xmlStr;
?


** End of php



[flexcoders] Flex e4X escape quote in flex text input

2011-08-08 Thread isa_loyer
Dear Flexer,

I use httpservice to query my database.
when xml data is loaded on text input quote is replace by a square.
How can I solve that.

Thanks



[flexcoders] s:DropDownList selectedItem

2011-08-08 Thread isa_loyer
Dear Flexer,

I'd to use my database field value to select a value on my s:DropDownList 

I try to do s:DropDownList  dataProvider={DP_PAT_CIVIL} 
selectedItem=@{objectUser.usrQualParent}/.

But no selection appear, nothing appear on prompt.

Thanks for helping



[flexcoders] [Important] Simultaneous HTTPService in the same component

2011-08-05 Thread isa_loyer
Dear Flexer,

I created an Air application.
On loading my component, I'd to make simultaneous request to my database to 
load some data to my component.

My component is a form with several comobobox and and text field.

But to do that I have two major problem.
- Sometimes, my form (my component) is loaded but there no information in my 
text field, perhaps request is not finished? but how to verify that and how to 
solve.
- Other question, as requests with http service is for different table, one to 
load sudent, other to load note, other to load teaching , is it possible to do 
this request in the same php file and to get all thos informations with the 
same E4X file.

Thanks for help



[flexcoders] Re: [Important] Simultaneous HTTPService in the same component

2011-08-05 Thread isa_loyer
s:HorizontalLayout/
/s:layout
s:TextInput id=paUserR6  width=220 
text=Rub6 tabIndex=39/
s:CheckBox id=cbRB6 tabIndex=40/
/s:FormItem
/s:HGroup

s:HGroup width=100% horizontalAlign=left 
resizeMode=noScale verticalAlign=baseline
s:FormItem label=Rub3
s:layout
s:HorizontalLayout/
/s:layout
s:TextInput id=paUserR3  width=220 
text=Rub3 tabIndex=41/
s:CheckBox id=cbRB3 tabIndex=42/
/s:FormItem
s:FormItem label=Rub7
s:layout
s:HorizontalLayout/
/s:layout
s:TextInput id=paUserR7  width=220 
text=Rub7 tabIndex=43/
s:CheckBox id=cbRB7 tabIndex=44/
/s:FormItem
/s:HGroup

s:HGroup width=100% horizontalAlign=left 
resizeMode=noScale verticalAlign=baseline
s:FormItem label=Rub4
s:layout
s:HorizontalLayout/
/s:layout
s:TextInput id=paUserR4  width=220 
text=Rub4 tabIndex=45/
s:CheckBox id=cbRB4 tabIndex=46/
/s:FormItem
s:FormItem label=Rub8
s:layout
s:HorizontalLayout/
/s:layout
s:TextInput id=paUserR8  width=220 
text=Rub8 tabIndex=47/
s:CheckBox id=cbRB8 tabIndex=48/
/s:FormItem
/s:HGroup

/s:Form

/s:Group

/windowSkin:NativeTitleWindow

[/code]

--- In flexcoders@yahoogroups.com, isa_loyer isa_loyer@... wrote:

 Dear Flexer,
 
 I created an Air application.
 On loading my component, I'd to make simultaneous request to my database to 
 load some data to my component.
 
 My component is a form with several comobobox and and text field.
 
 But to do that I have two major problem.
 - Sometimes, my form (my component) is loaded but there no information in my 
 text field, perhaps request is not finished? but how to verify that and how 
 to solve.
 - Other question, as requests with http service is for different table, one 
 to load sudent, other to load note, other to load teaching , is it possible 
 to do this request in the same php file and to get all thos informations with 
 the same E4X file.
 
 Thanks for help





[flexcoders] Licence component

2011-08-03 Thread isa_loyer
Dear Flexer,

I'm developping an AIR application.
I'd like include licence system to protect my soft.

Do you if free component exist or do you have an idea to do that?

Thanks for help



[flexcoders] Form Item Multiline

2011-08-03 Thread isa_loyer
I try to do a beautiful form on my AIR app.
But with s:FormItem, I don't find how to place label in two lines.

Can you help me to solve that?

Thanks.