[dba-issues] [Issue 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User clu changed the following: What|Old value |New value Assigned to|clu |oj --- Additional comments from [EMAIL PROTECTED] Tue Jan 24 03:17:03 -0800 2006 --- now i can repro that, like described in a src680m151 clu-oj: i used following LDAP source ( Hostname: sun-ds.central.sun.com ; Base DN: dc=sun;dc=com ; Port Nr: 389) short repro: 1. create query and choose any field from table container 2. insert an alias name, choose any sorting order and run query -Error: The data content could not be loaded. Unknown column name! clu- works fine with hsql db - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 --- Additional comments from [EMAIL PROTECTED] Tue Jan 24 03:21:46 -0800 2006 --- clu-wurzel: this looks like an LDAP problem (does not occure with hsql this way), so your problem is probably anything else - please write a seperate task for it thy - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User oj changed the following: What|Old value |New value Assigned to|oj|fs --- Additional comments from [EMAIL PROTECTED] Tue Jan 24 03:54:09 -0800 2006 --- Please take care for this one. Thanks. - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User wurzel changed the following: What|Old value |New value Target milestone|--- |OOo 2.0.2 --- Additional comments from [EMAIL PROTECTED] Tue Jan 17 05:12:32 -0800 2006 --- Target set to 2.0.2 If this can't be fixed for 2.0.2 timeframe, then it ought to be fixed in 2.0.3 alex - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User atjensen changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=33301) Look at query1 --- Additional comments from [EMAIL PROTECTED] Tue Jan 17 05:18:45 -0800 2006 --- Created an attachment (id=33301) Look at query1 - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 --- Additional comments from [EMAIL PROTECTED] Tue Jan 17 05:22:21 -0800 2006 --- Regarding the parameterized query, in the GUI builder you must add a second column, from, and for, one of the grouped columns and then use the parameter on it. I have attached the same database named Collecte_2 with a query 'Query1' that shows what I mean, when it is run you are prompted - enter the value 12 for muir and all is well. This may not FIX the bug, but it is a work around. Note it will NOT work for a LIKE comparison for some reason, unless you include the complete columns value. So if I a column named 'name' and a value of 'Bob' LIKE B% would return zero records but LIKE Bob would work, using the above the techniqe - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User clu changed the following: What|Old value |New value Target milestone|OOo 2.0.2 |OOo Later --- Additional comments from [EMAIL PROTECTED] Tue Jan 17 07:04:08 -0800 2006 --- correct target milestone - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User wurzel changed the following: What|Old value |New value Status|CLOSED|UNCONFIRMED Resolution|INVALID | --- Additional comments from [EMAIL PROTECTED] Sun Jan 15 07:39:31 -0800 2006 --- Hmm..., try this query in a hsqldb and parameterized querying with a query already containing an aggregate function (SUM, COUNT, AVG, etc) fails : SELECT SUM( collecte.Litrage ) AS Litrage par mois, collecte.mois, Adhérents.Société, Adhérents.Nom, Adhérents.Prénom, Adhérents.Adresse, Adhérents.CP, Adhérents.Ville FROM collecte collecte, Adhérents Adhérents WHERE ( collecte.Producteur = Adhérents.Nom ) GROUP BY collecte.mois, Adhérents.Société, Adhérents.Nom, Adhérents.Prénom, Adhérents.Adresse, Adhérents.CP, Adhérents.Ville HAVING ( ( collecte.mois = :mois ) ) The above is the query constructed by OOo 2.0.2 (m150) when the query was built using the GUI query builder. In order to compare, the following queries work : SELECT SUM( Litrage ), Cuve FROM collecte collecte GROUP BY Cuve SELECT Date, Producteur, Litrage, mois FROM collecte collecte WHERE ( ( mois = :mois ) ) The sample database is included. Setting oooqa and confirming. alex - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User wurzel changed the following: What|Old value |New value CC|'jcdamgaard' |'jcdamgaard,wurzel' Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords|needmoreinfo |oooqa OS/Version|Windows XP|All --- Additional comments from [EMAIL PROTECTED] Sun Jan 15 07:40:51 -0800 2006 --- confirming, setting oooqa, adding myself to cc - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User wurzel changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=33231) sample db | |showing problem with group | |by, aggregate function and | |parameter query --- Additional comments from [EMAIL PROTECTED] Sun Jan 15 07:43:40 -0800 2006 --- Created an attachment (id=33231) sample db showing problem with group by, aggregate function and parameter query - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User clu changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Tue Sep 27 05:36:53 -0700 2005 --- no repro, no respond - close - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 User clu changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from [EMAIL PROTECTED] Wed Sep 7 03:06:31 -0700 2005 --- clu-elchi: has fs hint help you further? seems not to be a bug - can you acknowledge that? thx - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 --- Additional comments from [EMAIL PROTECTED] Tue Jun 21 00:46:46 -0700 2005 --- I tried connecting to an Access Database with ODBC, and had exactly the same error. (Error message: 'too few parameters' 'expected 1') - 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 50175] Error in Query Design wit h Aliases and Sorting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50175 --- Additional comments from [EMAIL PROTECTED] Tue Jun 21 00:55:44 -0700 2005 --- jcdamgaard, I don't think that your problem is related, since you're talking about a different database, a different connection type, and a different error message. So, as a note completely unrelated to this issue here, you might want to try http://dba.openoffice.org/howto/param_subst.html. - 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]