[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 User msc changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |msc Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 00:34:45 -0700 2006 --- Hi, I can reproduce this if and only if you enter the sql string manual _and_ if the name of the parameter is the same as the field name from the master table. If you name the parameter not position but x_position this works for me. Can you confirm this. Bye Marc - 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 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 User msc changed the following: What|Old value |New value Assigned to|msc |fs Priority|P2|P3 Target milestone|not determined|OOo 2.x --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 05:10:46 -0700 2006 --- Hi Willie, Ok, I send this issue to the right developer to fix the problem when the parameter has the same name as the field. There is no difference between using the SQL query designer and entering the SQL string manual. this is intended in this way to support users without sql knowlegde Bye Marc - 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 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' Keywords| |oooqa Priority|P1|P2 Summary|named parameters do not wo|named parameters do not wo |rk|rk for MySQL-Database --- Additional comments from [EMAIL PROTECTED] Sun Sep 10 10:52:05 -0700 2006 --- No P1, but may be serious. I can't check that. - 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]