Hi, After doing some RnD finally I have got my query running ok with below change into where clause:
where ['emailID'='#emailID#'] intersection ['password'='#password#'] In amazon simpleDB the basic construct of a query expression is called a predicate. Each predicate is indicated by square brackets surrounding a set of comparison defined against a single attribute. In short a single predicate should have only one attribute inside square bracket. Therefore my problem was using two attributes (emailID and password) inside a singe predicate. So when I have separated them using intersection operator it works fine. This is a wonderful work from openBD providing support for simpleDB from cfquery tag. I will keep you inform other issues when it pops up in our project. Thanking you. On Nov 24, 3:16 am, Alan Williamson <[EMAIL PROTECTED]> wrote: > yes it does. > > On 23/11/2008 17:40, Tom Chiverton wrote: > > > 2008/11/20 Alim<[EMAIL PROTECTED]>: > >> where ['emailID' = '#emailID#' AND 'password' = '#password#'] > > > Does SimpleDB require square brackets or something ? Normally that'd > > be invalid... --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
