Hello All,
I recently updated to CF MX7 and the following happened to my dates (months in this case): They were in Portuguese, and all of a sudden turned English :-) You can see it here: http://web3.cmvm.pt/sdi2004/fundos/carteiras/fim/_carteiras_fim.cfm <http://web3.cmvm.pt/sdi2004/fundos/carteiras/fim/_carteiras_fim.cfm> One of the queries I use is: select rtrim(mes,' ')||' '||ano mes_ano from (select to_char(to_date('30/09/2005','DD/MM/RRRR'),'Month') mes, to_char(to_date('30/09/2005','DD/MM/RRRR'),'RRRR' ) ano from dual) It is ok if I run it on the DB server (by sqlplus or toad). When I see it on the site, it isn't. I noticed that the data sources are no longer managed by OBBC. Can this be it? Is there a place I can fine tune the DATASOURCE connection so it uses the correct NLS. Am I going all wrong about this? Thank you so much in advance, Pedro ............................................................................................. Pedro Mendes Webmaster CMVM - Comissão do Mercado de Valores Mobiliários mailto:[EMAIL PROTECTED] <BLOCKED::mailto:[EMAIL PROTECTED]> http://www.cmvm.pt <BLOCKED::http://www.cmvm.pt/> -------------------------------------------- AVISO DE CONFIDENCIALIDADE: Esta mensagem e quaisquer ficheiros enviados em anexo são confidenciais e destinam-se exclusivamente a informação ou uso da pessoa ou entidade a que são dirigidos. Na eventualidade de não ser o destinatário da mensagem, de não ser responsável pelo encaminhamento da mensagem ao destinatário ou de ter recebido esta mensagem por erro ou engano, a CMVM informa-o que qualquer utilização, distribuição, encaminhamento ou outra forma de revelação a outrem, impressão ou cópia da mesma são expressamente proibidos, devendo ser destruída de imediato e informado o remetente. LIMITAÇÃO DE RESPONSABILIDADE: Quaisquer opiniões expressas nesta mensagem vinculam apenas a pessoa que a emitiu, excepto quando o contrário resulte da própria mensagem e quando o destinatário seja autorizado a atribuí-las à CMVM. Não obstante os procedimentos de segurança a que a CMVM submete todas as mensagens de correio electrónico, a integridade do conteúdo das mesmas não pode ser garantido pelo remetente que não se responsabiliza pela respectiva intercepção, corrupção, perda, destruição, atraso ou pelos vírus que possa conter. -------------------------------------------- CONFIDENTIALITY NOTICE: This message and any files sent as attachments are confidential and destined exclusively for the information or use by the person or entity to which it is addressed. In the event of not being the addressee of the message, nor responsible for the delivery of the message to the addressee or receive this message in error or mistake, the CMVM hereby informs you that any use, distribution, delivery or another form of disclosure to others, print or copy of the same is expressly forbidden, and that you should immediately destroy this and duly inform the sender. LIMITATION OF LIABILITY: Any opinions expressed in this message belongs only to the person who issued it, except when the contrary is reflected on the actual message and when the addressee is authorized to attribute same to the CMVM. Notwithstanding the security procedures that the CMVM submits all e-mail messages, the integrity of the content of same may not be guaranteed by the sender and, in addition, the sender may not be held responsible for the respective interception, corruption, loss, destruction, delay or virus that it may contain. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220816 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
