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 !!
-~----------~----~----~----~------~----~------~--~---
