Andrew Jensen wrote:
Hi Drew,
SELECT `ID`, `VARCHAR_1`, LEFT( `VARCHAR_1`, 4 ) AS `RES_1` FROM
`openoffice`.`test_table_1` AS `test_table_1`
OK, so here is the odd part ( I might feel an issue coming on here ).
Both run fine with the designer turned on.
Both run fine in SQL view and escape processing turned on.
Turn escape processing off and the HSQL version runs as expected. Under
MySQL the column RES_1 is returned with a null string for a name and all
null values in the result set. Removing the column alias has no effect
- the query runs, but is useless in direct mode.
Any MySQL/JDBC guru's out there with any idea of what is up?
I take it that the SELECT VARCHAR_1 returns correct results ?
One other thought I have is that I've noticed that MySQL can be rather
picky about all of the quotation marks that OOo puts in.
Alex
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
