---+!! =paraworld.MQL.query= <div style="float: right; margin: 5px; width: 250px; color: #4e5155; background-color: #f0eded; border: #ccc 1px solid; padding: 5px"> *Contents* %TOC% </div> ---++ Description 执行传入的MQL语句,并将结果返回 ---++ Parameters |*Required*|*Name*|*Type*|*Description*| |<font color="#4682b4">required</font>|query|%BLUE%string%ENDCOLOR%|规范的MQL语句| |<font color="#4682b4">optional</font>|appKey|%BLUE%string%ENDCOLOR%|应用程序Key| |^|sessionKey|%BLUE%string%ENDCOLOR%|用户凭证| ---++ Return XML (1)若是select语句,则返回类似于下面的XML格式: <verbatim> <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> </verbatim> (2)若是update、delete、insert语句,则返回类似于下面的XML: <verbatim> <msg> <isSuccess>true</isSuccess> <query type="string"> update users set email = 'aaa@gmail.com' where uid = 'f5f3de7a-05b2-42a0-bd78-415a939020c2' </query> </msg> </verbatim> (3)若发生异常,则返回类似于下面的XML: <verbatim> <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:非法的访问 494:语法错误
Edit
|
Attach
|
P
rint version
|
H
istory
:
r12
|
r6
<
r5
<
r4
<
r3
|
B
acklinks
|
V
iew topic
|
Raw edit
|
More topic actions...
Topic revision: r4 - 2008-05-23
-
CaoYF
Home
Site map
CCWeb web
HaqiTeen web
Main web
ParaEngine web
TWiki web
Main Web
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
导航页WebTopMenu
Preferences
开发指南
Getting Started
ParacraftSDK
NPL
MCML
NPL Reference Manual
美术Mod
Account
Log In
English
简体中文
簡體中文
Edit
Attach
Copyright © 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