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    }