Insert MySql

Hi Rom,

I think you want to parse at one level lower, using the Format String:

And then, in your myRecordHandler2 function, for each key instead of, for example:

...use:

Then you should get all <support_composants> into your myRecordHandler2 function!

Hope this helps,
Cheers
David
--
MagicParser.com

Hi David,

Thanks for the reply but i have always the same problem..

Rom

Sorry Rom, I wasn't quite right in the new Format String. Use:

The new key values into $record2 are correct still...

Hope this helps!
Cheers,
David.

I have tried but now I have "invalid format string".

I don't know what can I do..

Thanks

Hi Rom,

Could you check it is all on one line - {link saved} to see that Format String working in the demo tool; if you're not sure, could you post the section of your code calling MagicParser_parse and i'll check it out...

I 'm not sur. Here is my code :

{code saved}

I made tests between... Correction for the last post i have :

MagicParser_parse($xml,"myRecordHandler2","penelop/donnee_reguliere/DESTINATAIRE/CONTRATS/CONTRAT/SUPPORT_COMPOSANTS/SUPPORT_COMPOSANT");

Hi Rom,

the XML| and trailing / are missing - please try;

MagicParser_parse($xml,"myRecordHandler2","XML|penelop/donnee_reguliere/DESTINATAIRE/CONTRATS/CONTRAT/SUPPORT_COMPOSANTS/SUPPORT_COMPOSANT/");

(make sure all on one line of course)

That should be all it is!

Cheers,
David.

Hi David,

ok.. Sorry.

it's works but the result is the same. I have only the first line of each group.

Rom

Hi Rom,

Please could you email me your script as it will be easier to look at and I'll check it out for you...

Cheers,
David.