QtSql write results to XML Hierarchy for List

[mentalmushroom]

MMh.. Maybe I incorrectly understood what you wanted to achieve, because your SubMenu node is shifted like a child of Name node.

QXmlStreamWriter output(&f);
 
    output.setCodec("UTF-8");
    output.setAutoFormatting(true);
    output.writeStartDocument();
    output.writeStartElement("Menu");
 
    output.writeStartElement("Model");
    output.writeTextElement("Name", "Main");
 
    output.writeStartElement("SubMenu");
    output.writeTextElement("Name", "Network");
    output.writeEndElement();
 
    output.writeEndElement();	//	model
 
    output.writeEndElement();	//	menu
 
    output.writeEndDocument();

QXmlStreamWriter output(&f);

    output.setCodec("UTF-8");
    output.setAutoFormatting(true);
    output.writeStartDocument();
    output.writeStartElement("Menu");

    output.writeStartElement("Model");
    output.writeTextElement("Name", "Main");

    output.writeStartElement("SubMenu");
    output.writeTextElement("Name", "Network");
    output.writeEndElement();

    output.writeEndElement();	//	model

    output.writeEndElement();	//	menu

    output.writeEndDocument();

To copy to clipboard, switch view to plain text mode 

[prophet0]

See im almost there but still wont work for me could anyone see my mistake

//XML stuff below
 
        QFile iconfile("/TouchTaxiMedia/iconList.xml");
        if(!iconfile.open(QIODevice::WriteOnly | QIODevice::Text))
        {
            qDebug() << "Failed to open file for write";
        }
 
        QXmlStreamWriter output2(&iconfile);
        output2.setCodec("UTF-8");
        output2.setAutoFormatting(true);
        output2.writeStartDocument();
        output2.writeStartElement("Menu");
 
        while (sqlSelFrmView.next())
        {
            if(sqlSelFrmView.value(2) == "1")
            {
                output2.writeStartElement("Model");
                output2.writeTextElement("Name", sqlSelFrmView.value(1).toString());
                if (!(sqlSelFrmView.value(3) == ""))
                {
                    output2.writeTextElement("Source", sqlSelFrmView.value(3).toString());
                }
                if (!(sqlSelFrmView.value(4) == ""))
                {
                    output2.writeTextElement("Picture", sqlSelFrmView.value(4).toString());
                }
                if(sqlSelFrmView.value(2) == "2")
                {
                    output2.writeStartElement("SubMenu");
                    output2.writeTextElement("Name", sqlSelFrmView.value(1).toString());
                    if (!(sqlSelFrmView.value(3) == ""))
                    {
                        output2.writeTextElement("Source", sqlSelFrmView.value(3).toString());
                    }
                    if (!(sqlSelFrmView.value(4) == ""))
                    {
                        output2.writeTextElement("Picture", sqlSelFrmView.value(4).toString());
                    }
                    output2.writeEndElement();
                }
                output2.writeEndElement();
 
            }
        }
 
        output2.writeEndDocument();
        //Done

//XML stuff below

        QFile iconfile("/TouchTaxiMedia/iconList.xml");
        if(!iconfile.open(QIODevice::WriteOnly | QIODevice::Text))
        {
            qDebug() << "Failed to open file for write";
        }

        QXmlStreamWriter output2(&iconfile);
        output2.setCodec("UTF-8");
        output2.setAutoFormatting(true);
        output2.writeStartDocument();
        output2.writeStartElement("Menu");

        while (sqlSelFrmView.next())
        {
            if(sqlSelFrmView.value(2) == "1")
            {
                output2.writeStartElement("Model");
                output2.writeTextElement("Name", sqlSelFrmView.value(1).toString());
                if (!(sqlSelFrmView.value(3) == ""))
                {
                    output2.writeTextElement("Source", sqlSelFrmView.value(3).toString());
                }
                if (!(sqlSelFrmView.value(4) == ""))
                {
                    output2.writeTextElement("Picture", sqlSelFrmView.value(4).toString());
                }
                if(sqlSelFrmView.value(2) == "2")
                {
                    output2.writeStartElement("SubMenu");
                    output2.writeTextElement("Name", sqlSelFrmView.value(1).toString());
                    if (!(sqlSelFrmView.value(3) == ""))
                    {
                        output2.writeTextElement("Source", sqlSelFrmView.value(3).toString());
                    }
                    if (!(sqlSelFrmView.value(4) == ""))
                    {
                        output2.writeTextElement("Picture", sqlSelFrmView.value(4).toString());
                    }
                    output2.writeEndElement();
                }
                output2.writeEndElement();

            }
        }

        output2.writeEndDocument();
        //Done

To copy to clipboard, switch view to plain text mode 

its not adding the submenu in there at all

[prophet0]

i put line 19 to line 14 and this fixes the submenu but now i cant model to close the secound time again cause its at line 14 if there a way i can get <model> to open imput data open <submenu> then input data then close submenu and close model then do it again untill end the code i gave above works only for the first record then it does not for anything else then closes to <menu>