Re: Re: CAST() no longer working with OOO 330m16

Fernand,

On 09.12.2010 18:13, Fernand Vanrie wrote:
> Ocke,
>
> sorry in my code no "space" , then i typed "cast in uppercase(CAST), no
> difference......
You can't remove the space. It is later on inserted short before it was 
sent to the database.

- oj
>
> cast(`mag_news_export`.`DATUM` as date) AS `DATUM`,
>
>>
>> On 09.12.2010 15:28, Fernand Vanrie wrote:
>>> Ocke,
>>>
>>> It has certainly nothing to sea with the SQL version or server type. I
>>> work in a company envoriment, everyone uses the same SQL server, same
>>> native OO-connector. Everyone works on OO 3.2 without problems, i test
>>> 3.3 and have the CAST problem:
>>> cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where
>>> `mag_news_export`.`DATUM` has a imported data (dd/mm/yyyy)
>>> hope it helps
>> I already fixed the issue and better it looks like it will make it
>> into 3.3 :-) The problem was the space "CAST (" doesn't work "CAST("
>> -> works.
>>
>> - oj
>>
>> PS: cws is dba33m
>>>
>>> Fernand
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>
>