To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50344 Issue #:|50344 Summary:|Data Pilot does not handle MySQL datatime columns Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|bachtiar
------- Additional comments from [EMAIL PROTECTED] Sun Jun 5 13:06:45 -0700 2005 ------- 1. Create a table in MySQL: create table test (a datetime not null) 2. Insert some rows into test 3. Create a data source to jdbc:mysql: (use either table or query type to get data from table test) 4. In Calc, open Data Pilot and select data source 5. Drag column "a" to "Row Fields" 6. Hit OK 7. (empty) is displayed instead of correct dates & times Remarks: - Reported against on Windows 2000, JDK 1.4 & 1.5, MySQL connector 3.0.15, 3.1.8, MySQL 4.1.7, OOo 1.1.2 & 2.0 Beta - appended "?useUnicode=true&characterEncoding=utf8" to connection string - Drag & drop from "Data Sources" explorer into sheet works OK - Data source can be query or table, doesn't matter - Tables with DATE columns work OK - select date(a) from test works OK --------------------------------------------------------------------- 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]
