Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- component {
- remote function getArt(string term) {
- var q = new com.adobe.coldfusion.query();
- q.setDatasource("cfartgallery");
- q.setSQL("select artname from art where lower(artname) like :search");
- q.addParam(name="search",value="#lcase(arguments.term)#%",cfsqltype="cf_sql_varchar");
- return q.execute().getResult();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement