Hi Alan, It'd be great if you could register these issues in our bug database so we can give them some attention if need be.
Thanks Andy Alan Holden wrote: > Not sure if this will help, but I have found - with my PostgreSQL > database at least - that some db columns will throw a type conversion > error within OpenBD CFQUERY tags. > > By switching from SELECT * to a select statement that lists individual > columns instead; I've been able to swap individual columns in and out > until I find the offending data element. > > In many cases, I can fix the problem by converting the output with a SQL > function before the JDBC driver or OpenBD even get the result. > > Plus, many DBAs have told me that SELECT * is just a bad idea in general. > > Al > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
