A natural place to implement multiple values is in cfqueryparam's *list*
attribute. If it is true, it saves each value on its own. Whereas if it is
false (default), the list is saved as one really long value.
<cfquery name="InsertQ" datasource="SimpleDB" dbtype="amazon">
INSERT INTO Track (ItemName, MultiValueAttribute, OneLongString)
VALUES (
<cfqueryparam value="id1" />,
<cfqueryparam value="MultiValue1,MultiValue2,MultiValue3" list="true" />
<cfqueryparam value="MultiValue1,MultiValue2,MultiValue3" />)
</cfquery>
Baz
On Tue, Apr 28, 2009 at 3:13 PM, Baz <[email protected]> wrote:
> 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 !!
-~----------~----~----~----~------~----~------~--~---
