Thanks Alan, let me know how I can help.
By the way is there currently support for multiple values for an
attribute? For example I would expect this query to store two values
for Attribute2 (notice it is specified twice):
<cfquery name="qry1" datasource="SimpleDB" dbtype="amazon">
INSERT INTO MyDomain(ItemName, Attribute1, Attribute2, Attribute2)
VALUES ('PrimaryKey1', 'Value1', 'Value2', 'Value3')
</cfquery>
The resulting dump shows Attribute2 only contains the last value
specified, Value3, rather than both Value2 and Value3. Is there
another way to store multiple values or is that feature on the drawing
board?
Cheers,
Baz
On Tue, Apr 28, 2009 at 1:39 PM, Baz <[email protected]> wrote:
> I am excited about the SimpleDB integration that you guys implemented.
> The interface is very clean and intuitive. I was wondering how current
> it is with new amazon developments, and how aggressively you plan to
> monitor and follow changes. For example these are some recent
> enhancements:
>
> MAR-24-2009: BatchPutAttributes - Amazon SimpleDB now provides
> BatchPutAttributes, a new operation that enables you to perform
> multiple PutAttribute operations in a single call.For more
> information, see BatchPutAttributes.
> FEB-18-2009: count(*) - Amazon SimpleDB now allows you to count the
> number of items in a result set instead of returning the set. For more
> information, see Count.
> DEC-17-2008: Select - Amazon SimpleDB now provides Select, a new query
> function that is similar to the standard SQL SELECT statement. For
> more information, see Using Select.
> DEC-17-2008: Signature version 2 - Amazon SimpleDB now supports
> signature version 2, which is a more secure method for signing REST
> requests. For more information, see Authenticating REST Requests.
>
> Are these implemented by chance?
>
> A really good one is the SELECT. Queries can now look pretty much like
> SQL and we can do away with oddities like the square brackets: select
> * from mydomain where Year > '1975' and Year < '2008'
> -
> http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/UsingSelect.html
>
> An important one is the signature change to version 2. The version 1
> signature is insecure and deprecated and will not be function as of
> SEP-2009
> - http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1928
> -
> http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/index.html?REST_RESTAuth.html
>
> Of course the ability to count records without returning them is great
> too, as well as sorting (not listed):
> - http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/
> (select count(*) from mydomain where Title = 'The Right Stuff')
> - http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/
> (select * from mydomain order by Year asc)
>
> Thanks for your time and efforts!
>
> Baz
>
--~--~---------~--~----~------------~-------~--~----~
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 !!
-~----------~----~----~----~------~----~------~--~---
