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? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/openbd?hl=en -~----------~----~----~----~------~----~------~--~---
