Good morning everyone. I am Italian and if I make some English mistakes I hope you can understand me. I’m studiyng Computer Engineering at University of Bologna. I hope I’ve posted this request in the right forum. I’m writing thesis in Web technologies and my university professor who is acting as my thesis supervisor asked me to include a chapter on Lucee’s model of execution. I’m looking for material about it but I can’t find any. Can someone help me finding material? Any help is welcome.
@merlino94 Can you clarify, are you looking for information on CMS libraries specifically (WordPress is an example of a PHP CMS) or are you just asking general questions about how Lucee works as a JVM language. I’m wondering about the phrase “Lucee’s model of execution”.
To be clear, CFML is not a Content Management System (CMS) but a JVM scripting language originally designed for creating web applications. There are a number of CMS’s that have been built on top of CFML by different people. Several of which, Guust listed above.
My professor asked me to write an example of a select query and to explain how lucee convert those istructions into servlet code. I’m trying to retrieve the source code but I’m having trouble finding them.
Thanks a lot. That’s a part of what I’m searching. Can I ask you if you know where’s the code about this example?
queryService = new query();
queryService.setDatasource("datasource");
queryService.setName("GetParks");
queryService.addParam(name="state", value="MD", cfsqltype="cf_sql_varchar");
queryService.addParam(value="National Capital Region", cfsqltype="cf_sql_varchar");
result = queryService.execute(sql="SELECT ParkName, Region, State, FROM Parks WHERE State = :state AND Region = ? ORDER BY ParkName, State");
GetParks = result.getResult();
Basically i’m looking for the source code for a cfscript query example, not with a query tag
I’m trying to find in the repository but without success.
That is not a good example. That is using a component, and it’s super over the top, re-written it would be:
<cfscript>
var GetParks = QueryExecute(
sql:"SELECT ParkName, Region, State, FROM Parks WHERE State = :state AND Region = :region ORDER BY ParkName, State",
params:{
"state":{
"type": "varchar",
"value": "MD"
},
"region":{
"type":"varchar",
"value":"National Capital Region"
}
},]
options:{
"datasource": "datasource"
}
);
</cfscript>
I don’t know how to thank you, I’m really happy now I think I’m ok, I have 2 weeks and a half to send the thesis, and next month (December 18th) I’ll graduate