[dba-issues] [Issue 108229] Date/Time functions do no t work with parameters
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108229 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|OOo Later |OOo 3.4 --- Additional comments from o...@openoffice.org Tue Jan 4 12:42:00 + 2011 --- Fixed in cws dba34c - 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 108229] Date/Time functions do no t work with parameters
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108229 --- Additional comments from f...@openoffice.org Mon Feb 1 19:29:09 + 2010 --- Created an attachment (id=67513) document to reproduce the bug case - 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 108229] Date/Time functions do no t work with parameters
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108229 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Target milestone|--- |OOo Later --- Additional comments from f...@openoffice.org Mon Feb 1 19:34:35 + 2010 --- confirming: - open the attached database document - open the contained query by double-clicking it = the parameter input dialog opens - enter a date value in the Value field - press OK = you get an error message saying that this is no legitimate value for the column (which is wrong) - enter a plain numeric value in the Value field - press OK = the value is accepted (which is wrong) = the query's data view opens, but you get an error message saying something about an illegal type fs-oj: I'd say the problem here is that the parser recognizes the parameter as integer column, since the return type of DAYOFWEEK is an integer. It should, however, recognize it as date column. - 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 108229] Date/Time functions do no t work with parameters
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108229 User r4zoli changed the following: What|Old value |New value CC|''|'r4zoli' Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords| |oooqa Version|1.0.0 |OOo 3.2 RC1 --- Additional comments from r4z...@openoffice.org Tue Jan 12 08:27:11 + 2010 --- I can confirm on OOo3.2RC1 linux version(only tested on 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
[dba-issues] [Issue 108229] Date/Time functions do no t work with parameters
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108229 Issue #|108229 Summary|Date/Time functions do not work with parameters Component|Database access Version|1.0.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Mon Jan 11 19:45:33 + 2010 --- SELECT * FROM X WHERE DAYOFWEEK( :paramDay )= X.WeekDay = wrong type Same problem with other date/time functions and :parameter substitution (I tested MONTH, HOUR) - 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org