paraworld.MQL.query
Description
执行传入的MQL语句,并将结果返回
Parameters
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 操作是否成功
[ query ] 将输入的query参数返回
[ errorCode ] 错误码
}
(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|用户的唯一标识符|
|<font color="#4682b4">uname</font>|string|用户名|
|<font color="#4682b4">createDate</font>|datetime|注册时间|
|<font color="#4682b4">lastActivityDate</font>|datetime|最后活跃时间|
|<font color="#4682b4">email</font>|string|用户的电子邮箱地址|
__支持的MQL语句__
|select语句|支持|
|update语句|不支持|
|delete语句|不支持|
|insert语句|不支持|
---++ Error Codes
当发生异常时,返回数据中会有一个“errorCode”节点,该节点记录了错误码。0:无异常 500:未知错误 499:提供的数据不完整 498:非法的访问 497:数据不存在或已被删除 496:未登录 409:文件夹已存在 410:文件已存在</verbatim>
<nop>
Topic revision: r3 - 2008-05-23
- CaoYF