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 !!
-~----------~----~----~----~------~----~------~--~---
