To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87648 Issue #|87648 Summary|Listbox content shown as ASCII code when using CONCAT |with num types Component|Database access Version|OOo 2.2.1 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ufalke
------- Additional comments from [EMAIL PROTECTED] Mon Mar 31 13:48:04 +0000 2008 ------- accessing a databse on a remote MySQL DB server via JDBC. when using a CONCAT statement for filling listboxes in forms, and at least one of the fields in the CONCAT statement is of type INT, then, instead of the intended strings in the listbox, their ASCII codes are displayed. Particularily , I used the following to set the listbox content: "SELECT CONCAT(OFFSETHRS,' ',OFFSETMINS), ID FROM `sofs_db`.`TZ`;" When I run that statement against the MySQL server, i get an appropriate response: mysql> SELECT CONCAT(OFFSETHRS,' ',OFFSETMINS), ID FROM `sofs_db`.`TZ` ; +----------------------------------+----+ | CONCAT(OFFSETHRS,' ',OFFSETMINS) | ID | +----------------------------------+----+ | -12 0 | 1 | | -11 0 | 2 | | -10 0 | 3 | | -9 -30 | 4 | .... | 13 0 | 39 | | 14 0 | 40 | +----------------------------------+----+ 40 rows in set (0.08 sec) However, the list box does show the ASCII codes of the expected output, like '0x2d31322030' instead of '-12 0' - not what I want. (For confirmation: [EMAIL PROTECTED] ~]$ echo '-12 0' | od -t x1 -c 0000000 2d 31 32 20 30 0a - 1 2 0 \n ) When i drop the use of CONCAT(), i.e. when I use an SQL statement like "SELECT OFFSETHRS, ID FROM `sofs_db`.`TZ`;" the data are displayed as they expected (I need just to see data from more fields ...). It does also produce the expected result, if the CONCAT does not contain INT typed fields. I opened a thread for that issue in the Base Forum last Friday (http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=3996), but did not get fruitful responses, thus I submit the issue here. --------------------------------------------------------------------- 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]
