My application - Google Map API + MySQL + ColdFusion 9 + Flex 4

Are you testing by opening your application with a localhost URL?

Dave Watts, CTO, Fig Leaf Software

http://www.figleaf.com/

http://training.figleaf.com/

I don't have a code example sitting right in front of me, but basically, here's what you're going to do.

On the CF server, you'll write a CF page that uses CFFILE with ACTION="UPLOAD".

On the Flex application, you'll create an instance of flash.net.FileReference. You'll use the browse method to let the user select the file, then use the upload method to initiate the upload. You'll specify an event handler for the upload completion, and optionally another one to track progress.

Google "flex filereference" for more information about the Flex side of things.

Dave Watts, CTO, Fig Leaf Software

http://www.figleaf.com/

http://training.figleaf.com/

Maria Pieroszkiewicz wrote:

I changed in my file cf from cfqueryparams decimal to cfqueryparams float

and I left the MySQL database in decimal and displays correctly :]

Could this all the interpretations.

I don't understand what you changed in ColdFusion.

The original code sample http://wklej.org/id/485525/ had this in createMarkers():

        <cfquery name="qItem" datasource="google_map" result="result"> 
           INSERT INTO markers
               (name, latitude, longitude)
          VALUES
              (<CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#ARGUMENTS.item.name#">,
           <CFQUERYPARAM CFSQLTYPE="CF_SQL_FLOAT" VALUE="#ARGUMENTS.item.latitude#">,
           <CFQUERYPARAM CFSQLTYPE="CF_SQL_FLOAT" VALUE="#ARGUMENTS.item.longitude#">)
        </cfquery>

The last code example http://wklej.org/hash/25d772313a9/ had this createMarkers():

       <cfquery name="qItem" datasource="google_map" result="result"> 
           INSERT INTO markers
               (name, latitude, longitude)
               VALUES
                         (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.name#">,
                 <cfqueryparam cfsqltype="cf_sql_float" value="#arguments.latitude#">,
                 <cfqueryparam cfsqltype="cf_sql_float" value="#arguments.longitude#">)
        </cfquery> 

They are the same.

The FLOAT data is being rounded either in the AMF serialization on directly in the UI.  I think you need to use the Flex NumberFormatter on your FLOAT data.

http://help.adobe.com/en_US/FlashPlatform/reference/actionscript/3/mx/formatters/NumberFormatter.html

I tested inserting and querying the data in ColdFusion (without Flex UI) and the data precision is maintained correctly.

<cfquery datasource="map" name="createTable">
   
    create table markers (
        id MEDIUMINT NOT NULL AUTO_INCREMENT,
        name CHAR(50) NOT NULL,
        latitude FLOAT(10,6) NOT NULL,
        longitude FLOAT(10,6) NOT NULL,       
        PRIMARY KEY (id)
    ) ENGINE=MyISAM;
</cfquery>

<cfset items = ArrayNew(2)>
<cfset items[1][1] = 'Mikolow'>
<cfset items[1][2] = 50.179016>
<cfset items[1][3] = 18.903805>
<cfset items[2][1] = 'Katowice'>
<cfset items[2][2] = 50.264893>
<cfset items[2][3] = 19.023781>

<cfloop from="1" to="#arraylen(items)#" index="i">
    <cfquery name="qItem" datasource="map" result="result">
       INSERT INTO markers
            (name, latitude, longitude)
        VALUES
         (<CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#items[1]#">,
          <CFQUERYPARAM CFSQLTYPE="CF_SQL_FLOAT" VALUE="#items[2]#">,
          <CFQUERYPARAM CFSQLTYPE="CF_SQL_FLOAT" VALUE="#items[3]#">)
     </cfquery>

    <cfdump var="#result#" label="RESULT"/>

</cfloop>

<cfquery name="qGetMarkers" datasource="map">
       SELECT *
       FROM markers
</cfquery>
       
<cfdump var="#qGetMarkers#">

Source code ColdFusion at line 60 I had the extra comma. Now the update function works..

But what about those results latitude longitude...?