paraworld.MQL.query

Description

执行传入的MQL语句,并将结果返回

Parameters

Required Name Type Description
required query string 规范的MQL语句
optional appKey string 应用程序Key
sessionKey string 用户凭证

Return XML

(1)若是select语句,则返回类似于下面的XML格式:
<msg xmlns="">
        <users>
                <param index="1">
                        <uid type="string">f5f3de7a-05b2-42a0-bd78-415a939020c2</uid>
                        <uname type="string">clayman</uname>
                        <createDate type="string">2008-5-5 7:44:11</createDate>
                </param>
                <param index="2">
                        <uid type="string">6ea770c6-92b2-4b2b-86da-6f574641ec11</uid>
                        <uname type="string">andy</uname>
                        <createDate type="string">2008-5-5 7:36:12</createDate>
                </param>
                <param index="3">
                        <uid type="string">8ec11316-bc2e-491d-8f18-667501687e69</uid>
                        <uname type="string">ParaEngine</uname>
                        <createDate type="string">2008-5-5 7:36:05</createDate>
                </param>
        </users>
        <query type="string">
                select uid,uname,createdate from users where pageindex = 0 and pagesize = 3 and createdate > '2008-1-1' order by createdate desc
        </query>
</msg>
(2)若是update、delete、insert语句,则返回:
<msg>
        <isSuccess>true</isSuccess>
        <query type="string">
                update users set email = 'aaa@gmail.com' where uid = 'f5f3de7a-05b2-42a0-bd78-415a939020c2'
        </query>
</msg>
msg = {
isSuccess  &#25805;&#20316;&#26159;&#21542;&#25104;&#21151;
[ query ] &#23558;&#36755;&#20837;&#30340;query&#21442;&#25968;&#36820;&#22238;
[ errorCode ]  &#38169;&#35823;&#30721;
}
(3)若发生异常,则返回类似于以下的XML:
<msg>
        <errorCode>494</errorCode>
        <query type="string">
                select uid,uname,createdate from users where pageindex = 0 and pagesize = 3 and createdate > '2008-1-1'
        </query>
</msg>
<verbatim>

---++ Tables
[[Paraworld.MQL.Users][users]]
<br/> __fields__
|*Name*|*Type*|*Description*|
|<font color="#4682b4">uid</font>|GUID|&#29992;&#25143;&#30340;&#21807;&#19968;&#26631;&#35782;&#31526;|
|<font color="#4682b4">uname</font>|string|&#29992;&#25143;&#21517;|
|<font color="#4682b4">createDate</font>|datetime|&#27880;&#20876;&#26102;&#38388;|
|<font color="#4682b4">lastActivityDate</font>|datetime|&#26368;&#21518;&#27963;&#36291;&#26102;&#38388;|
|<font color="#4682b4">email</font>|string|&#29992;&#25143;&#30340;&#30005;&#23376;&#37038;&#31665;&#22320;&#22336;|
__&#25903;&#25345;&#30340;MQL&#35821;&#21477;__
|select&#35821;&#21477;|&#25903;&#25345;|
|update&#35821;&#21477;|&#19981;&#25903;&#25345;|
|delete&#35821;&#21477;|&#19981;&#25903;&#25345;|
|insert&#35821;&#21477;|&#19981;&#25903;&#25345;|

---++ Error Codes
&#24403;&#21457;&#29983;&#24322;&#24120;&#26102;&#65292;&#36820;&#22238;&#25968;&#25454;&#20013;&#20250;&#26377;&#19968;&#20010;&#8220;errorCode&#8221;&#33410;&#28857;&#65292;&#35813;&#33410;&#28857;&#35760;&#24405;&#20102;&#38169;&#35823;&#30721;&#12290;0&#65306;&#26080;&#24322;&#24120;  500&#65306;&#26410;&#30693;&#38169;&#35823;  499&#65306;&#25552;&#20379;&#30340;&#25968;&#25454;&#19981;&#23436;&#25972;  498&#65306;&#38750;&#27861;&#30340;&#35775;&#38382;  497&#65306;&#25968;&#25454;&#19981;&#23384;&#22312;&#25110;&#24050;&#34987;&#21024;&#38500;   496&#65306;&#26410;&#30331;&#24405;  409&#65306;&#25991;&#20214;&#22841;&#24050;&#23384;&#22312;  410&#65306;&#25991;&#20214;&#24050;&#23384;&#22312;</verbatim>
<nop>
Topic revision: r3 - 2008-05-23 - CaoYF
 
  • Edit
  • Attach
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback