AndroidToday, I've recently developed one simple project with Coldfusion in Google App Engine. To manipulate data in Google App Engine is complicated because we can use only GQL (Google Query Language) instead of SQL. Likewise, displaying data in Google App Engine with OpenBD is quite different with Adobe Coldfusion. That's why, it's too hard to handle to everything. Ok, I'll show how to create Table in Google App Engine and retrieve data either.
Create Table and Insert Data
1<cfscript>
2 car = StructNew();
3 car["Class"] = "Sedan-Midsize";
4 car["Make"] = "Audi";
5 car["Model"] = "A6";
6 keyString = googleWrite(car, "MyCarLot");
7</cfscript>
2 car = StructNew();
3 car["Class"] = "Sedan-Midsize";
4 car["Make"] = "Audi";
5 car["Model"] = "A6";
6 keyString = googleWrite(car, "MyCarLot");
7</cfscript>
Ref : http://wiki.openbluedragon.org/wiki/index.php/GoogleAppEngine:Datastore
Display data
1<cfquery dbtype="google" name="QryCar">
2 select from MyCarLot
3</cfquery>
4
5<cfloop from="1" to="#ArrayLen(QryCar)#" index="i">
6 <cfoutput> #getAllTags[i].Class# </cfoutput>
7</cfloop>
2 select from MyCarLot
3</cfquery>
4
5<cfloop from="1" to="#ArrayLen(QryCar)#" index="i">
6 <cfoutput> #getAllTags[i].Class# </cfoutput>
7</cfloop>
Top of Page