mmm that is indeed strange, your SimpleDB is correct. i am presently on the road (just finished a Cloud Boot Camp that we ran here in San Jose). When i get back to HQ, i'll delve deeper here.
Alim wrote: > Hi, > Setup : openBD J2EE war distribution with official plugin. > Datasource creation with Amazon simpleDB is successful. But while > getting an item it response with error. > > Used query: > <cfquery dbtype="amazon" datasource="#amazonDS#" name="qryUser"> > select ItemName,NextToken from member > where ['emailID' = '#emailID#' AND 'password' = '#password#'] > limit 1 > </cfquery> > > Error message: > Message General SQL Error > Detail Unrecognized error code: AmazonError: Client error : The > specified query expression syntax is not valid. > Extended Info select ItemName,NextToken from member where ['emailID' = > '[EMAIL PROTECTED]' AND 'password' = 'test'] limit 1 > > Any help! What is wrong with query expression? Thank you in advance. --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
