📄 index.html
字号:
</span>
: url of your javascript-file</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAHUI0" onclick="toggle('mdetails_1IDAHUI0')">QS
(
name
)
</a></div>
<div class="mDesc">just an equivalent for request.querystring. if empty then returns whole querystring.</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDAHUI0"><br><div><strong> name</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: name of the value you want to get. leave it empty to get the whole querystring</div>
<div><strong>Return </strong>
(
<span class="type">string</span>
) :
value from the request-querystring-collection</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAGLI0" onclick="toggle('mdetails_1IDAGLI0')">return
(
val
)
</a></div>
<div class="mDesc">returns a value on callback()</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDAGLI0">those values are accessible on the javascript callback function defined in ajaxed.callback()<br><br><div><strong> val</strong><span class="type">
(
<span class="type">variant</span>
)
</span>
: check JSON.toJSON() for more details</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAAMI0" onclick="toggle('mdetails_1IDAAMI0')">returnValue
(
name val
)
</a></div>
<div class="mDesc">returns a named value on callback(). call this within the callback() sub</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDAAMI0">this method can be called more than once because the value will be named and therefore more
values can be returned.<br><br><div><strong> name</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: name of the value (accessible within the javascript callback)</div>
<div><strong> val</strong><span class="type">
(
<span class="type">variant</span>
)
</span>
: refer to JSON.toJSON() method for details</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDA5QI0" onclick="toggle('mdetails_1IDA5QI0')">RF
(
name
)
</a></div>
<div class="mDesc">gets the value from a given form field after postback</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDA5QI0">just an equivalent for request.form.<br><br><div><strong> name</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: name of the value you want to get</div>
<div><strong>Return </strong>
(
<span class="type">string</span>
) :
value from the request-form-collection.</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAZRI0" onclick="toggle('mdetails_1IDAZRI0')">RFE
(
name
)
</a></div>
<div class="mDesc">gets the value from a given form field and encodes the string into HTML.
useful if you want the value be HTML encoded. e.g. inserting into value fields</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDAZRI0"><br><div><strong> name</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: name of the value you want to get</div>
<div><strong>Return </strong>
(
<span class="type">string</span>
) :
value from the request-form-collection</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDANTI0" onclick="toggle('mdetails_1IDANTI0')">RFHas
(
name
)
</a></div>
<div class="mDesc">returns true if a given value exists in the request.form</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDANTI0"><br><div><strong> name</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: name of the value you want to get</div>
<div><strong>Return </strong>
(
<span class="type">bool</span>
) :
false if there is not value returned. true if yes</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDATSI0" onclick="toggle('mdetails_1IDATSI0')">RFT
(
name
)
</a></div>
<div class="mDesc">gets the value of a given form field and trims it automatically.</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDATSI0"><br><div><strong> name</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: name of the formfield you want to get</div>
<div><strong>Return </strong>
(
<span class="type">string</span>
) :
value from the request-form-collection</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAQZI0" onclick="toggle('mdetails_1IDAQZI0')">throwError
(
args
)
</a></div>
<div class="obsolete">(This method is obsolete)</div>
<div class="mDesc">OBSOLETE! use lib.throwError instead</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDAQZI0"><br><div><strong> args</strong>
: </div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAUNI0" onclick="toggle('mdetails_1IDAUNI0')">write
(
value
)
</a></div>
<div class="mDesc">writes a string to the output in the same line</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDAUNI0">just a wrapper to str.write<br><br><div><strong> value</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: output string</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAOOI0" onclick="toggle('mdetails_1IDAOOI0')">writeln
(
value
)
</a></div>
<div class="mDesc">writes a line to the output</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_1IDAOOI0">just a wrapper to str.writeln<br><br><div><strong> value</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: output string</div>
</div>
</td>
</tr>
</table>
</fieldset><br><br><a name="class_2"></a><fieldset class="class">
<legend>
Class Database <a class="notForPrint" href="#top" style="text-decoration:none;">^</a></legend>
<div class="cDescription">This class offers methods for database access. All of them are accessible
directly through "db" without creating an own instance. The AjaxedPage
offers a property "DBConnection" which automatically opens and closes the connection
within a page.</div>
<table cellspacing="0" cellpadding="3" border="0">
<tr>
<td class="label">Version:</td>
<td>0.1</td>
</tr>
<tr>
<td class="label">Author:</td>
<td>Michal Gabrukiewicz on 2007-07-16 21:01</td>
</tr>
<tr>
<td class="label">Last modified:</td>
<td>16.07.2007 22:09:31</td>
</tr>
<tr>
<td class="label">Static:</td>
<td>db</td>
</tr>
<tr>
<td class="label">Path:</td>
<td>/ajaxed/class_database/database.asp</td>
</tr>
</table>
<h2><span onclick="toggle('props_2')" style="cursor:pointer">Properties</span> <a href="#class_2" class="notForPrint" style="text-decoration:none;">^</a></h2>
<table id="props_2" style="display:none" class="table alwaysPrint" cellspacing="0" cellpadding="3" border="0">
<tr>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr valign="top">
<td class="property">connection</td>
<td class="type"><span class="type">ADODB.Connection</span> </td>
<td>holds the database connection </td>
</tr>
<tr valign="top">
<td class="property">numberOfDBAccess</td>
<td class="type"><span class="type">int</span> </td>
<td>GET: gets the number which indicates how many database accesses has been made till now </td>
</tr>
</table>
<h2><span onclick="toggle('meths_2')" style="cursor:pointer">Methods</span> <a href="#class_2" class="notForPrint" style="text-decoration:none;">^</a></h2>
<table id="meths_2" class="table alwaysPrint" style="display:none" cellpadding="3" cellspacing="0" border="0">
<tr>
<td>
<div class="mName"><a href="#method_IDAU2I0" style="text-decoration:none">close
(
)
</a></div>
<div class="mDesc">Closes the current database connection</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_2IDAU2I0">
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAE3I0" onclick="toggle('mdetails_2IDAE3I0')">getRecordset
(
sql
)
</a></div>
<div class="mDesc">Default method which should be always used to get a LOCKED recordset. Example for use:
set RS = db.getRecordset("SELECT * FROM user")</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_2IDAE3I0"><br><div><strong> sql</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: Your SQL query</div>
<div><strong>Return </strong>
(
<a class="type" href="http://www.w3schools.com/ado/ado_ref_recordset.asp" target="_blank">Recordset</a>
) :
recordset-Object</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDAY4I0" onclick="toggle('mdetails_2IDAY4I0')">getScalar
(
sql alternative
)
</a></div>
<div class="mDesc">executes a given sql-query and returns the first value of the first row.</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_2IDAY4I0">if there is no record given then the alternative will be returned.
the returned value (if available) will be converted to the type of which the alternative is.
example: calling getScalar("...", 0) will convert the returned value into an integer. if no record
then 0 will be returned<br><br><div><strong> sql</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: sql-query to be executed</div>
<div><strong> alternative</strong><span class="type">
(
<span class="type">variant</span>
)
</span>
: what should be returned when there is no record returned</div>
<div><strong>Return </strong>
(
<span class="type">variant</span>
) :
the first value of the result converted to the type of alternative
or the alternative itself if no records available</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDA43I0" onclick="toggle('mdetails_2IDA43I0')">getUnlockedRecordset
(
sql
)
</a></div>
<div class="mDesc">Default method which should be always used to get an UNLOCKED recordset. Example for use:
set RS = db.getUnlockedRecordset("SELECT * FROM user")</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_2IDA43I0"><br><div><strong> sql</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: Your SQL query</div>
<div><strong>Return </strong>
(
<a class="type" href="http://www.w3schools.com/ado/ado_ref_recordset.asp" target="_blank">Recordset</a>
) :
returns a recordset object (adOpenStatic & adUseClient)</div>
</div>
</td>
</tr>
<tr>
<td>
<div class="mName"><a href="#method_IDA01I0" onclick="toggle('mdetails_2IDA01I0')">open
(
connectionString
)
</a></div>
<div class="mDesc">Opens a database connection with a given connection string</div>
<div style="display:none" class="mdetails alwaysPrint" id="mdetails_2IDA01I0">- The connection is available afterwards in the connection property
- if the connection is already opened then it gets closed a the new is opened<br><br><div><strong> connectionString</strong><span class="type">
(
<span class="type">string</span>
)
</span>
: a connection string</div>
</div>
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -