Hi All,
I'm having problems whereby integer's are sometimes getting written to
google datastore as 1 and sometimes as 1.0.
It seems to happen when I read a value from the datastore and then
write it back in again.
If i do a select from tblTestUser I get both columns showing as 1.
However in the admin console the second column shows as 1.0.
Anyone have any insight?
Thanks
Code:
<!--- 1) Insert new user, note userid is an integer --->
<cfscript>
stuDbUsers = structNew();
stuDbUsers.intUserID = 1;
stuDbUsers.strUsername = "animal";
googleWrite(stuDbUsers, "tblTestUser");
</cfscript>
<!--- 2) Get all users from datastore --->
<cfquery name="arrUsers" dbtype="google">
select from tblTestUser
</cfquery>
<cfdump var="#arrUsers#"><br /><br /><br />
<!--- 3) Insert new user, based on data we got from query --->
<cfscript>
stuDbUsers = structNew();
stuDbUsers.intUserID = arrUsers[1].intUserID;
stuDbUsers.strUsername = "kermit";
googleWrite(stuDbUsers, "tblTestUser");
</cfscript>
<!--- 4) Get all users with ID 1 (integer), should return us 2 users
--->
<cfquery name="arrUsers2" dbtype="google">
select from tblTestUser
where intUserID == 1
</cfquery>
<!--- I get just one row returned????? --->
<cfdump var="#arrUsers2#">
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
