[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Tue Nov 24 13:25:43 + 2009 --- -> closed - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 User mechtilde changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |FIXED --- Additional comments from mechti...@openoffice.org Tue Nov 24 13:24:53 + 2009 --- so I set to fixed - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 --- Additional comments from ville...@openoffice.org Wed Oct 7 17:20:38 + 2009 --- Base uses named parameters and they do work with data pilots. SELECT * FROM "Table" WHERE "Field"=:param - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 --- Additional comments from f...@openoffice.org Wed Sep 2 08:17:06 + 2009 --- Hmm, is this issue still valid? It was reported for 2.2.1, and trying the data pilot in OOo 3.1, which a query containing an anonymous parameter, pops up the usual parameter dialog asking for user input. (The dialog opens two times, which is once to often of course.) Don't know too little about how the data pilot is expected to work to judge whether the result is correct, though. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 User sweigel changed the following: What|Old value |New value CC|'mechtilde,pagalmes,sweige|'fs,mechtilde,pagalmes,swe |l'|igel' --- Additional comments from swei...@openoffice.org Mon Aug 31 18:33:28 + 2009 --- fs, pse have a look! Seems to me, that this is not related to Datapilot and not related to Calc. So: Wrong component? Rather: Component = Database access? OOo seems not to be able to get data from a query with a paramater in the database backend. So: Wrong issue type? Rather: Issue type = Feature? - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 User mechtilde changed the following: What|Old value |New value CC|'pagalmes'|'mechtilde,pagalmes,sweige | |l' --- Additional comments from mechti...@openoffice.org Mon Apr 13 08:39:37 + 2009 --- @ sweigel add to CC Can you have a look at it? - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 User pagalmes changed the following: What|Old value |New value CC|''|'pagalmes' - 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]
[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 Issue #|79240 Summary|Datapilot with datasource query and named or unnamed p |arameters malfunctions Component|Spreadsheet Version|OOo 2.2.1 Platform|PC URL|http://www.oooforum.org/forum/viewtopic.phtml?p=2549 OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|ftoth --- Additional comments from [EMAIL PROTECTED] Wed Jul 4 20:56:24 + 2007 --- When the datapilot is setup to connect to a datasource of type query that contains a named parameter (WHERE column = :criterium) of unnamed (WHERE column = ?) it fails with a message like unknown parameter or so. The expected behavior is to pop up the parameter dialog box. This occurs with the databases mentioned in the url above, as well as postgresql using the JDBC driver (my project). Ferry - 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]