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 Brian Holmes wrote: > Hi Alan, > > Here's two quieries. The first one works, the second one does not. I'm > using the data.dsn to in my AmazonSimpleDB call. I've verified I can > connect to simpledb. I guess, maybe what i'm wondering is does the > query just bring back items or is it an items with attributes call to > simpledb? I think this is a misunderstanding on my part about how to > write the select statement. > > <cfset data.dsn = "sbd" /> > > <cfquery name="qry1" datasource="#data.dsn#" dbtype="amazon" > > select ItemName * from ItemAttribute where ItemName = '3D2D97C8- > C8FB-401D-9163342E415E487E' and domain ='testtable' > </cfquery> > > <cfquery name="qry2" datasource="#data.dsn#" dbtype="amazon" > > select * from testtable > </cfquery> > > > > > On Jan 18, 12:34 am, Alan Williamson <[email protected]> wrote: > >> Brian, i would need to see your complete set of CFML statements here. >> >> Can you throw me the SELECT statement you are doing? >> >> Brian Holmes wrote: >> >>> It seems I can do everything with the Amazon Extensions except use >>> CFQuery to select data with it. No matter what I do I get the >>> following error message: >>> >>> General SQL Error >>> Unrecognized error code: AmazonError: null >>> >>> What would cause a null error? >>> I have dbtype="amazon" and the have verified the datasource is correct >>> ( I can insert data with CFQuery ). >>> >>> Did something change with openbd or amazon web services that might >>> cause this? I've inserted 11 rows into my table and can see this with >>> the scratchpad and the firefox plugin. I know there's eventual >>> consistency but I've been trying this for a couple hours now. I've >>> also verified that the domain/table is spelled exactly correct. >>> >>> I'm really at a loss at this point. Any ideas are appreciated. >>> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
