<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <title>Wt: Wt::Dbo::SqlStatement Class Reference</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <link href="doxygen.css" rel="stylesheet" type="text/css" /> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="search/search.js"></script> <script type="text/javascript"> $(document).ready(function() { searchBox.OnSelectItem(0); }); </script> </head> <body> <div id="top"><!-- do not remove this div! --> <div id="titlearea"> <table cellspacing="0" cellpadding="0"> <tbody> <tr style="height: 56px;"> <td style="padding-left: 0.5em;"> <div id="projectname">Wt  <span id="projectnumber">3.2.3</span> </div> </td> </tr> </tbody> </table> </div> <!-- Generated by Doxygen 1.7.5.1 --> <script type="text/javascript"> var searchBox = new SearchBox("searchBox", "search",false,'Search'); </script> <div id="navrow1" class="tabs"> <ul class="tablist"> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li><a href="namespaces.html"><span>Namespaces</span></a></li> <li class="current"><a href="annotated.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> <li> <div id="MSearchBox" class="MSearchBoxInactive"> <span class="left"> <img id="MSearchSelect" src="search/mag_sel.png" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" alt=""/> <input type="text" id="MSearchField" value="Search" accesskey="S" onfocus="searchBox.OnSearchFieldFocus(true)" onblur="searchBox.OnSearchFieldFocus(false)" onkeyup="searchBox.OnSearchFieldChange(event)"/> </span><span class="right"> <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> </span> </div> </li> </ul> </div> <div id="navrow2" class="tabs2"> <ul class="tablist"> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="inherits.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul> </div> <div id="nav-path" class="navpath"> <ul> <li class="navelem"><a class="el" href="namespaceWt.html">Wt</a> </li> <li class="navelem"><a class="el" href="namespaceWt_1_1Dbo.html">Dbo</a> </li> <li class="navelem"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> </li> </ul> </div> </div> <div class="header"> <div class="summary"> <a href="#pub-methods">Public Member Functions</a> </div> <div class="headertitle"> <div class="title">Wt::Dbo::SqlStatement Class Reference<div class="ingroups"><a class="el" href="group__dbo.html">Database Objects (Wt::Dbo)</a></div></div> </div> </div> <div class="contents"> <!-- doxytag: class="Wt::Dbo::SqlStatement" --> <p>Abstract base class for a prepared SQL statement. <a href="classWt_1_1Dbo_1_1SqlStatement.html#details">More...</a></p> <p>Inherited by Wt::Dbo::backend::FirebirdStatement, Wt::Dbo::backend::PostgresStatement, and Wt::Dbo::backend::Sqlite3Statement.</p> <p><a href="classWt_1_1Dbo_1_1SqlStatement-members.html">List of all members.</a></p> <table class="memberdecls"> <tr><td colspan="2"><h2><a name="pub-methods"></a> Public Member Functions</h2></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a15969dbb9c24b0901c3a784ea4807273"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::~SqlStatement" ref="a15969dbb9c24b0901c3a784ea4807273" args="()" --> virtual </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a15969dbb9c24b0901c3a784ea4807273">~SqlStatement</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Destructor. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a9b894eddd589cb481b21217b7ecad462">use</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Uses the statement. <a href="#a9b894eddd589cb481b21217b7ecad462"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a98e67c18e7a5c3da2aa9a1c02f6ba3be">done</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Finish statement use. <a href="#a98e67c18e7a5c3da2aa9a1c02f6ba3be"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aa373b68969bcfa8e5c41113576b823fd"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::reset" ref="aa373b68969bcfa8e5c41113576b823fd" args="()=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#aa373b68969bcfa8e5c41113576b823fd">reset</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Resets the statement. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ad8b53ca87bdef11ceceb96ab05c260b9"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="ad8b53ca87bdef11ceceb96ab05c260b9" args="(int column, const std::string &value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ad8b53ca87bdef11ceceb96ab05c260b9">bind</a> (int column, const std::string &value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ae05c21f97335e6ff3a8c59bf5e0727ed"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="ae05c21f97335e6ff3a8c59bf5e0727ed" args="(int column, short value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ae05c21f97335e6ff3a8c59bf5e0727ed">bind</a> (int column, short value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aa6b3c0525a43d0016116f8e7adad9d50"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="aa6b3c0525a43d0016116f8e7adad9d50" args="(int column, int value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#aa6b3c0525a43d0016116f8e7adad9d50">bind</a> (int column, int value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aaf3c0b71e7af23dddac2aaae7d698f26"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="aaf3c0b71e7af23dddac2aaae7d698f26" args="(int column, long long value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#aaf3c0b71e7af23dddac2aaae7d698f26">bind</a> (int column, long long value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a44b457f74cea0f4685af49022cb53d60"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="a44b457f74cea0f4685af49022cb53d60" args="(int column, float value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a44b457f74cea0f4685af49022cb53d60">bind</a> (int column, float value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="afe5d6c654dc5f35fb5bd743d801c8cbd"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="afe5d6c654dc5f35fb5bd743d801c8cbd" args="(int column, double value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#afe5d6c654dc5f35fb5bd743d801c8cbd">bind</a> (int column, double value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a94c43852e586bbcba7077352588fe1a2"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="a94c43852e586bbcba7077352588fe1a2" args="(int column, const boost::posix_time::ptime &value, SqlDateTimeType type)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a94c43852e586bbcba7077352588fe1a2">bind</a> (int column, const boost::posix_time::ptime &value, <a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> type)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a95a55b30b2411053aea47d238dbdb9ac"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="a95a55b30b2411053aea47d238dbdb9ac" args="(int column, const boost::posix_time::time_duration &value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a95a55b30b2411053aea47d238dbdb9ac">bind</a> (int column, const boost::posix_time::time_duration &value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ae2bbddef8fd8c11687d23187920dc4da"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bind" ref="ae2bbddef8fd8c11687d23187920dc4da" args="(int column, const std::vector< unsigned char > &value)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ae2bbddef8fd8c11687d23187920dc4da">bind</a> (int column, const std::vector< unsigned char > &value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds a value to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="affff3fa371c416b6c984082d8f5dc050"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::bindNull" ref="affff3fa371c416b6c984082d8f5dc050" args="(int column)=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#affff3fa371c416b6c984082d8f5dc050">bindNull</a> (int column)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Binds <code>null</code> to a column. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ab8b5af1a2f9cd87e8c2aac883a3d805f"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::execute" ref="ab8b5af1a2f9cd87e8c2aac883a3d805f" args="()=0" --> virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ab8b5af1a2f9cd87e8c2aac883a3d805f">execute</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Executes the statement. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a88ab03b6ac501ce5b424746d42b2b882"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::insertedId" ref="a88ab03b6ac501ce5b424746d42b2b882" args="()=0" --> virtual long long </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a88ab03b6ac501ce5b424746d42b2b882">insertedId</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the id if the statement was an SQL <code>insert</code>. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a4a0eedff10a29eb511ebf66762b13e72">affectedRowCount</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the affected number of rows. <a href="#a4a0eedff10a29eb511ebf66762b13e72"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a5da3f872f0dfb742dd4c1608ad1dd550">nextRow</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches the next result row. <a href="#a5da3f872f0dfb742dd4c1608ad1dd550"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#afca829eb43f0977b2af6ea7e0b66aad1">getResult</a> (int column, std::string *value, int size)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#afca829eb43f0977b2af6ea7e0b66aad1"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ab531e2336cac4d92abf4af926dffbe36">getResult</a> (int column, short *value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#ab531e2336cac4d92abf4af926dffbe36"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a8512932928f07c81917c67ec86551685">getResult</a> (int column, int *value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#a8512932928f07c81917c67ec86551685"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a2d286430babae4a15f7a64ffb8b7f463">getResult</a> (int column, long long *value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#a2d286430babae4a15f7a64ffb8b7f463"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#af22bf78fd30fb12b502a2c49251c3808">getResult</a> (int column, float *value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#af22bf78fd30fb12b502a2c49251c3808"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#af55759bcb42119292bf2e05308a50db8">getResult</a> (int column, double *value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#af55759bcb42119292bf2e05308a50db8"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a82e3b42520fa813a1ad32d718fc74b3c">getResult</a> (int column, boost::posix_time::ptime *value, <a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> type)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#a82e3b42520fa813a1ad32d718fc74b3c"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ac34540c06e6bbe8cc29b87542e8dc726">getResult</a> (int column, boost::posix_time::time_duration *value)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#ac34540c06e6bbe8cc29b87542e8dc726"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#afa7b64d1c949c39e1cddd16f8e343b42">getResult</a> (int column, std::vector< unsigned char > *value, int size)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches a result value. <a href="#afa7b64d1c949c39e1cddd16f8e343b42"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ac1a8b9037b9f106135150a547626b826"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::sql" ref="ac1a8b9037b9f106135150a547626b826" args="() const =0" --> virtual std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ac1a8b9037b9f106135150a547626b826">sql</a> () const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the prepared SQL string. <br/></td></tr> </table> <hr/><a name="details" id="details"></a><h2>Detailed Description</h2> <div class="textblock"><p>Abstract base class for a prepared SQL statement. </p> <p>The statement may be used multiple times, but cannot be used concurrently. It also cannot be copied.</p> <p>This class is part of <a class="el" href="namespaceWt_1_1Dbo.html" title="Namespace for the Database Objects (Wt::Dbo).">Wt::Dbo</a>'s backend API, and should not be used directly. Its interface must be reimplemented for each backend corresponding to a supported database.</p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html" title="Abstract base class for an SQL connection.">SqlConnection</a> </dd></dl> </div><hr/><h2>Member Function Documentation</h2> <a class="anchor" id="a4a0eedff10a29eb511ebf66762b13e72"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::affectedRowCount" ref="a4a0eedff10a29eb511ebf66762b13e72" args="()=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int Wt::Dbo::SqlStatement::affectedRowCount </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the affected number of rows. </p> <p>This is only useful for an SQL <code>update</code> or <code>delete</code> statement. </p> </div> </div> <a class="anchor" id="a98e67c18e7a5c3da2aa9a1c02f6ba3be"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::done" ref="a98e67c18e7a5c3da2aa9a1c02f6ba3be" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::SqlStatement::done </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </div> <div class="memdoc"> <p>Finish statement use. </p> <p>Marks the statement as no longer used and resets the statement.</p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a9b894eddd589cb481b21217b7ecad462" title="Uses the statement.">use()</a> </dd></dl> </div> </div> <a class="anchor" id="afca829eb43f0977b2af6ea7e0b66aad1"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="afca829eb43f0977b2af6ea7e0b66aad1" args="(int column, std::string *value, int size)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">std::string * </td> <td class="paramname"><em>value</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"><em>size</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="ab531e2336cac4d92abf4af926dffbe36"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="ab531e2336cac4d92abf4af926dffbe36" args="(int column, short *value)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">short * </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="a8512932928f07c81917c67ec86551685"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="a8512932928f07c81917c67ec86551685" args="(int column, int *value)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int * </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="a2d286430babae4a15f7a64ffb8b7f463"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="a2d286430babae4a15f7a64ffb8b7f463" args="(int column, long long *value)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">long long * </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="af22bf78fd30fb12b502a2c49251c3808"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="af22bf78fd30fb12b502a2c49251c3808" args="(int column, float *value)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">float * </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="af55759bcb42119292bf2e05308a50db8"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="af55759bcb42119292bf2e05308a50db8" args="(int column, double *value)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">double * </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="a82e3b42520fa813a1ad32d718fc74b3c"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="a82e3b42520fa813a1ad32d718fc74b3c" args="(int column, boost::posix_time::ptime *value, SqlDateTimeType type)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">boost::posix_time::ptime * </td> <td class="paramname"><em>value</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> </td> <td class="paramname"><em>type</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="ac34540c06e6bbe8cc29b87542e8dc726"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="ac34540c06e6bbe8cc29b87542e8dc726" args="(int column, boost::posix_time::time_duration *value)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">boost::posix_time::time_duration * </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="afa7b64d1c949c39e1cddd16f8e343b42"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::getResult" ref="afa7b64d1c949c39e1cddd16f8e343b42" args="(int column, std::vector< unsigned char > *value, int size)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::getResult </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>column</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">std::vector< unsigned char > * </td> <td class="paramname"><em>value</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"><em>size</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches a result value. </p> <p>Returns <code>true</code> when the value was not <code>null</code>. </p> </div> </div> <a class="anchor" id="a5da3f872f0dfb742dd4c1608ad1dd550"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::nextRow" ref="a5da3f872f0dfb742dd4c1608ad1dd550" args="()=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual bool Wt::Dbo::SqlStatement::nextRow </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Fetches the next result row. </p> <p>Returns <code>true</code> if there was one more row to be fetched. </p> </div> </div> <a class="anchor" id="a9b894eddd589cb481b21217b7ecad462"></a><!-- doxytag: member="Wt::Dbo::SqlStatement::use" ref="a9b894eddd589cb481b21217b7ecad462" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">bool Wt::Dbo::SqlStatement::use </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </div> <div class="memdoc"> <p>Uses the statement. </p> <p>Marks the statement as in-use. If the statement is already in use, return false. In that case, we will later provision that a statement can be cloned and that a list of equivalent statement is kept in the statement cache of a connectin. </p> </div> </div> </div> <!-- window showing the filter options --> <div id="MSearchSelectWindow" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" onkeydown="return searchBox.OnSearchSelectKey(event)"> <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Enumerator</a></div> <!-- iframe showing the search results (closed by default) --> <div id="MSearchResultsWindow"> <iframe src="javascript:void(0)" frameborder="0" name="MSearchResults" id="MSearchResults"> </iframe> </div> <hr size="1"><address style="text-align: right; margin: 3px"><small> Generated on Thu Nov 1 2012 for <a href="http://www.webtoolkit.eu/wt">the C++ Web Toolkit (Wt)</a> by <a href="http://www.doxygen.org/index.html"><img src="doxygen.png" alt="doxygen" border="0" style="vertical-align: middle; display: inline-block; height: 2em"></a> 1.7.5.1</small></address> </body> </html>