Serious trouble on CDML usage

[SuperMIKE]

Hi there,

I've a big problem and I hope you could help me to solve it.

In a few words, I need to comunicate between a Flash movie and a FileMaker database.

I've seen the CDML syntax and now I'm able to retrive data from the database getting that information in XML format using the parameter: format=-dso_xml.

My big problem is how to add/modify information on the database.

I know I could use the -add or -edit parameter as specified on CDML systax but I would like to post the information to the database directly as XML.

And if it isn't possibile, is there another solution?

In some conditions, the Flash movie contain some record in XML format and I would like to be able to send it directly to the Filemaker database.

Please help me!!

Michele

[Garry Claridge]

You can use the 'loadvariables()' actionscript. It can be used to query and edit a database.

Example:

loadvariables("/FMPro?-db=mydb.fp5&-lay=CGI&-format=myvars.txt&-findany",0)

The 'myvars.txt' format file could look like this:

myvar1=[FMP-Field:myvar1]&myvar2=[FMP-Field:myvar2]

The variables myvar1 and myvar2 would have been declared at level 0.

You can use -recid and -edit in the URL to edit the database.

Hope this helps.

Garry

[SuperMIKE]

  Quote

You can use the 'loadvariables()' actionscript. It can be used to query and edit a database.

You can use -recid and -edit in the URL to edit the database.

Thanks a lot for your reply.

Unfortunately, as wrote on my first post,

"I know I could use the -add or -edit parameter as specified on CDML systax but I would like to post the information to the database directly as XML"

So, do you think isn't it possible to send information in XML format to the database?

If my XML object (in Floash movie) contains for example 10 edited records, using 'loadvariables()' I'd have to parse the object sending it record by record to the server.

I know I could do it but I don't like this solution

Today everybody talk about XML and isn't possible to use it?

Thanls a lot.

Michele

[Garry Claridge]

If you can send an XML stream to FM, then you can do it.

Just try to import data into FM via a URL. When you succeed with that you can do it with Fash! (I will check XML Central at the FMI site.)

All the best.

Garry

[SuperMIKE]

Well, it is true I can import XML data in FileMaker specifing an URL, but this is only the first step, not the solution.

Using FileMaker options to import XML data is not the same that sending an XML stream from Flash to FM.

Today, using the XMLSocket Object avaiable in Filemaker, I was able to establish a connecton to Filemaker, but at this point I don't what kind of command send trought the socket.

Any command I try to send appear to haven't any result.

I don't receive any reply from FM.

Any idea?

[SuperMIKE]

  Quote

Today, using the XMLSocket Object avaiable in Filemaker, I was able to establish a connecton to Filemaker

I've to correct my previous post.

Due to a stupid error on my script I wasn't able to verify that the connection was failed!

I apologize with you.