001/** 002 * 003 * Copyright (c) 2014, the Railo Company Ltd. All rights reserved. 004 * 005 * This library is free software; you can redistribute it and/or 006 * modify it under the terms of the GNU Lesser General Public 007 * License as published by the Free Software Foundation; either 008 * version 2.1 of the License, or (at your option) any later version. 009 * 010 * This library is distributed in the hope that it will be useful, 011 * but WITHOUT ANY WARRANTY; without even the implied warranty of 012 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 013 * Lesser General Public License for more details. 014 * 015 * You should have received a copy of the GNU Lesser General Public 016 * License along with this library. If not, see <http://www.gnu.org/licenses/>. 017 * 018 **/ 019/** 020 * Implements the CFML Function querysetcell 021 */ 022package lucee.runtime.functions.query; 023 024import lucee.runtime.PageContext; 025import lucee.runtime.exp.PageException; 026import lucee.runtime.functions.BIF; 027import lucee.runtime.op.Caster; 028import lucee.runtime.type.KeyImpl; 029import lucee.runtime.type.Query; 030 031public final class QuerySetCell extends BIF { 032 033 private static final long serialVersionUID = -5234853923691806118L; 034 035 public static boolean call(PageContext pc , Query query, String columnName, Object value) throws PageException { 036 return call(pc,query,columnName,value,query.getRecordcount()); 037 } 038 public static boolean call(PageContext pc , Query query, String columnName, Object value, double rowNumber) throws PageException { 039 if(rowNumber==-9999) rowNumber=query.getRecordcount();// used for named arguments 040 query.setAt(KeyImpl.init(columnName),(int)rowNumber,value); 041 return true; 042 } 043 044 @Override 045 public Object invoke(PageContext pc, Object[] args) throws PageException { 046 if(args.length==3)return call(pc,Caster.toQuery(args[0]),Caster.toString(args[1]),args[2]); 047 return call(pc,Caster.toQuery(args[0]),Caster.toString(args[1]),args[2],Caster.toDoubleValue(args[3])); 048 } 049}