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]
