[dba-issues] [Issue 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed Feb 20 09:22:01 + 2008 --- Tested w/ XP, 2.4 SP1, Postgres 8.3 Closing Opened related RFE #86255 - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78988
User lla changed the following:
What|Old value |New value
Status|RESOLVED |VERIFIED
--- Additional comments from [EMAIL PROTECTED] Mon Jan 7 14:03:58 +
2008 ---
Basic Macro to set the 'EscapeDateTime' property to 'false'
Sub Main
dbcontext = createunoservice("com.sun.star.sdb.DatabaseContext")
dbsource = dbcontext.getByName("NameOfYourDB")
dbsource.settings.EscapeDateTime = false
End Sub
Now it works with dates in quotes ('07.01.2008')
-
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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 User lla changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Mon Dec 3 12:24:37 + 2007 --- Now, there exists internally a new property 'EscapeDateTime' which is default 'true'. Set it to false will give date as simple strings in single quotes. - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Mon Sep 3 12:30:15 + 2007 --- Thanks for the tips! ;-) - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Mon Sep 3 09:08:15 + 2007 --- it's relatively easy, it's to be fixed in OOo Base, it's targeted for OOo 2.x which means the current plan is to fix it somewhere on the way to OOo 3.0 (2.4 or 3.0 itself). - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Fri Aug 31 08:11:59 + 2007 --- Do we have any news / clues? This is a bug for SDBC driver postgres or OpenOffice Base? All of them? Is it easy, hard, impossible to resolve? Thanks for any information... :-) - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78988
--- Additional comments from [EMAIL PROTECTED] Fri Aug 24 20:55:45 +
2007 ---
CAST ( expression AS type )
CAST ( '2005-08-20' AS Date )
is valid ANSI SQL.
to_date('2005-08-20','-MM-DD') may also be valid SQL.
The brace format {D '2006-01-01' } being generated by OpenOffice is not valid
SQL.
-
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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 User mroe changed the following: What|Old value |New value CC|''|'mroe' - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Thu Aug 23 18:37:22 + 2007 --- *** Issue 53918 has been marked as a duplicate of this issue. *** - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 18:40:56 + 2007 --- *** Issue 80900 has been marked as a duplicate of this issue. *** - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Mon Jul 2 19:33:01 + 2007 --- workaround until a proper setting is available: - create your query in designe view and save it - switch to sqlview, remove the curly braces and the D - execute it or save it for later execution - evertime you change the query, redo the above steps. Bye, Joerg - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 23:25:41 + 2007 --- This is Open Office 2.1 running on Windows XP with postgresql SDBC Driver 0.7.4 connecting to Postgres 8.2 running on Red Hat Enterprise Linux 5.0 - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 User fs changed the following: What|Old value |New value Assigned to|jbu |lla Target milestone|--- |OOo 2.x --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 21:18:38 + 2007 --- fs->lla: That's something you could implement in the 2.x timeframe. Please ask for details before embarking. - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 User fs changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 21:17:17 + 2007 --- That's ODBC notation for dates. I would have sworn there is a setting to not use this notation, in the "Advanced settings" of the database properties, but there isn't. - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 02:21:56 + 2007 --- According to the Mimer SQL-2003 Validator at http://developer.mimer.com/validator/parser200x/index.tml, the query being generated by OpenOffice Base is not valid SQL-2003 either. - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78988
--- Additional comments from [EMAIL PROTECTED] Fri Jun 29 02:18:02 +
2007 ---
The SQL-99 Validator at http://developer.mimer.com/validator/parser99/index.tml
says that the SQL generated by OpenOffice
SELECT * FROM "public"."yaf" WHERE ( ( "event_date" > {D '2006-01-01' } ) )
is not valid SQL 99. So maybe the problem is entirely with OpenOffice Base
generating invalid SQL, and not with the Postgres driver specifically.
-
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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78988
Issue #|78988
Summary|Date queries add braces around dates, causing an error
Component|Database access
Version|OOo 2.2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|jbu
Reported by|eeka1234
--- Additional comments from [EMAIL PROTECTED] Fri Jun 29 01:54:15 +
2007 ---
Postgres or the Postgres driver doesn't like the braces that are added around
dates when making a query in query Design View.
In OpenOffice.org Base, if I create a query in Design View
with a criteria such as
> '2007-01-01'
for a date field, when I try to execute the query I get the following error:
Error code: 1
pq_driver: [PGRES_FATAL_ERROR]ERROR: syntax error at or near "{" at character
55
(caused by statement 'SELECT * FROM "public"."yaf" WHERE ( ( "event_date" > {D
'2006-01-01' } ) )')
If I go in and edit the SQL by hand by changing the query to 'SELECT * FROM
"public"."yaf" WHERE ( ( "event_date" > '2006-01-01' ) )') the query works okay.
-
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]
