Aha. I can now update my item attribute value by calling DeleteSDBAttribute and SetSDBAttribute functions. Thank you for info.
On Dec 4, 8:19 pm, Alan Williamson <[EMAIL PROTECTED]> wrote: > Alim, > > Yes, I did toy with how to reproduce that functionality within the > INSERT statement, but felt the very nature of INSERT suggests 'new' content. > > That said, there is other ways to operate with your SimpleDB account > within OpenBD. We have a whole set of functions that let you pretty > much do everything, if CFQUERY isn't working out for you. > > You can see them here: > http://wiki.openbluedragon.org/wiki/index.php/Category:Amazon > > I'll be adding to this list very soon, once SimpleDB releases publicly > their new SQL-like query language. > > a > > -- > Alan Williamson > Registrationless email/sms reminders: http://yourli.st/ > blog: http://alan.blog-city.com/ > > On 04/12/2008 11:13, Alim wrote: > > > HI Alan, > > I have quick checked cfquery tag with simpleDB once again using new > > openbd release v1.0. It works fine with initial insertion query. But > > when I try to update an existing item using insert statement giving an > > existing ItemName and the attribute I want to update, it creates > > another instance of the same attribute with new value. It is not > > updating the old value of the same attribute. As you might know in > > order to update attribute value with amazon web service we also need > > to pass [attribute.x.replace/true] pair as well. Has it been > > implemented with cfquery tag? Is there other way to work with update > > query with simpleDB using cfquery? --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
