[Libreoffice-bugs] [Bug 51767] RTL: Named Parameters not supported in MySQL ODBC queries in Ubuntu 12.04
https://bugs.freedesktop.org/show_bug.cgi?id=51767 Alex Thurgood changed: What|Removed |Added Status|NEEDINFO|NEW AssignedTo|libreoffice-b...@lists.free |lio...@mamane.lu |desktop.org | CC||lio...@mamane.lu --- Comment #6 from Alex Thurgood 2012-08-31 08:14:14 UTC --- Adding Lionel to CC @Lionel : Looks like the UI option to activate parameter substitution has gone AWOL, but I still see stuff in the source tree : git grep ParameterNameSubstitution connectivity/qa/complex/connectivity/HsqlDriverTest.java:,new com.sun.star.beans.PropertyValue("ParameterNameSubstitution",0, false,PropertyState.DIRECT_VALUE) connectivity/registry/jdbc/org/openoffice/Office/DataAccess/Drivers.xcu: connectivity/registry/odbc/org/openoffice/Office/DataAccess/Drivers.xcu: connectivity/source/drivers/jdbc/JConnection.cxx:m_bParameterSubstitution = aSettings.getOrDefault( "ParameterNameSubstitution", m_bParameterSubstitution ); connectivity/source/drivers/jdbc/JDriver.cxx: ::rtl::OUString("ParameterNameSubstitution") connectivity/source/drivers/jdbc/tools.cxx:&& pBegin->Name.compareToAscii( "ParameterNameSubstitution" ) connectivity/source/drivers/mysql/YDriver.cxx: ::rtl::OUString("ParameterNameSubstitution") connectivity/source/drivers/odbcbase/OConnection.cxx:const char* pParaName = "ParameterNameSubstitution"; connectivity/source/drivers/odbcbase/ODriver.cxx: ::rtl::OUString("ParameterNameSubstitution") connectivity/source/resource/conn_shared_res.src:Text [ en-US ] = "You tried to set a parameter at position '$pos$' but there is/are only '$count$' parameter(s) allowed. On dbaccess/source/core/dataaccess/ModelImpl.cxx:AsciiPropertyValue( "ParameterNameSubstitution", makeAny( (sal_Bool)sal_False ) ), dbaccess/source/inc/stringconstants.inc:IMPLEMENT_CONSTASCII_USTRING(INFO_PARAMETERNAMESUBST,"ParameterNameSubstitution"); dbaccess/source/ui/misc/dsmeta.cxx:{ DSID_PARAMETERNAMESUBST, "ParameterNameSubstitution" }, offapi/com/sun/star/sdbc/ODBCConnectionProperties.idl:[optional, property] boolean ParameterNameSubstitution; Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51767] RTL: Named Parameters not supported in MySQL ODBC queries in Ubuntu 12.04
https://bugs.freedesktop.org/show_bug.cgi?id=51767 --- Comment #5 from Alex Thurgood 2012-08-31 08:10:40 UTC --- As a start, the first thing to do would be to look inside the ODB file and see whether the name-value pair is present in the "Info" file : Parameter name substitution can be enabled on a per-data-source basis. For this, the "Info" property of a data source should contain a name-value-pair with Name: ParameterNameSubstituion Value: TRUE If not, then try adding it with the macro provided at the same page. Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51767] RTL: Named Parameters not supported in MySQL ODBC queries in Ubuntu 12.04
https://bugs.freedesktop.org/show_bug.cgi?id=51767 --- Comment #4 from Alex Thurgood 2012-08-31 08:00:29 UTC --- So, this feature was definitely in the OOo UI at one stage, and somehow is no longer there, see this page, where it was talked about in OOo 2.0 and then introduced : http://www.openoffice.org/dba/howto/param_subst.html Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51767] RTL: Named Parameters not supported in MySQL ODBC queries in Ubuntu 12.04
https://bugs.freedesktop.org/show_bug.cgi?id=51767 --- Comment #3 from Alex Thurgood 2012-08-31 07:53:32 UTC --- (In reply to comment #2) > @Andrew : I am assuming that you did set the option > "ParameterNameSubstitution" > in the Advanced Properties dialog of your database connection ? > > > Alex Forget that last comment, it seems that the option in question is no longer present, at least in LO 3.5.4 and 3.6.0.4 - hmm, I wonder when that happened ? I will have to check on an older version of OpenOffice.org. Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51767] RTL: Named Parameters not supported in MySQL ODBC queries in Ubuntu 12.04
https://bugs.freedesktop.org/show_bug.cgi?id=51767 --- Comment #2 from Alex Thurgood 2012-08-31 07:39:12 UTC --- @Andrew : I am assuming that you did set the option "ParameterNameSubstitution" in the Advanced Properties dialog of your database connection ? Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51767] RTL: Named Parameters not supported in MySQL ODBC queries in Ubuntu 12.04
https://bugs.freedesktop.org/show_bug.cgi?id=51767 Jochen changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||d...@jochenschiffers.de, ||LibreOffice@bielefeldundbus ||s.de, ||rob...@familiegrosskopf.de Ever Confirmed|0 |1 --- Comment #1 from Jochen 2012-08-30 08:33:31 UTC --- @Robert Please: have a look at this bugreport. Can you confirm the behavior? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs