Hi Fernand,
On 09.12.2010 15:43, Fernand Vanrie wrote:
Ocke,
I was just wondering, my problems with CAST started (i think) after i
instaled the very latest (oracle-report-builder-OOO330-m3.oxt)for
testing . Now i tried to remove this ORB version but i get a error so i
can not test without ORB l
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 `
Ocke,
sorry in my code no "space" , then i typed "cast in uppercase(CAST), no
difference..
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 envo
> 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
Excellent, great news, thanks :-)
Alex
Ocke,
I was just wondering, my problems with CAST started (i think) after i
instaled the very latest (oracle-report-builder-OOO330-m3.oxt)for
testing . Now i tried to remove this ORB version but i get a error so i
can not test without ORB loaded.
just a hint
PS. how do i remove this unremo
Hi Fernand,
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
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 `
Hi Alex,
On 09.12.2010 10:35, Alex Thurgood wrote:
Hi Ocke,
- "Ocke Janssen" a écrit :
As I mentioned, CAST works for me with OOo 3.2.1. It also works for
me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that
is based on).
One more interesting thing
when executing
sele
Hi Ocke,
- "Ocke Janssen" a écrit :
> > As I mentioned, CAST works for me with OOo 3.2.1. It also works for
> me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that
> is based on).
> One more interesting thing
> when executing
> select CAST('2001-01-01' as DATE)
> works, but
Hi Alex,
First of all if I could I would like to fix it.
On 09.12.2010 09:34, Alex Thurgood wrote:
Hi Ocke,
- "Ocke Janssen" a écrit :
I just have to set the issue to wontfix. :-(
The problem seems to be the database. Even with odbctest I get the
same
results => error and I tested a S
>
> I'm going to test my actual setup with the latest OOoRC, if I can get
> it to install nicely beside my current OOo 3.2.1 on MacOSX.
>
More info : I have just tested with OOo 3.3rc7, same connector, same mysql
server, and CAST still functions correctly for me. So my guess is that if there
Hi Ocke,
- "Ocke Janssen" a écrit :
> I just have to set the issue to wontfix. :-(
> The problem seems to be the database. Even with odbctest I get the
> same
> results => error and I tested a StarOffice 9.2 which is equal to OOo
> 3.2, same error as in OOo 3.2.1 and 3.3.
As I mentioned
Moin,
I just have to set the issue to wontfix. :-(
The problem seems to be the database. Even with odbctest I get the same
results => error and I tested a StarOffice 9.2 which is equal to OOo
3.2, same error as in OOo 3.2.1 and 3.3.
Did anyone did an upgrade to a newer MySQL version before th
Alex ,
As always, we gave good reasons to use a technique, so let hope the CAST
problem will be fixed soon =-)
Fernand,
Well I also use EXTRACT(), but have found that I still have to CAST the type.
If I just use the DATE/TIME functions on their own, the results are
inconsistent across the mo
Fernand,
Well I also use EXTRACT(), but have found that I still have to CAST the type.
If I just use the DATE/TIME functions on their own, the results are
inconsistent across the months, especially when adding or subtracting. I
haven't kept any of my old queries that did direct application of d
Alex ,
its also a fact that there are (better) alternatives for cast Date()
convert() or even left() and right()
Hi Fernand,
Done, but whether it will make any difference ? Its not a blocker because it
doesn't cause a crash, or lose your data, but it is surely a regression from
3.2.
Alex
Hi Fernand,
Done, but whether it will make any difference ? Its not a blocker because it
doesn't cause a crash, or lose your data, but it is surely a regression from
3.2.
Alex
- "Fernand Vanrie" a écrit :
> Alexander ,
>
> It sould be good to send this message also to relea...@openof
Alexander ,
It sould be good to send this message also to relea...@openoffice.org
there they decide over live and dead :-)
greetz
Fernand
Hi all,
Le 08/12/10 13:38, Reizinger Zoltán a écrit :
Hi Fernand,
It feels to me as I touched in some days ago, and find it, as a known
issue with cas
18 matches
Mail list logo