[dba-issues] [Issue 53918] Error in SQL date range qu ery when attached to Postgresql database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53918 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Sun May 18 08:04:45 + 2008 --- -> 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: [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 53918] Error in SQL date range qu ery when attached to Postgresql database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53918 User jbu changed the following: What|Old value |New value CC|'clu,mroe'|'clu,mroe,oj' Status|NEW |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Thu Aug 23 18:37:23 + 2007 --- is duplicate to http://www.openoffice.org/issues/show_bug.cgi?id=78988, issue must be solved in ooo framework. Bye, Joerg *** This issue has been marked as a duplicate of 78988 *** - 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 53918] Error in SQL date range qu ery when attached to Postgresql database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53918 User oj changed the following: What|Old value |New value Assigned to|oj|jbu --- Additional comments from [EMAIL PROTECTED] Thu Aug 23 13:16:21 + 2007 --- Could you please take care for this one. - 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 53918] Error in SQL date range qu ery when attached to Postgresql database
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53918
User mroe changed the following:
What|Old value |New value
CC|'clu' |'clu,mroe'
--- Additional comments from [EMAIL PROTECTED] Tue Mar 20 13:43:13 +
2007 ---
This problem occurs also in OOo 2.1.
A query using directly the SQL string
... WHERE ("starttime" > '2005-08-20')
works.
But the form filter is not useable. :-(
-
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 53918] Error in SQL date range qu ery when attached to Postgresql database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53918 --- Additional comments from [EMAIL PROTECTED] Sat Aug 12 19:27:44 -0700 2006 --- This error also occurs when a user searches via a form filter date field, and in my case, appears to cause a loss of state triggering an error in one of my macros (probably my bad macro scripting) that requires a File -> Reload (I use Calc based forms). PostgreSQL understands the standard SQL syntax: CAST ( expression AS type ) I.e. this works in PostgreSQL: CAST ( '2005-08-20' AS Date ) According to their documentation, Oracle, HSQLDB and MySQL also accept this syntax. - 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]
