incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ksch...@apache.org
Subject svn commit: r1204746 [5/8] - in /incubator/ooo/ooo-site/trunk/content/dba: FAQ/ QA/ QA/pics/ QA/testfolder/ QA/testfolder/ooQAReloaded/ __modules/ bugs/ css/ development/ downloads/ drivers/ drivers/mdb/ drivers/postgresql/ drivers/sqlite/ howto/ image...
Date Mon, 21 Nov 2011 23:16:13 GMT
Added: incubator/ooo/ooo-site/trunk/content/dba/howto/AppendTableAlias.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/howto/AppendTableAlias.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/howto/AppendTableAlias.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/howto/AppendTableAlias.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,251 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+  <meta http-equiv="content-type"
+ content="text/html; charset=ISO-8859-1">
+  <title>Parameter Name Substitution</title>
+</head>
+<body>
+<h1>Table Aliases for data sources</h1>
+<span style="font-size:xx-large;font-weight:bold">Note:</span> <em>The below information
+is outdated, it applies only to OpenOffice.org versions prior to 2.0.</em>
+<h2>The Problem</h2>
+When working with select statements, OpenOffice.org usually uses an
+alias name for tables such as in "<span style="font-family: monospace;">SELECT
+* FROM &lt;table&gt; </span>aliasname" Here "aliasname"" is a
+so-called table alias. However, some
+databases do not allow such aliases. The
+statement then would be "<span style="font-family: monospace;">SELECT *
+FROM &lt;table&gt;</span>". Such databases
+usually reject statements with aliases.<br>
+<h2>The Solution</h2>
+OpenOffice.org features the disabling as well as the enabling of this
+behavior.<br>
+<br>
+Table aliases can be enabled on a per-data-source basis.
+For this, the "Info" property of a <a
+ href="http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSource.html">data
+source</a> should contain a name-value-pair with<br>
+<span style="font-family: monospace;">Name</span>: <span
+ style="font-family: monospace;">AppendTableAlias</span><br>
+<span style="font-family: monospace;">Value</span>: <span
+ style="font-family: monospace;">FALSE</span><br>
+<br>
+Unfortunately, there is no user interface, yet, for doing so. You could
+use the Basic macro provided below, until we get OOo 2.0 ui, which adds
+the setting for a data
+source of your choice.<br>
+<br>
+Note that this feature will be first available in version
+OpenOffice.org 2.0.
+<h2>The Macro</h2>
+The following macro disables the use of table alias names for a data
+source of your choice. You can also download this macro in the <a
+ href="../downloads/">downloads section</a>.<br>
+<br>
+<span style="font-family: monospace; color: rgb(102, 102, 102);">REM&nbsp;
+*****&nbsp; BASIC&nbsp; *****</span><br style="font-family: monospace;">
+<br style="font-family: monospace;">
+<span style="font-family: monospace;"><span
+ style="color: rgb(0, 0, 128);">Option Explicit</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> <span
+ style="color: rgb(0, 128, 0);">Main</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 128, 0);">sDataSourceName</span>
+= <span style="color: rgb(0, 128, 0);">InputBox</span>( <span
+ style="color: rgb(255, 0, 0);">"Please enter the name of the data
+source:"</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">AppendTableAlias</span>(<span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> )<br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> <span
+ style="color: rgb(0, 128, 0);">AppendTableAlias</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source context (ehm - the service name is historical :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aContext</span>
+= <span style="color: rgb(0, 128, 0);">createUnoService</span>( <span
+ style="color: rgb(255, 0, 0);">"com.sun.star.sdb.DatabaseContext"</span>
+)<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 0, 128);">Not</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">hasByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> ) ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">MsgBox</span> <span
+ style="color: rgb(255, 0, 0);">"There is no data source named "</span>
++ <span style="color: rgb(0, 128, 0);">sDataSourceName</span> + <span
+ style="color: rgb(255, 0, 0);">"!"</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">Exit Sub</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aDataSource</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>
+= <span style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">getByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new AppendTableAlias flag</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bFlag</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bFlag</span> =
+<span style="color: rgb(0, 128, 0);">FALSE</span><br
+ style="color: rgb(0, 128, 0);">
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aInfo</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> =
+<span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> =
+<span style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aInfo</span>, <span
+ style="color: rgb(255, 0, 0);">"AppendTableAlias"</span>, <span
+ style="color: rgb(0, 128, 0);">bFlag</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' and
+write back</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span> = <span
+ style="color: rgb(0, 128, 0);">aInfo</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' flush
+(not really necessary, but to be on the safe side :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">flush</span><br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Function</span> <span
+ style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span>,<span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span>, <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span> ) <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nLower</span>
+= <span style="color: rgb(0, 128, 0);">LBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nUpper</span>
+= <span style="color: rgb(0, 128, 0);">UBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' look if
+the setting is already present</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bNeedAdd</span>
+= <span style="color: rgb(0, 128, 0);">TRUE</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">i</span> <span
+ style="color: rgb(0, 0, 128);">As Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> = <span
+ style="color: rgb(0, 128, 0);">FALSE</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">End If</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' allocate
+the new array</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nNewSize</span>
+= ( <span style="color: rgb(0, 128, 0);">nUpper</span> - <span
+ style="color: rgb(0, 128, 0);">nLower</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">Then</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> = <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> + <span
+ style="color: rgb(255, 0, 0);">1</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> ) <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' copy the
+elements (a simply copy does not work in Basic)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ) = <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new setting, if necessary</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">AddInfo</span>
+= <span style="color: rgb(0, 128, 0);">aNewInfo</span>()<br>
+<span style="color: rgb(0, 0, 128);">End Function</span></span>
+<h2></h2>
+</body>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/dba/howto/AppendTableAlias.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/howto/IgnoreDriverPrivileges.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/howto/IgnoreDriverPrivileges.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/howto/IgnoreDriverPrivileges.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/howto/IgnoreDriverPrivileges.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,251 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+  <meta http-equiv="content-type"
+ content="text/html; charset=ISO-8859-1">
+  <title>Parameter Name Substitution</title>
+</head>
+<body>
+<h1>Read/Write access rights (privileges) for JDBC/ODBC data sources</h1>
+<span style="font-size:xx-large;font-weight:bold">Note:</span> <em>The below information
+is outdated, it applies only to OpenOffice.org versions prior to 2.0.</em>
+<h2>The Problem</h2>
+When working with drivers which not fully support the access to the
+privileges of&nbsp; the database or returning just incorect
+information, OpenOffice.org only allows the operations which the driver
+returns. E.g. when the driver doesn't return the right to insert values
+into a table even when the database allows it, OpenOffice.org also
+shows the table in read only mode.
+<h2>The Solution</h2>
+The OpenOffice.org JDBC/ODBC-SDBC bridge (more sloppy: OOo's JDBC/ODBC
+driver) supports to work around the problem in just to return that all
+rigths are granted, the sytem driver won't be asked in that case.<br>
+<br>
+Read/Write access rights can be enabled on a per-data-source basis. For
+this, the "Info" property of a <a
+ href="http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSource.html">data
+source</a> should contain a name-value-pair with<br>
+<span style="font-family: monospace;">Name</span>: <span
+ style="font-family: monospace; color: rgb(51, 0, 51);">IgnoreDriverPrivileges</span><br>
+<span style="font-family: monospace;">Value</span>: <span
+ style="font-family: monospace;">TRUE</span><br>
+<br>
+Unfortunately, there is no user interface, yet, for doing so. You could
+use the Basic macro provided below, which adds the setting for a data
+source of your choice.<br>
+<h2>The Macro</h2>
+The following macro enables Read/Write access rights for a data source
+of your choice. You can also download this macro in the <a
+ href="../downloads/">downloads section</a>.<br>
+<br>
+<span style="font-family: monospace; color: rgb(102, 102, 102);">REM&nbsp;
+*****&nbsp; BASIC&nbsp; *****</span><br style="font-family: monospace;">
+<br style="font-family: monospace;">
+<span style="font-family: monospace;"><span
+ style="color: rgb(0, 0, 128);">Option Explicit</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> <span
+ style="color: rgb(0, 128, 0);">Main</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 128, 0);">sDataSourceName</span>
+= <span style="color: rgb(0, 128, 0);">InputBox</span>( <span
+ style="color: rgb(255, 0, 0);">"Please enter the name of the data
+source:"</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="font-family: monospace;"></span><span
+ style="font-family: monospace; color: rgb(0, 128, 0);">IgnoreDriverPrivileges</span></span><span
+ style="font-family: monospace;">(<span style="color: rgb(0, 128, 0);">sDataSourceName</span>
+)<br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> </span><span
+ style="font-family: monospace; color: rgb(0, 128, 0);">IgnoreDriverPrivileges</span><span
+ style="font-family: monospace;"><span style="color: rgb(0, 128, 0);"></span>(<span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source context (ehm - the service name is historical :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aContext</span>
+= <span style="color: rgb(0, 128, 0);">createUnoService</span>( <span
+ style="color: rgb(255, 0, 0);">"com.sun.star.sdb.DatabaseContext"</span>
+)<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 0, 128);">Not</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">hasByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> ) ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">MsgBox</span> <span
+ style="color: rgb(255, 0, 0);">"There is no data source named "</span>
++ <span style="color: rgb(0, 128, 0);">sDataSourceName</span> + <span
+ style="color: rgb(255, 0, 0);">"!"</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">Exit Sub</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aDataSource</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>
+= <span style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">getByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new </span></span><span
+ style="font-family: monospace; color: rgb(102, 102, 102);">IgnoreDriverPrivileges</span><span
+ style="font-family: monospace;"><span
+ style="color: rgb(102, 102, 102);">flag</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bFlag</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bFlag</span> = <span
+ style="color: rgb(0, 128, 0);">TRUE</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aInfo</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> = <span
+ style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> = <span
+ style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aInfo</span>, <span
+ style="color: rgb(255, 0, 0);">"IgnoreDriverPrivileges"</span>, <span
+ style="color: rgb(0, 128, 0);">bFlag</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' and
+write back</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span> = <span
+ style="color: rgb(0, 128, 0);">aInfo</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' flush
+(not really necessary, but to be on the safe side :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">flush</span><br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Function</span> <span
+ style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span>,<span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span>, <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span> ) <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nLower</span> = <span
+ style="color: rgb(0, 128, 0);">LBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nUpper</span> = <span
+ style="color: rgb(0, 128, 0);">UBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' look if
+the setting is already present</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bNeedAdd</span>
+= <span style="color: rgb(0, 128, 0);">TRUE</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">i</span> <span
+ style="color: rgb(0, 0, 128);">As Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> = <span
+ style="color: rgb(0, 128, 0);">FALSE</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">End If</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' allocate
+the new array</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nNewSize</span>
+= ( <span style="color: rgb(0, 128, 0);">nUpper</span> - <span
+ style="color: rgb(0, 128, 0);">nLower</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">Then</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> = <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> + <span
+ style="color: rgb(255, 0, 0);">1</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> ) <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' copy the
+elements (a simply copy does not work in Basic)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ) = <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new setting, if necessary</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">AddInfo</span>
+= <span style="color: rgb(0, 128, 0);">aNewInfo</span>()<br>
+<span style="color: rgb(0, 0, 128);">End Function</span></span>
+<h2></h2>
+</body>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/dba/howto/IgnoreDriverPrivileges.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/howto/OuterJoinSequence.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/howto/OuterJoinSequence.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/howto/OuterJoinSequence.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/howto/OuterJoinSequence.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,252 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+  <meta http-equiv="content-type"
+ content="text/html; charset=ISO-8859-1">
+  <title>Parameter Name Substitution</title>
+</head>
+<body>
+<h1>Disable/Enable outer join sequnce<br>
+</h1>
+<span style="font-size:xx-large;font-weight:bold">Note:</span> <em>The below information
+is outdated, it applies only to OpenOffice.org versions prior to 2.0.</em>
+<h2>The Problem</h2>
+When working with drivers which not fully support the JDBC or ODBC
+standard, it may happen that the escape sequences are not fully
+supported. Statement like this don't work. <br>
+"SELECT * from {OJ xx left join yy ... }"<br>
+<h2>The Solution</h2>
+The OpenOffice.org data source supports to work around the problem in
+just to remove the {OJ} keywords from the SQL statement.<br>
+<br>
+Disable/Enable outer join sequence can be enabled on a per-data-source
+basis. For
+this, the "Info" property of a <a
+ href="http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSource.html">data
+source</a> should contain a name-value-pair with<br>
+<span style="font-family: monospace;">Name</span>: <span
+ style="font-family: monospace;">EnableOuterJoinEscape</span><span
+ style="font-family: monospace; color: rgb(51, 0, 51);"></span><br>
+<span style="font-family: monospace;">Value</span>: <span
+ style="font-family: monospace;">FALSE</span><br>
+<br>
+Unfortunately, there is no user interface, yet, for doing so. You could
+use the Basic macro provided below, which adds the setting for a data
+source of your choice.<br>
+<h2>The Macro</h2>
+The following macro enables Disable/Enable outer join sequence for a
+data source
+of your choice. You can also download this macro in the <a
+ href="../downloads/">downloads section</a>.<br>
+<br>
+<span style="font-family: monospace; color: rgb(102, 102, 102);">REM&nbsp;
+*****&nbsp; BASIC&nbsp; *****</span><br style="font-family: monospace;">
+<br style="font-family: monospace;">
+<span style="font-family: monospace;"><span
+ style="color: rgb(0, 0, 128);">Option Explicit</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> <span
+ style="color: rgb(0, 128, 0);">Main</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 128, 0);">sDataSourceName</span>
+= <span style="color: rgb(0, 128, 0);">InputBox</span>( <span
+ style="color: rgb(255, 0, 0);">"Please enter the name of the data
+source:"</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="font-family: monospace;"></span><span
+ style="font-family: monospace; color: rgb(0, 128, 0);">IgnoreDriverPrivileges</span></span><span
+ style="font-family: monospace;">(<span style="color: rgb(0, 128, 0);">sDataSourceName</span>
+)<br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> </span><span
+ style="font-family: monospace; color: rgb(0, 128, 0);">IgnoreDriverPrivileges</span><span
+ style="font-family: monospace;"><span style="color: rgb(0, 128, 0);"></span>(<span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source context (ehm - the service name is historical :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aContext</span>
+= <span style="color: rgb(0, 128, 0);">createUnoService</span>( <span
+ style="color: rgb(255, 0, 0);">"com.sun.star.sdb.DatabaseContext"</span>
+)<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 0, 128);">Not</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">hasByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> ) ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">MsgBox</span> <span
+ style="color: rgb(255, 0, 0);">"There is no data source named "</span>
++ <span style="color: rgb(0, 128, 0);">sDataSourceName</span> + <span
+ style="color: rgb(255, 0, 0);">"!"</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">Exit Sub</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aDataSource</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>
+= <span style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">getByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new </span></span><span
+ style="font-family: monospace; color: rgb(102, 102, 102);">IgnoreDriverPrivileges</span><span
+ style="font-family: monospace;"><span
+ style="color: rgb(102, 102, 102);">flag</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bFlag</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bFlag</span> =
+FALSE<span style="color: rgb(0, 128, 0);"></span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aInfo</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> =
+<span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> =
+<span style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aInfo</span>, <span
+ style="color: rgb(255, 0, 0);">"EnableOuterJoinEscape"</span>, <span
+ style="color: rgb(0, 128, 0);">bFlag</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' and
+write back</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span> = <span
+ style="color: rgb(0, 128, 0);">aInfo</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' flush
+(not really necessary, but to be on the safe side :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">flush</span><br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Function</span> <span
+ style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span>,<span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span>, <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span> ) <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nLower</span>
+= <span style="color: rgb(0, 128, 0);">LBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nUpper</span>
+= <span style="color: rgb(0, 128, 0);">UBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' look if
+the setting is already present</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bNeedAdd</span>
+= <span style="color: rgb(0, 128, 0);">TRUE</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">i</span> <span
+ style="color: rgb(0, 0, 128);">As Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> = <span
+ style="color: rgb(0, 128, 0);">FALSE</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">End If</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' allocate
+the new array</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nNewSize</span>
+= ( <span style="color: rgb(0, 128, 0);">nUpper</span> - <span
+ style="color: rgb(0, 128, 0);">nLower</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">Then</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> = <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> + <span
+ style="color: rgb(255, 0, 0);">1</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> ) <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' copy the
+elements (a simply copy does not work in Basic)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ) = <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new setting, if necessary</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">AddInfo</span>
+= <span style="color: rgb(0, 128, 0);">aNewInfo</span>()<br>
+<span style="color: rgb(0, 0, 128);">End Function</span></span>
+<h2></h2>
+</body>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/dba/howto/OuterJoinSequence.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/howto/UserDefinedDriverUI.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/howto/UserDefinedDriverUI.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/howto/UserDefinedDriverUI.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/howto/UserDefinedDriverUI.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,176 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<HTML>
+<HEAD>
+	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
+	<TITLE>Register new driver types for OpenOffice UI</TITLE>
+	<META NAME="GENERATOR" CONTENT="StarOffice 6.0  (Win32)">
+	<META NAME="CREATED" CONTENT="20030129;8365681">
+	<META NAME="CHANGED" CONTENT="20030129;9555296">
+	<META NAME="KEYWORDS" CONTENT="Driver">
+	<STYLE>
+	<!--
+		A:visited { color: #444488 }
+		A:link { color: #444488 }
+	-->
+	</STYLE>
+</HEAD>
+<BODY LANG="de-DE" LINK="#444488" VLINK="#444488" BGCOLOR="#eeeeff">
+<TABLE WIDTH=100% BORDER=0 CELLPADDING=4 CELLSPACING=0 STYLE="page-break-before: always">
+	<COL WIDTH=75>
+	<TR>
+		<TD BGCOLOR="#666699">
+			<H1 ALIGN=CENTER><A HREF="http://www.openoffice.org/"><IMG SRC="../images/open_office_org_logo.gif" NAME="Grafik1" ALT="OpenOffice" ALIGN=RIGHT WIDTH=109 HEIGHT=54 BORDER=0></A><FONT COLOR="#ffffff"><FONT FACE="Arial"><FONT SIZE=5>How to register a new database driver <BR>into
+			OpenOffice UI?</FONT></FONT></FONT></H1>
+		</TD>
+	</TR>
+</TABLE>
+<HR SIZE=3 NOSHADE>
+<TABLE WIDTH=100% BORDER=0 CELLPADDING=4 CELLSPACING=0>
+	<COL WIDTH=256*>
+	<TR>
+		<TD WIDTH=100% BGCOLOR="#666699">
+			<H3 ALIGN=LEFT><FONT COLOR="#ffffff"><FONT SIZE=4>Contents</FONT></FONT></H3>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100%>
+			<DL>
+				<DT><A HREF="#background">The Problem</A><BR><A HREF="#chap1">The
+				Solution</A><A HREF="#installation"><BR></A><A HREF="#chap2">The
+				Macro</A></DT></DL>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100% BGCOLOR="#666699">
+			<H2 ALIGN=LEFT><FONT COLOR="#ffffff"><FONT FACE="Arial"><FONT SIZE=4><I>The
+			Problem</I></FONT></FONT></FONT></H2>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100%>
+			<P>You may want to use a new database driver for your database in OpenOffice but OpenOffice doesn't know it.</P>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100% BGCOLOR="#666699">
+			<H2><FONT COLOR="#ffffff"><FONT FACE="Arial, sans-serif"><FONT SIZE=4><I>The
+			Solution</I></FONT></FONT></FONT></H2>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100%>
+			<P>The OpenOffice.org UI supports the extension of database drivers through a configuration entry.</P>
+			Two steps have to be done before you can use your new driver with OpenOffice. 
+			<BR>The first step is to copy the new driver in the folder $office/user/uno_packages. 
+			After that you have to run the command $office/program/pkgchk. This command register the new driver.
+			In the future it will be possible to run only the pkgchk program to register the driver and to insert the configuration entry.
+			<BR>The second step is to adjust the macro and run it to insert a configuration entry.
+			<P>Three names have to be set in the macro:</P>
+			<TABLE WIDTH=100% BORDER=1 CELLPADDING=4 CELLSPACING=0>
+				<COL WIDTH=53*>
+				<COL WIDTH=203*>
+				<TR VALIGN=TOP>
+					<TD WIDTH=21%>
+						<B>DriverPageDisplayName</B>
+					</TD>
+					<TD WIDTH=79%>
+						<P>This name will be used for the Tabpage of the new database driver.</P>
+					</TD>
+				</TR>
+				<TR VALIGN=TOP>
+					<TD WIDTH=21%>
+						<B>DriverTypeDisplayName</B>
+					</TD>
+					<TD WIDTH=79%>
+						<P>This name will be used in the database type listbox on the general tabpage in the data source administration dialog.</P>
+					</TD>
+				</TR>
+				<TR VALIGN=TOP>
+					<TD WIDTH=21%>
+						<B>DriverDsnPrefix</B>
+					</TD>
+					<TD WIDTH=79%>
+						<P>This name will be the prefix for the URL of the new database driver. <B>This name has to end with a colon.<B></P>
+					</TD>
+				</TR>
+				<TR VALIGN=TOP>
+					<TD WIDTH=21%>
+						<B>Extension</B>
+					</TD>
+					<TD WIDTH=79%>
+						<P>The file extension, which match to this type. Only set when it is file based driver.</P>
+					</TD>
+				</TR>
+			</TABLE>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100% BGCOLOR="#666699">
+			<H3><FONT COLOR="#ffffff"><FONT FACE="Arial, sans-serif"><FONT SIZE=4><I>The
+			Macro</I></FONT></FONT></FONT></H3>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100%>
+			<PRE>REM  *****  BASIC  *****
+
+Sub Main
+	' access the global configuration provider
+	Dim aConfigProvider As Object
+	aConfigProvider = createUnoService( "com.sun.star.configuration.ConfigurationProvider" )
+
+	' create an access object for the driver settings key
+	Dim aDriverSettings As Object
+	Dim aParams(0) As new com.sun.star.beans.PropertyValue
+	aParams(0).Name = "nodepath"
+	aParams(0).Value = "/org.openoffice.Office.DataAccess/UserDefinedDriverSettings"
+	aDriverSettings = aConfigProvider.createInstanceWithArguments( _
+	"com.sun.star.configuration.ConfigurationUpdateAccess", _
+	aParams() )
+
+	aDrv = aDriverSettings.createInstance()
+
+	aDrv.DriverPageDisplayName ="Ocke's own private Driver page"
+	aDrv.DriverTypeDisplayName = "Neo_1" ' this name will be displayed in the Type listbox on the general tabpage
+	aDrv.DriverDsnPrefix ="sdbc:matrix:"    ' this name will be the prefix of the URL
+	aDrv.Extension = "*.OJ" ' will be used by the fileopen dialog
+
+	' create an access object for the mozilla preferences node
+
+	aDriverSettings.insertByName( "Neo_1",aDrv ) ' just a name to make it distinct
+
+
+	' commit the changes done
+	aDriverSettings.commitChanges
+End Sub
+</PRE>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100%>
+			<P><BR>
+			</P>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100%>
+			<HR SIZE=1 NOSHADE>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100% BGCOLOR="#666699">
+			<P ALIGN=LEFT><FONT COLOR="#ffffff">Auhor: <A HREF="mailto:oj@openoffice.org"><FONT COLOR="#ffffff">Ocke
+			Janssen </FONT></A><A HREF="mailto:ibo@system-entwicklung.de"><BR></A>Last
+			Modified: $Date: 2004/10/15 08:12:12 $<BR><I>Copyright &copy; 2001
+			OpenOffice.org</I></FONT></P>
+		</TD>
+	</TR>
+	<TR>
+		<TD WIDTH=100%>
+			<HR SIZE=1 NOSHADE>
+		</TD>
+	</TR>
+</TABLE>
+<HR SIZE=3 NOSHADE>
+</BODY>
+</HTML>
\ No newline at end of file

Propchange: incubator/ooo/ooo-site/trunk/content/dba/howto/UserDefinedDriverUI.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/howto/index.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/howto/index.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/howto/index.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/howto/index.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,44 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+  <head>
+  <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
+  <meta http-equiv="Content-Style-Type" content="text/css">
+  <style type="text/css">@import "/css/dba.css";</style>
+  <title>OpenOffice.org Base - HowTo's</title>
+  <script type="text/javascript" src="/js/dba_default.js"></script>
+</head>
+<body>
+  <b>Project Sections</b>:
+      <a href="../index.html">Home</a>
+    | <a href="../specifications/index.html">Specifications</a>
+    | <a href="../QA/index.html">QA</a>
+    | <a href="../development/index.html">Development</a>
+    | <a href="../drivers/index.html">Database Drivers</a><br/>
+<hr/>
+<div class="dba">
+<h1 id="dba_howto">HowTo's</h1>
+<table cellpadding="0" cellspacing="0" id="Table1">
+  <tbody>
+    <tr class="OddTableRow">
+      <td width="25%"><a href="mozillaprofile.html">change the preferred Mozilla profile</a></td>
+      <td>OpenOffic.org features a database driver which allows access to a variety of address data sources,
+      amongst them the address data of an existent mozilla installation. This describes how to force OOo to
+      access a specific mozilla user profile.
+      </td>
+    </tr>
+    <tr class="EvenTableRow">
+      <td width="25%" style="vertical-align: top;"><a href="UserDefinedDriverUI.html">register new driver types to
+      appear in the data source administration dialog</a>
+      </td>
+      <td>This is an introduction in how to register a new database driver into OpenOffice UI.</td>
+    </tr>
+  </tbody>
+</table>
+<br>
+<br>
+You may also want to visit the <a href="../FAQ/index.html">Tips 'n
+Tricks section</a>, which contains links to additional external
+resources, as well as yet more additional information which may help
+you to ease your OpenOffice.org Base. </div>
+</body>
+</html>
\ No newline at end of file

Propchange: incubator/ooo/ooo-site/trunk/content/dba/howto/index.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/howto/mozillaprofile.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/howto/mozillaprofile.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/howto/mozillaprofile.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/howto/mozillaprofile.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,102 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+  <meta http-equiv="content-type"
+ content="text/html; charset=ISO-8859-1">
+  <title></title>
+</head>
+<body>
+<h1><a name="mozTocId184500" class="mozTocH1"></a>How do I change the
+preferred mozilla address book user profile?</h1>
+<h2>Table of Content</h2>
+<ul>
+  <li><a href="#background">Background</a></li>
+  <li><a href="#config">Configuration</a></li>
+  <li><a href="#restrictions">Restrictions</a></li>
+  <li><a href="#sample">Sample Basic Macro</a><br>
+  </li>
+</ul>
+<h2><a name="background"></a>Background</h2>
+OpenOffic.org features a database driver which allows access to a
+variety of address data sources (mozilla address data, Outlook/Outlook
+Express address data, LDAP data).<br>
+When accessing the mozilla database, by default the first user profile
+found is choosen. On systems where more than one profile exists, this
+may not be what the user wants.<br>
+<h2><a name="config"></a>Configuration</h2>
+There is a configuration entry which tells the SDBC driver accessing
+the address data which profile to use when logging on to mozilla (I use
+the term "log on" here, because for every access to any of the
+above-mentioned data types a connection to mozilla, which provides all
+the data, is necessary).<br>
+<br>
+Setting this entry to a mozilla profile name string forces the driver
+to prefer this profile &#8211; if it is existent.<br>
+<br>
+This entry is located in the configuration module
+/org.openoffice.Office.DataAccess. There is a key
+/DriverSettings/com.sun.star.comp.sdbc.MozabDriver, which stores
+settings for the SDBC address book driver (the second part of the kay is
+the it's implementation name).<br>
+<br>
+Thereunder, there is a key MozillaPreferences/ProfileName, which is of
+type string. If this string is a valid mozilla profiles name, this
+profile is used when logging on to mozilla.<br>
+<h2><a name="restrictions"></a>Restrictions</h2>
+As mozilla does not allow to change the profile name of a session while
+the session is running, after changing the configuration entry
+OpenOffice.org must be restarted if it already opened a mozilla session
+&#8211; i.e. if you already connected to any of the above-mentioned address
+data source types. If you did not do this before, your change in the
+configuration will take effect immediately.<br>
+<h2><a name="sample"></a>Sample Basic Macro</h2>
+The following Basic function will change the configuration entry in
+question to the string passed&nbsp; to it (You can download this macro
+in the <a href="../downloads/index.html">Tools section</a>):
+<pre style="font-family: monospace;"><span
+ style="color: rgb(0, 0, 128);">Sub</span> <span
+ style="color: rgb(0, 128, 0);">ChangeMozillaAddressBookProfile</span>( <span
+ style="color: rgb(0, 128, 0);">sProfileName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span> )<br>  <span
+ style="color: rgb(102, 102, 102);">' access the global configuration provider</span><br>  <span
+ style="color: rgb(0, 0, 153);"><span style="color: rgb(0, 0, 128);">Dim</span> </span><span
+ style="color: rgb(0, 128, 0);">aConfigProvider</span> <span
+ style="color: rgb(0, 0, 128);">As Object</span><br><br>  <span
+ style="color: rgb(0, 128, 0);">aConfigProvider</span> = <span
+ style="color: rgb(0, 128, 0);">createUnoService</span>( _<br>	<span
+ style="color: rgb(255, 0, 0);">"com.sun.star.configuration.ConfigurationProvider"</span> )<br><br>  <span
+ style="color: rgb(102, 102, 102);">' create an access object for the driver settings key</span><br>  <span
+ style="color: rgb(0, 0, 153);"><span style="color: rgb(0, 0, 128);">Dim</span> </span><span
+ style="color: rgb(0, 128, 0);">aParams</span>(0) <span
+ style="color: rgb(0, 0, 128);">As new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span><br>  <span
+ style="color: rgb(0, 128, 0);">aParams</span>(0).<span
+ style="color: rgb(0, 0, 128);">Name </span>= <span
+ style="color: rgb(255, 0, 0);">"nodepath"</span><br>  <span
+ style="color: rgb(0, 128, 0);">aParams</span>(0).<span
+ style="color: rgb(0, 128, 0);">Value</span> = _<br>	  <span
+ style="color: rgb(255, 0, 0);">"/org.openoffice.Office.DataAccess/DriverSettings/com.sun.star.comp.sdbc.MozabDriver"</span><br><br>  <span
+ style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aDriverSettings</span> <span
+ style="color: rgb(0, 0, 128);">As Object</span><br>  <span
+ style="color: rgb(0, 128, 0);">aDriverSettings</span> = <span
+ style="color: rgb(0, 128, 0);">aConfigProvider.createInstanceWithArguments</span>( _<br>    <span
+ style="color: rgb(255, 0, 0);">"com.sun.star.configuration.ConfigurationUpdateAccess"</span>, _<br>    <span
+ style="color: rgb(0, 128, 0);">aParams</span>() )<br><br>  <span
+ style="color: rgb(102, 102, 102);">' create an access object for the mozilla preferences node</span><br>  <span
+ style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aMozPrefs</span> <span
+ style="color: rgb(0, 0, 128);">As Object</span><br>  <span
+ style="color: rgb(0, 128, 0);">aMozPrefs</span> = <span
+ style="color: rgb(0, 128, 0);">aDriverSettings.getByName</span>( <span
+ style="color: rgb(255, 0, 0);">"MozillaPreferences"</span> )<br><br>  <span
+ style="color: rgb(102, 102, 102);">' set the preferred profile name</span><br>  <span
+ style="color: rgb(0, 128, 0);">aMozPrefs.replaceByName</span>( <span
+ style="color: rgb(255, 0, 0);">"ProfileName"</span>, <span
+ style="color: rgb(0, 128, 0);">sProfileName</span> )<br><br>  <span
+ style="color: rgb(102, 102, 102);">' commit the changes done</span><br>  <span
+ style="color: rgb(0, 128, 0);">aDriverSettings.commitChanges()<br><span
+ style="color: rgb(0, 0, 128);">End Sub</span><br></span></pre>
+<br>
+</body>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/dba/howto/mozillaprofile.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/howto/param_subst.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/howto/param_subst.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/howto/param_subst.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/howto/param_subst.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,255 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+  <meta http-equiv="content-type"
+ content="text/html; charset=ISO-8859-1">
+  <title>Parameter Name Substitution</title>
+</head>
+<body>
+<h1>Parameter Name Substitution for ODBC data sources</h1>
+<span style="font-size:xx-large;font-weight:bold">Note:</span> <em>The below information
+is outdated, it applies only to OpenOffice.org versions prior to 2.0.</em>
+<h2>The Problem</h2>
+When working with parametrized statements, OpenOffice.org usually uses
+named parameters such as in "<span style="font-family: monospace;">SELECT
+* FROM &lt;table&gt; WHERE &lt;field&gt; = :param</span>" Here "<span
+ style="font-family: monospace;">:param</span>" is a so-called <span
+ style="font-style: italic;">named parameter</span>. However, some
+databases do not allow such named parameters, but only unnamed ones. The
+statement then would be "<span style="font-family: monospace;">SELECT *
+FROM &lt;table&gt; WHERE &lt;field&gt; = ?</span>". Such databases
+usually reject statements with named parameters.<br>
+<h2>The Solution</h2>
+The OpenOffice.org ODBC-SDBC bridge (more sloppy: OOo's ODBC driver)
+features substituting named parameters with unnamed ones before sending
+statements to the system driver.<br>
+<br>
+Parameter name substitution can be enabled on a per-data-source basis.
+For this, the "Info" property of a <a
+ href="http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSource.html">data
+source</a> should contain a name-value-pair with<br>
+<span style="font-family: monospace;">Name</span>: <span
+ style="font-family: monospace;">ParameterNameSubstituion</span><br>
+<span style="font-family: monospace;">Value</span>: <span
+ style="font-family: monospace;">TRUE</span><br>
+<br>
+Unfortunately, there is no user interface, yet, for doing so. There is
+an <a href="http://www.openoffice.org/issues/show_bug.cgi?id=2794">issuezilla
+bug requesting this UI</a>, but as long as it's not fixed, you could
+use the Basic macro provided below, which adds the setting for a data
+source of your choice.<br>
+<br>
+Note that in OpenOffice.org 1.0.x, this feature is available for ODBC
+drivers only. In later versions (notably in the upcoming 1.1, but also
+in the intermediate developer snapshots), it has been implemented for
+JDBC drivers, too.
+<h2>The Macro</h2>
+The following macro enables parameter name substitution for a data
+source of your choice. You can also download this macro in the <a
+ href="../downloads/">downloads section</a>.<br>
+<br>
+<span style="font-family: monospace; color: rgb(102, 102, 102);">REM&nbsp;
+*****&nbsp; BASIC&nbsp; *****</span><br style="font-family: monospace;">
+<br style="font-family: monospace;">
+<span style="font-family: monospace;"><span
+ style="color: rgb(0, 0, 128);">Option Explicit</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> <span
+ style="color: rgb(0, 128, 0);">Main</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span><br>
+&nbsp;&nbsp; &nbsp;<span style="color: rgb(0, 128, 0);">sDataSourceName</span>
+= <span style="color: rgb(0, 128, 0);">InputBox</span>( <span
+ style="color: rgb(255, 0, 0);">"Please enter the name of the data
+source:"</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">EnableParameterNameSubstitution</span>(<span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> )<br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Sub</span> <span
+ style="color: rgb(0, 128, 0);">EnableParameterNameSubstitution</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source context (ehm - the service name is historical :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aContext</span>
+= <span style="color: rgb(0, 128, 0);">createUnoService</span>( <span
+ style="color: rgb(255, 0, 0);">"com.sun.star.sdb.DatabaseContext"</span>
+)<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 0, 128);">Not</span> <span
+ style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">hasByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> ) ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">MsgBox</span> <span
+ style="color: rgb(255, 0, 0);">"There is no data source named "</span>
++ <span style="color: rgb(0, 128, 0);">sDataSourceName</span> + <span
+ style="color: rgb(255, 0, 0);">"!"</span><br>
+&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">Exit Sub</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' the data
+source</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aDataSource</span> <span
+ style="color: rgb(0, 0, 128);">as Object</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>
+= <span style="color: rgb(0, 128, 0);">aContext</span>.<span
+ style="color: rgb(0, 128, 0);">getByName</span>( <span
+ style="color: rgb(0, 128, 0);">sDataSourceName</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new ParameterNameSubstitution flag</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bFlag</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bFlag</span> = <span
+ style="color: rgb(0, 128, 0);">TRUE</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aInfo</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> = <span
+ style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aInfo</span> = <span
+ style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aInfo</span>, <span
+ style="color: rgb(255, 0, 0);">"ParameterNameSubstitution"</span>, <span
+ style="color: rgb(0, 128, 0);">bFlag</span> )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' and
+write back</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">Info</span> = <span
+ style="color: rgb(0, 128, 0);">aInfo</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' flush
+(not really necessary, but to be on the safe side :)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">aDataSource</span>.<span
+ style="color: rgb(0, 128, 0);">flush</span><br>
+<span style="color: rgb(0, 0, 128);">End Sub</span><br>
+<br>
+<span style="color: rgb(0, 0, 128);">Function</span> <span
+ style="color: rgb(0, 128, 0);">AddInfo</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span>,<span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> <span
+ style="color: rgb(0, 0, 128);">as String</span>, <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span> <span
+ style="color: rgb(0, 0, 128);">as Variant</span> ) <span
+ style="color: rgb(0, 0, 128);">as Variant</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nLower</span> = <span
+ style="color: rgb(0, 128, 0);">LBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nUpper</span> = <span
+ style="color: rgb(0, 128, 0);">UBound</span>( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>() )<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' look if
+the setting is already present</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">as Boolean</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">bNeedAdd</span>
+= <span style="color: rgb(0, 128, 0);">TRUE</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">i</span> <span
+ style="color: rgb(0, 0, 128);">As Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> = <span
+ style="color: rgb(0, 128, 0);">FALSE</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 0, 128);">End If</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' allocate
+the new array</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> <span
+ style="color: rgb(0, 0, 128);">as Integer</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">nNewSize</span>
+= ( <span style="color: rgb(0, 128, 0);">nUpper</span> - <span
+ style="color: rgb(0, 128, 0);">nLower</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> <span
+ style="color: rgb(0, 0, 128);">Then</span> <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> = <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> + <span
+ style="color: rgb(255, 0, 0);">1</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Dim</span> <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nNewSize</span> ) <span
+ style="color: rgb(0, 0, 128);">as new</span> <span
+ style="color: rgb(0, 128, 0);">com.sun.star.beans.PropertyValue</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' copy the
+elements (a simply copy does not work in Basic)</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">For</span> <span
+ style="color: rgb(0, 128, 0);">i</span> = <span
+ style="color: rgb(0, 128, 0);">nLower</span> <span
+ style="color: rgb(0, 0, 128);">To</span> <span
+ style="color: rgb(0, 128, 0);">nUpper</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> ) = <span
+ style="color: rgb(0, 128, 0);">aOldInfo</span>( <span
+ style="color: rgb(0, 128, 0);">i</span> )<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">Next</span> i<br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(102, 102, 102);">' append
+the new setting, if necessary</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">If</span> ( <span
+ style="color: rgb(0, 128, 0);">bNeedAdd</span> ) <span
+ style="color: rgb(0, 0, 128);">Then</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 0, 128);">Name</span> = <span
+ style="color: rgb(0, 128, 0);">sSettingsName</span><br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span
+ style="color: rgb(0, 128, 0);">aNewInfo</span>( <span
+ style="color: rgb(0, 128, 0);">nUpper</span> + <span
+ style="color: rgb(255, 0, 0);">1</span> ).<span
+ style="color: rgb(0, 128, 0);">Value</span> = <span
+ style="color: rgb(0, 128, 0);">aSettingsValue</span><br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 0, 128);">End If</span><br>
+<br>
+&nbsp;&nbsp;&nbsp; <span style="color: rgb(0, 128, 0);">AddInfo</span>
+= <span style="color: rgb(0, 128, 0);">aNewInfo</span>()<br>
+<span style="color: rgb(0, 0, 128);">End Function</span></span>
+<h2></h2>
+</body>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/dba/howto/param_subst.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_ccccff.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_ccccff.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_ccccff.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_dee4ee.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_dee4ee.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_dee4ee.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_eeeeee.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_eeeeee.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/dba_edge_eeeeee.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/html.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/html.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/html.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/new.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/new.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/new.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/odt.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/odt.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/odt.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/open_office_org_logo.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/open_office_org_logo.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/open_office_org_logo.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/smile.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/smile.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/smile.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/images/sxw.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/images/sxw.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/images/sxw.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/dba/js/dba_default.js
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/js/dba_default.js?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/js/dba_default.js (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/js/dba_default.js Mon Nov 21 23:15:57 2011
@@ -0,0 +1,16 @@
+
+window.onload=function(){ onLoad(); }
+
+function onLoad()
+{
+    // in the left hand side menu, hilight the item representing the current page
+    hilighCurrentMenuItem();
+}
+
+function hilighCurrentMenuItem()
+{
+    var heading = document.getElementsByTagName( "h1" )[0];
+    var currentMenuItem = document.getElementById( heading.id + "_item_menu_left" );
+    var menuItemLink = currentMenuItem.getElementsByTagName( "a" )[0];
+    menuItemLink.setAttribute( "class", "selected" );
+}

Propchange: incubator/ooo/ooo-site/trunk/content/dba/js/dba_default.js
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/ADO_Browse_Dialog.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/ADO_Browse_Dialog.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/ADO_Browse_Dialog.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream



Mime
View raw message