Mutliple SQL statements in a single HTTP Request - metamug

Question

In the following resource file, I'm trying to perform 2 insert operations for the same request.(form submit)

But getting 500 error from the API.

<?xml version="1.0" encoding="UTF-8" ?>
<Resource xmlns="http://xml.metamug.net/resource/1.0" v="1.0">
    <Request method="POST">
        <Desc> CRICKET INFO </Desc>
        <Update>
          insert into CRICKET (NAME,DOB,BATTING_STYLE,BOWLING_STYLE,TEAM)
          values($xname,$birthdate,$batstyle,$bowlstyle,$st); 
          insert into DETAILS (FORMAT,RUNS,WICKETS,AVERAGE)
          values($sf,$rns,$wkts,$avg);
        </Update>
    </Request>
</Resource>

Answer 1

You'll have to use <Sql> tag twice to achieve this, you can't write more than one query inside a single <Sql>.
So your resource file should be like this

<?xml version="1.0" encoding="UTF-8" ?>
<Resource xmlns="http://xml.metamug.net/resource/1.0" v="1.0">
    <Request method="POST">
        <Desc> CRICKET INFO </Desc>
        <Sql id="first">
          insert into CRICKET (NAME,DOB,BATTING_STYLE,BOWLING_STYLE,TEAM)
          values($xname,$birthdate,$batstyle,$bowlstyle,$st); 
        </Sql>
        <Sql id="second">
          insert into DETAILS (FORMAT,RUNS,WICKETS,AVERAGE)
          values($sf,$rns,$wkts,$avg);
        </Sql>
    </Request>
</Resource>