[dba-issues] [Issue 69432] named parameters do not wo rk for MySQL-Database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69432 --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 00:28:26 -0700 2006 --- I can check that, i hope this only refers to the a bit exaggerated Priority. In case you can't reconstruct the problem feel free to ask me for more details that might be missing. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69432] named parameters do not wo rk for MySQL-Database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69432 --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 04:30:20 -0700 2006 --- Hi, great idea!! If i name the parameter different from the field name of the main form it works. But i still found some strange behavior: - There is no difference between using the SQL query designer and entering the SQL string manual. - Linking the subform with a named parameter only works if i use a different name for the named parameter as mentioned above and if i use OOo 1.1.X to change the SQL query and if i then open the form in OOo 2.0.3. In case i change the SQL query in OOo 2.0.3 there will be a warning no value specified for parameter 2 and the subform will stay empty. I think there is a problem how OOo sends the Query to MySQL because i have to use apostrophs in the query like 'position' = :'xposition' in OOo 1.1.X. If i do exactly the same in OOo 2.0.3 there will be the warning??? regards Willie - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69432] named parameters do not wo rk
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69432 Issue #|69432 Summary|named parameters do not work Component|Database access Version|OOo 2.0.3 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|willie2 --- Additional comments from [EMAIL PROTECTED] Sun Sep 10 09:59:19 -0700 2006 --- In OpenOffice 2.0.3 (i tried also 2.0.1) the use of named parameters does not work in combination with a MySQL-Database. When I use a SQL query with named parameters (something like: position = :position) to link a subform to a main form there is only a popup window to ask me to supply the parameter but the subform stays empty. In OOo 1.1.X the same query and form works without any problems. In extended properties of the database connection replace named parameters with '?' is activated. I tried different Versions of MySQL (4.0 and 4.1), different computers, a jdbc and a ODBC connection to the database and the latest jdbc driver from MySQL. I think the problem is in the connection OOo to MySQL because someone reported to me the use of named parameters works well with OOo and PostgreSQL. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]