001 /** 002 * Implements the CFML Function valuelist 003 */ 004 package railo.runtime.functions.query; 005 006 import railo.runtime.PageContext; 007 import railo.runtime.PageContextImpl; 008 import railo.runtime.exp.ExpressionException; 009 import railo.runtime.exp.PageException; 010 import railo.runtime.ext.function.Function; 011 import railo.runtime.op.Caster; 012 import railo.runtime.type.Query; 013 import railo.runtime.type.QueryColumn; 014 import railo.runtime.type.ref.VariableReference; 015 import railo.runtime.type.scope.Scope; 016 017 public class ValueList implements Function { 018 019 private static final long serialVersionUID = -6503473251723048160L; 020 021 022 public static String call(PageContext pc , String strQueryColumn) throws PageException { 023 return call(pc,toColumn(pc,strQueryColumn),","); 024 } 025 public static String call(PageContext pc , String strQueryColumn, String delimiter) throws PageException { 026 return call(pc,toColumn(pc,strQueryColumn),delimiter); 027 } 028 public static String call(PageContext pc , QueryColumn column) throws PageException { 029 return call(pc,column,","); 030 } 031 public static String call(PageContext pc , QueryColumn column, String delimiter) throws PageException { 032 StringBuilder sb=new StringBuilder(); 033 int size=column.size(); 034 for(int i=1;i<=size;i++) { 035 if(i>1)sb.append(delimiter); 036 sb.append(Caster.toString(column.get(i,null))); 037 } 038 return sb.toString(); 039 } 040 041 protected static QueryColumn toColumn(PageContext pc,String strQueryColumn) throws PageException { 042 //if(strQueryColumn.indexOf('.')<1) 043 // throw new ExpressionException("invalid query column definition ["+strQueryColumn+"]"); 044 VariableReference ref = ((PageContextImpl)pc).getVariableReference(strQueryColumn); 045 if(ref.getParent() instanceof Scope) 046 throw new ExpressionException("invalid query column definition ["+strQueryColumn+"]"); 047 048 049 Query query=Caster.toQuery(ref.getParent()); 050 return query.getColumn(ref.getKey()); 051 } 052 }