diff options
Diffstat (limited to 'demos/sqlmap-docs/protected/pages/Manual/InlineParameterMaps.page')
| -rw-r--r-- | demos/sqlmap-docs/protected/pages/Manual/InlineParameterMaps.page | 102 | 
1 files changed, 0 insertions, 102 deletions
| diff --git a/demos/sqlmap-docs/protected/pages/Manual/InlineParameterMaps.page b/demos/sqlmap-docs/protected/pages/Manual/InlineParameterMaps.page deleted file mode 100644 index 3bfa4ceb..00000000 --- a/demos/sqlmap-docs/protected/pages/Manual/InlineParameterMaps.page +++ /dev/null @@ -1,102 +0,0 @@ -<com:TContent ID="body">
 -<h1>Inline Parameter Maps</h1>
 -
 -<p>If you prefer to use inline parameters instead of parameter maps, you can add
 -extra type information inline too. The inline parameter map syntax lets you
 -embed the property name, the property type, the column type, and a null value
 -replacement into a parametrized SQL statement. The next four examples shows
 -statements written with inline parameters.</p>
 -
 -<com:TTextHighlighter Language="xml" CssClass="source">
 -<statement id="insertProduct" parameterClass="Product">
 -  insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)
 -  values (#id#, #description#)
 -</statement>
 -</com:TTextHighlighter>
 -
 -<p>The following example shows how <tt>dbTypes</tt> can be declared inline.</p>
 -
 -<com:TTextHighlighter Language="xml" CssClass="source">
 -<statement id="insertProduct" parameterClass="Product">
 -  insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)
 -  values (#id, dbType=int#, #description, dbType=VarChar#)
 -</statement>
 -</com:TTextHighlighter>
 -
 -<p>The next example shows how <tt>dbTypes</tt> and null value replacements can also
 -be declared inline.</p>
 -
 -<com:TTextHighlighter Language="xml" CssClass="source">
 -<statement id="insertProduct" parameterClass="Product">
 -  insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)
 -  values (#id, dbType=int, nullValue=-999999#, #description, dbType=VarChar#)
 -</statement>
 -</com:TTextHighlighter>
 -
 -<p>A more complete example.</p>
 -
 -<com:TTextHighlighter Language="xml" CssClass="source">
 -<update id="UpdateAccountViaInlineParameters" parameterClass="Account">
 - update Accounts set
 - Account_FirstName = #FirstName#,
 - Account_LastName = #LastName#,
 - Account_Email = #EmailAddress,type=string,dbType=Varchar,nullValue=no_email@provided.com#
 - where
 - Account_ID = #Id#
 -</update>
 -</com:TTextHighlighter>
 -
 -<div class="note"><b class="tip">Note:</b>
 -Inline parameter maps are handy for small jobs, but when there are a lot of
 -type descriptors and null value replacements in a complex statement, an
 -industrial-strength, external <tt>parameterMap</tt> can be easier.
 -</div>
 -
 -<h1>Standard Type Parameters</h1>
 -<p>In practice, you will find that many statements take a single parameter, often
 -an <tt>integer</tt> or a <tt>string</tt>. Rather than wrap a single value in another
 -object, you can use the standard library object (string, integer, et cetera)
 -as the parameter directly. The following example shows a statement using
 -a standard type parameter.</p>
 -
 -<com:TTextHighlighter Language="xml" CssClass="source">
 -<statement id="getProduct" parameterClass="System.Int32">
 -  select * from PRODUCT where PRD_ID = #value#
 -</statement>
 -</com:TTextHighlighter>
 -
 -<p>Assuming <tt>PRD_ID</tt> is a numeric type, when a call is made to this Mapped
 -Statement, a standard integer can be passed in. The <tt>#value#</tt> parameter
 -will be replaced with the value of the integer. The name <tt>value</tt> is simply
 -a placeholder, you can use another moniker of your choice. Result Maps support
 -primitive types as results as well.</p>
 -
 -<p>For your convenience, the following PHP primitive types are supported.</p>
 -<ul>
 -  <li><tt>string</tt></li>
 -  <li><tt>float</tt> or <tt>double</tt></li>
 -  <li><tt>integer</tt> or <tt>int</tt></li>
 -  <li><tt>bool</tt> or <tt>boolean</tt></li>
 -</ul>
 -
 -<h1>Array Type Parameters</h1>
 -<p>You can also pass in a array as a parameter object. This would usually be a an
 -associative array. The following example shows a <tt><statement></tt> using
 -an array for a <tt>parameterClass</tt>.</p>
 -
 -<com:TTextHighlighter Language="xml" CssClass="source">
 -<statement id="getProduct" parameterClass="array">
 -  select * from PRODUCT
 -  where PRD_CAT_ID = #catId#
 -  and PRD_CODE = #code#
 -</statement>
 -</com:TTextHighlighter>
 -
 -<p>In the above example, notice that the SQL in this Mapped Statement
 -looks like any other. There is no difference in how the inline parameters are
 -used. If an associative array is passed, it must contain keys named <tt>catId</tt>
 -and <tt>code</tt>. The values referenced by those keys must be of the appropriate
 -type for the column, just as they would be if passed from a properties object.</p>
 -
 -
 -</com:TContent>
\ No newline at end of file | 
