Hi Al, I tried having a list of columns. It didn't work. I'm trying to connect to the Amazon Web Services SimpleDB with the CFQUERY tag. I can connect to SimpleDB via CFHTTP just fine, just thought it'd be nice to use CFQUERY when getting data, but i didn't seem to work it out.
Brian.. On Jan 18, 4:25 pm, Alan Holden <[email protected]> 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 > > 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 !! -~----------~----~----~----~------~----~------~--~---
