3-2:org.railo.cfml.Query

last edited byacampolonghi on 25-Oct-2010

Page History

Execute queries from cfscript with the following syntax:

var q = new Query();
q.setSql("Select * from team where dom = :domain and firstname = ?");
q.addParam(name="domain",value="com",cfsqltype="cf_sql_varchar");
q.addParam(value="gert",cfsqltype="cf_sql_varchar");				
var qres = q.execute().getResult();

getResult() and getPrefix()

Positional and Named parameters

Query of Queries

Download in other Formats:
Markup | PDF | HTML | Word