Array Erki Esken 07-03-2002 07-03-2002 arrayAppend2D Minh Lee Goon 03-21-2006 03-21-2006 ArrayAppendUnique ArrayAppendUnique()! Correct usage: ArrayAppendUnique(Array, Value) -- Appends Value to the array if Value does not already exist"); return 0; } if (NOT ListFind(Arraytolist(a1), val)) { arrayAppend(a1, val); } return a1; }]]> Craig Fisher 10-29-2001 10-29-2001 arrayCollectionToQuery Adam Tuttle 03-03-2010 03-03-2010 arrayCompact M Gillespie for HOUCFUG 03-02-2007 03-02-2007 arrayCompare Ja Carter 09-23-2004 09-23-2004 ArrayConcat ArrayConcat()! Correct usage: ArrayConcat(Array1, Array2) -- Concatenates Array2 to the end of Array1"); return 0; } for (i=1;i LTE ArrayLen(a2);i=i+1) { ArrayAppend(a1, Duplicate(a2[i])); } return a1; }]]> Craig Fisher 09-13-2001 09-13-2001 ArrayContains Sudhir Duddella 03-31-2003 03-31-2003 ArrayContainsNoCase Sudhir Duddella 03-31-2003 03-31-2003 ArrayDefinedAt Raymond Camden 10-24-2003 10-24-2003 arrayDeleteArray Jason Rushton 04-11-2008 04-11-2008 ArrayDeleteAtList Giampaolo Bellavite 01-21-2005 01-21-2005 arrayDiff Greg Nettles 03-13-2007 03-13-2007 arrayExcludeNumeric ]]> Marcos Placona 07-06-2006 07-06-2006 arrayExcludeString ]]> Marcos Placona 07-11-2006 07-11-2006 ArrayFilter Raymond Camden 03-31-2003 03-31-2003 arrayFind ]]> Larry C. Lyons 04-30-2008 04-30-2008 ArrayFindByDimension var ii = 1; //loop through the array, looking for the value for(; ii LTE arrayLen(arguments.arrayToSearch); ii = ii + 1){ //if this is the value, return the index if(NOT compareNoCase(arguments.arrayToSearch[ii][arguments.dimensionToSearch], arguments.valueToFind)) return ii; } //if we've gotten this far, it means the value was not found, so return 0 return 0; ]]> Grant Szabo 09-23-2004 09-23-2004 ArrayFindNoCase Nathan Dintenfass 09-06-2002 09-06-2002 arrayFindSorted Kenneth Fricklas 09-30-2005 09-30-2005 arrayGroupsOf ]]> Marcos Placona 02-04-2010 02-04-2010 ArrayInsertArrayAt ArrayInsertArrayAt()! Correct usage: ArrayInsertArrayAt(Array1, Array2, position) -- Inserts Array2 at position in Array2"); return 0; } pos=int(pos); len1=ArrayLen(a1); len2=ArrayLen(a2); aNew=Duplicate(a1); if (pos IS NOT Len1 + 1) { for (i=0; i LT len2; i=i+1) ArrayInsertAt(aNew, pos + i, Duplicate(a2[i+1])); } else { for (i=1;i LTE len2;i=i+1) ArrayAppend(aNew, Duplicate(a2[i])); } return aNew; }]]> Craig Fisher 09-13-2001 09-13-2001 ArrayListCompareNoCase Steve Robison, Jr 03-28-2005 03-28-2005 arrayOfObjectsToQuery Don Quist 06-11-2009 06-11-2009 arrayOfStructsFind Nath Arduini 06-11-2009 06-11-2009 ArrayOfStructsSort Nathan Dintenfass 12-10-2001 12-10-2001 ArrayOfStructsToList jeff tapper 10-20-2003 10-20-2003 ArrayOfStructsToStructOfArrays Nathan Strutz 09-21-2004 09-21-2004 arrayOfStructsToStructsOfStructs var stStructOfStructs = structNew(); var i = 0; // loop over array for(i=1;i lte arrayLen(arguments.array);i=i+1){ stStructOfStructs[arguments.array[i][arguments.key]] = arguments.array[i]; } return stStructOfStructs; ]]> Tayo Akinmade 06-11-2009 06-11-2009 ArrayOfStructuresToQuery David Crawford 03-19-2003 03-19-2003 ArrayReverse Raymond Simmons 10-09-2001 10-09-2001 ArrayShuffle ArrayShuffle()! Correct usage: ArrayShuffle(Array) - Shuffles the values in one dimensional Array"); return 0; } if (ArrayLen(ar) eq 0) { return ar1; } for (i=1; i lte len; i=i+1) { n = RandRange(1,ArrayLen(ar)); ArrayAppend(ar1,ar[n]); ArrayDeleteAt(ar,n); } return ar1; }]]> Ivan Latunov 10-09-2001 10-09-2001 arraySlice Darrell Maples 07-13-2005 07-13-2005 arraySlice2 ]]> G.Arlington 06-11-2009 06-11-2009 ArraySort2D Robert West 10-08-2002 10-08-2002 Assert Dean Chalk 09-23-2004 09-23-2004 booleanize Craig M. Rosenblum 07-03-2006 07-03-2006 cfquery Joe Nicora 09-21-2004 09-21-2004 clearStructureNested ]]> Qasim Rasheed 01-28-2005 01-28-2005 ColumnLoop Shawn Seley 09-12-2003 09-12-2003 columnTotal Scott Barber 05-13-2003 05-13-2003 component Dan G. Switzer, II 05-13-2003 05-13-2003 convertDotNetDataset ]]> Anthony Petruzzi 05-17-2007 05-17-2007 CounterMinusMinus Stephan Scheele 04-19-2002 04-19-2002 CounterPlusPlus Stephan Scheele 04-17-2002 04-17-2002 CSVFormat Jeff Howden 08-26-2008 08-26-2008 CSVToQuery Tony Brandner 09-30-2005 09-30-2005 DeepStructCount Galen Smallen 08-23-2002 08-23-2002 DumpVar #chr(10)#"; if(isSimpleValue(varToProcess)){ if(isWDDX(varToProcess)){ StartString = "#chr(10)##chr(10)#"; return StartString & "#chr(10)##chr(10)##chr(10)#" & EndString; }else{ return varToProcess; } }else if(isArray(varToProcess)){ StartString = "#chr(10)#

WDDX currently not displayable

#chr(10)#"; ObjSize = ArrayLen(varToProcess); for(LoopCount = 1;LoopCount LTE ObjSize;LoopCount = LoopCount + 1){ StartString = StartString & "#chr(10)##chr(10)##chr(10)#"; } return StartString & EndString; }else if(isStruct(varToProcess)){ StartString = "#chr(10)#

#LoopCount#

#dumpVar(varToProcess[LoopCount])#

#chr(10)#"; for(key in varToProcess){ StartString = StartString & "#chr(10)##chr(10)##chr(10)##chr(10)#"; } return StartString & EndString; }else if(isQuery(varToProcess)){ StartString = "#chr(10)#

#key#

#dumpVar(varToProcess[key])#

#chr(10)#"; ObjSize = varToProcess.recordCount; Keys = varToProcess.columnList; numOfColumns = ListLen(Keys); StartString = StartString & "#chr(10)#"; for(count2 = 1;count2 LTE numOfColumns;count2 = count2 + 1){ StartString = StartString & "#chr(10)#"; } StartString = StartString & "#chr(10)#"; for(LoopCount = 1;LoopCount LTE ObjSize;LoopCount = LoopCount + 1){ StartString = StartString & "#chr(10)#"; for(count2 = 1;count2 LTE numOfColumns;count2 = count2 + 1){ StartString = StartString & "#chr(10)#"; } StartString = StartString & "#chr(10)#"; } return StartString & EndString; }else{ return " "; } }]]> Chris Benson 04-23-2002 04-23-2002 DynamicValueList Raymond Camden 08-14-2002 08-14-2002 FirstInFirstOut Adrian Lynch 05-13-2003 05-13-2003 fixedWidthToQuery ]]> Umer Farooq 12-20-2007 12-20-2007 flattenStruct ]]> Tom de Manincor 08-26-2008 08-26-2008 Form2QS Billy Cravens 06-26-2002 06-26-2002 Get John Bartlett 11-15-2002 11-15-2002 getComponentProps Robby Lansaw 08-18-2004 08-18-2004 getQueryMetadata ]]> Marc Esher 05-30-2010 05-30-2010 GetXmlAttribute ]]> Kreig Zimmerman 12-23-2002 12-23-2002 GuidToString Samuel Neff 09-06-2002 09-06-2002 isBit Mike Tangorre 02-14-2006 02-14-2006 isCachedQuery select cachedquery from events WHERE type='SqlQuery' and name='#arguments.queryname#' ]]> Qasim Rasheed 02-11-2005 02-11-2005 IsCFC Nathan Dintenfass 10-16-2002 10-16-2002 IsCFCType Nathan Dintenfass 12-23-2002 12-23-2002 isDefinedValue Joseph Flanigan 08-18-2003 08-18-2003 isDefinedValueMX Joseph Flanigan 10-20-2003 10-20-2003 IsEmpty Fabio Serra 07-10-2003 07-10-2003 IsNull Rob Brooks-Bilson 05-01-2002 05-01-2002 IsSafeArray Raymond Camden 04-29-2002 04-29-2002 IsXML ]]> Ben Forta 08-28-2003 08-28-2003 LenStruct Peter J. Farrell 10-05-2004 10-05-2004 listToQuery ]]> Russ Spivey 09-09-2009 09-09-2009 ListToStruct Rob Brooks-Bilson 04-01-2010 04-01-2010 ListToStructRepeatKeys Tony Brandner 08-03-2005 08-03-2005 maketree Qasim Rasheed 02-17-2005 02-17-2005 MinusMinusCounter Stephan Scheele 04-17-2002 04-17-2002 nullQuery John Bartlett 08-10-2007 08-10-2007 PlusPlusCounter Stephan Scheele 04-17-2002 04-17-2002 Query2Excel "; for (i=1;i lte ListLen(Headers);i=i+1){ header=listGetAt(Headers,i); headerLen=Len(header)*10; HTMLData = HTMLData & ""; } HTMLData = HTMLData & ""; for (j=1;j lte query.recordcount;j=j+1){ if (j mod 2) { HTMLData = HTMLData & ""; } else { HTMLData = HTMLData & ""; } for (k=1;k lte ListLen(InputColumnList);k=k+1) { col=ListGetAt(InputColumnList,k); colValue=query[trim(col)][j]; colLength=Len(colValue)*10; if (NOT Len(colValue)) { colValue=" "; } if (isNumeric(colValue) and Len(colValue) gt 10) { colValue="'#colValue#"; } HTMLData = HTMLData & ""; } HTMLData = HTMLData & ""; } HTMLData = HTMLData & "

#listGetAt(Keys,count2)#
#varToProcess[listGetAt(Keys,count2)][loopCount]#
#header#
#colValue#

"; return HTMLData; }]]> Jesse Monson 02-23-2005 02-23-2005 queryAddColumnWithValue arraySet(arr,1,arguments.query.recordCount,arguments.value); queryAddColumn(arguments.query, arguments.column_name, arr); ]]> Gabriele Bernuzzi 12-13-2005 12-13-2005 queryBeanToQuery Alistair Davidson 05-20-2005 05-20-2005 queryColumns John Bartlett 03-17-2006 03-17-2006 queryColumnsToStruct Nathan Dintenfass 07-09-2003 07-09-2003 queryColumnToArray Peter J. Farrell 07-22-2005 07-22-2005 queryColumnTypes John Bartlett 04-11-2006 04-11-2006 queryCompare ]]> Qasim Rasheed 11-04-2005 11-04-2005 queryConcat Chris Dary 02-23-2006 02-23-2006 queryDeDupe Matthew Fusfield 12-19-2008 12-19-2008 QueryDeleteRows Raymond Camden 10-11-2001 10-11-2001 queryDiff Nathan Dintenfass 05-26-2003 05-26-2003 QueryGetCellByKey Shawn Seley 06-28-2002 06-28-2002 queryGetRow Tony Felice 02-14-2009 02-14-2009 queryMerge Alain Blais 07-21-2004 07-21-2004 QueryRandomRows Shawn Seley and John King 07-10-2002 07-10-2002 queryRemoveColumns SELECT #columnList# FROM theQuery ]]> Giampaolo Bellavite 03-01-2005 03-01-2005 QueryReverse David Whiterod 06-27-2002 06-27-2002 QueryRowFromKey Shawn Seley 06-28-2002 06-28-2002 queryRowToList Tim Sloan 08-06-2004 08-06-2004 QueryRowToStruct Nathan Dintenfass 12-11-2001 12-11-2001 QuerySetCellByKey Shawn Seley 06-28-2002 06-28-2002 querySetRow //by default, append new row to end of query if (val(arguments.rowNumber) lt 1) { QueryAddRow(arguments.query, 1); rowNumber = arguments.query.recordCount; } //set values for each column for (i = 1; i lte ListLen(arguments.columnList, arguments.delimiter); i = i + 1) { if (arguments.trimElements) { col = Trim(ListGetAt(arguments.columnList, i, arguments.delimiter)); value = Trim(ListGetAt(arguments.valuesList, i, arguments.delimiter)); } else { col = ListGetAt(arguments.columnList, i, arguments.delimiter); value = ListGetAt(arguments.valuesList, i, arguments.delimiter); } query[col][arguments.rowNumber] = value; } ]]> Ell Cord 10-18-2005 10-18-2005 QuerySim Bert Dawson 12-18-2007 12-18-2007 QuerySlice var FinalQuery = ""; var EndRow = StartRow + NumberOfRows; var counter = 1; var x = ""; var y = ""; if (arguments.ColumnList IS "") { arguments.ColumnList = theQuery.ColumnList; } FinalQuery = QueryNew(arguments.ColumnList); if(EndRow GT theQuery.recordcount) { EndRow = theQuery.recordcount+1; } QueryAddRow(FinalQuery,EndRow - StartRow); for(x = 1; x LTE theQuery.recordcount; x = x + 1){ if(x GTE StartRow AND x LT EndRow) { for(y = 1; y LTE ListLen(arguments.ColumnList); y = y + 1) { QuerySetCell(FinalQuery, ListGetAt(arguments.ColumnList, y), theQuery[ListGetAt(arguments.ColumnList, y)][x],counter); } counter = counter + 1; } } return FinalQuery; ]]> Kevin Bridges 05-23-2005 05-23-2005 QuerySort select * from query order by #column# #sortDir# ]]> Raymond Camden 10-15-2002 10-15-2002 QueryToArrayOfStructures Nathan Dintenfass 09-27-2001 09-27-2001 QueryToCsv adgnot sebastien 06-26-2002 06-26-2002 QueryToStructOfArrays Nathan Dintenfass 02-23-2002 02-23-2002 queryToStructOfStructsAutoRow Peter J. Farrell 09-23-2004 09-23-2004 QueryToStructOfStructures Shawn Seley 03-27-2002 03-27-2002 QueryToVars Nathan Dintenfass 03-11-2002 03-11-2002 QueryToXML Nathan Dintenfass 11-15-2002 11-15-2002 QueryTranspose ]]> Glenn Buteau 08-24-2005 08-24-2005 queryTreeSort ]]> Rick Osborne 03-28-2006 03-28-2006 quickSort2D Matthew Wear 03-28-2006 03-28-2006 randomWeightedSelection Chris Spencer 05-25-2006 05-25-2006 ReGroupStructureBy Casey Broich 05-26-2003 05-26-2003 RemoveEmptyStructureKeys Brian Rinaldi 04-19-2004 04-19-2004 REStructFindValue ]]> Nathan Mische 07-12-2009 07-12-2009 REStructFindValueNoCase ]]> Nathan Mische 07-12-2009 07-12-2009 RowsToColumns Nathan Dintenfass 03-10-2010 03-10-2010 saTOss Casey Broich 06-12-2003 06-12-2003 ScopeCoalesce Scott Jibben 02-17-2004 02-17-2004 shiftArray Richard Nugen 08-16-2005 08-16-2005 sortArrayOfStructures Martijn van der Woud 09-27-2008 09-27-2008 SQLBatcher var CleanedBatchCode = ReReplaceNoCase(BatchCode, "--.*?\r", "", "all");// clean sql comments var arBatchBlocks = ArrayNew(1); // index of each block and it's SQL string var separator = REFindNoCase("#arguments.sSep#\r",CleanedBatchCode,1,1); // looks for separators var pos = separator.pos[1]; // 0 or position of first separator var oldpos = 1; var Batch = 0; // count of separator blocks var Block = ""; // Code block of SQL var sSQL = ""; // string to be returned // make sure arguments have length if ( (Len(Trim(theDSN)) EQ 0) OR (Len(Trim(CleanedBatchCode)) EQ 0) ) { sSQL = "<<>> Invalid parameters"; return sSQL; // if there is an error stop batcher and return to caller } // if no separator blocks, just query on the one block if(not pos) arBatchBlocks[1] = CleanedBatchCode; // loop around the separator blocks to get the code block for each separator while(pos gt 0) { block = mid(CleanedBatchCode,oldpos,pos-oldpos); // only add a block if there are characters in it. if (ReFind("[[:alnum:]]",block,1,"False")) arrayAppend(arBatchBlocks,block); oldpos = pos + separator.len[1]; separator = REFindNoCase("#arguments.sSep#\r|$",CleanedBatchCode,oldpos+1,1); pos = separator.pos[1]; } #Chr(60)#cftransaction#Chr(62)##Chr(10)##Chr(10)# #Chr(60)#cfquery name="q#BATCH#" datasource="#Arguments.theDSN#"#Chr(62)##Chr(10)##Trim(PreserveSingleQuotes(Block))##Chr(10)##Chr(60)#/cfquery#Chr(62)##Chr(10)##Chr(10)# #Chr(60)#/cftransaction#Chr(62)# ]]> Joseph Flanigan 11-09-2006 11-09-2006 sqlXMLToCFXML "> ]]> Russel Brown 04-09-2007 04-09-2007 struct Erki Esken 08-22-2007 08-22-2007 structBlend Raymond Compton 10-30-2008 10-30-2008 structCompare Ja Carter 10-14-2005 10-14-2005 structGetKey Adam Tuttle 09-09-2008 09-09-2008 StructInvert InvertStruct()! Correct usage: InvertStruct(Structure) -- Returns a structure with the values and keys of Structure inverted when Structure is a structure of simple values."); return 0; } else { return stn; } }]]> Craig Fisher 11-13-2001 11-13-2001 structMerge ]]> Marcos Placona 03-02-2006 03-02-2006 StructOfArraysToQuery Casey Broich 03-27-2002 03-27-2002 StructOfArraysToStructOfStructs Casey Broich 08-02-2003 08-02-2003 StructOfListsToArrayOfStructs Casey Broich 08-02-2003 08-02-2003 StructOfStructuresToQuery Shawn Seley 06-28-2002 06-28-2002 StructRenameKey Erki Esken 06-26-2002 06-26-2002 structToList Greg Nettles 07-25-2006 07-25-2006 structToQueryRow ]]> Brian Rinaldi 04-25-2008 04-25-2008 StructToQueryString Erki Esken 12-17-2001 12-17-2001 structUpdateVals ]]> Jorge Loyo 12-22-2005 12-22-2005 structValueList Kit Brandner 11-06-2006 11-06-2006 structWrite Anthony Cooper 05-09-2003 05-09-2003 toXML var i = 0; var s = ""; var s1 = ""; s1 = arguments.element; if (right(s1, 1) eq "s") { s1 = left(s1, len(s1)-1); } s = s & "<#lcase(arguments.element)#>"; if (isArray(arguments.input)) { for (i = 1; i lte arrayLen(arguments.input); i = i + 1) { if (isSimpleValue(arguments.input[i])) { s = s & "<#lcase(s1)#>" & arguments.input[i] & ""; } else { s = s & toXML(arguments.input[i], s1); } } } else if (isStruct(arguments.input)) { for (i in arguments.input) { if (isSimpleValue(arguments.input[i])) { s = s & "<#lcase(i)#>" & arguments.input[i] & ""; } else { s = s & toXML(arguments.input[i], i); } } } else { s = s & XMLformat(arguments.input); } s = s & ""; ]]> Phil Arnold 09-09-2009 09-09-2009 TranslateMacromediaResourceFeed "); // LoopControl needs to be initialized var LoopControl = 1; // Initialize the Current Query Row var RowNumber = 1; // the number of the next token we are looking at var NextToken = 2; var ResourceStruct = StructNew(); // Initialize Return Query var ResultQuery = QueryNew("Type, Title, Author, URL, ProductName"); // loop until we are out of tokens while(Token is not "/macromedia_resources"){ switch(Left(Token,7)){ case "resourc":{ // if we are getting a resource token, we want to: // create a new blank structure // and define the structure's type // define new structure ResourceStruct = StructNew(); // add the type of entry to the structure StructInsert(ResourceStruct, "Type", GetToken(Token, 2, """")); // increment next token NextToken = NextToken + 1; break; } // end resource case case "/resour":{ // if we are getting a /resource token, we want to: // Create a new row in the query for each product // Assuming the structure isn't empty // copy existing structure into result array if (not StructIsEmpty(ResourceStruct)){ for (LoopControl = 1 ; LoopControl LTE ArrayLen(ResourceStruct.Products) ; LoopControl = LoopControl+1){ // add a new row to the query RowNumber = QueryAddRow(ResultQuery); // populate Query QuerySetCell(ResultQuery, "Type", ResourceStruct.Type, RowNumber); QuerySetCell(ResultQuery, "Title", ResourceStruct.Title, RowNumber); QuerySetCell(ResultQuery, "Author", ResourceStruct.Author, RowNumber); QuerySetCell(ResultQuery, "URL", ResourceStruct.URL, RowNumber); QuerySetCell(ResultQuery, "ProductName", ResourceStruct.Products[LoopControl], RowNumber); } } // increment next token NextToken = NextToken + 1; break; } // end resource case case "title":{ // if we are getting the title token, then we want to: // add the next token to our structure, because that will be our title text // increment the 'nexttoken' variable two increments past the end title token // add the title to the structure StructInsert(ResourceStruct, "Title", GetToken(S, NextToken+1, "<>")); // increment next token NextToken = NextToken + 2; break; } // end title case case "author":{ // if we are getting the author token, then we want to: // add the next token to our structure, because that will be our author text // increment the 'nexttoken' variable two increments past the end Author token // add the title to the structure StructInsert(ResourceStruct, "Author", GetToken(S, NextToken+1, "<>")); // increment next token NextToken = NextToken + 2; break; } // end author case case "url":{ // if we are getting the url token, then we want to: // add the next token to our structure, because that will be our url text // increment the 'nexttoken' variable two increments past the end url token // add the title to the structure StructInsert(ResourceStruct, "URL", GetToken(S, NextToken+1, "<>")); // increment next token NextToken = NextToken + 2; break; } // end url case case "product":{ // if the case is a product, we want to: // Pick out the name from the token and add it to our product array // increment the nexttoken variable once // if product array doesn't exist, create it if (not IsDefined("ResourceStruct.Products")){ StructInsert(ResourceStruct, "Products", ArrayNew(1)); } // add product name to array ArrayAppend(ResourceStruct.Products,GetToken(Token, 2, """")); // increment next token NextToken = NextToken + 1; break; } // end product case // case "/title","/author","/url" // these cases or anything else not defined, we just ignore, but we still wanna get the // next token default: { Token = GetToken(S,NextToken,"<>"); NextToken = NextToken + 1; break; } // end default case } // end switch Token = GetToken(S,NextToken,"<>"); } // end while return (ResultQuery); }]]> Jeffry Houser 08-12-2002 08-12-2002 trimQuery Giampaolo Bellavite 02-26-2004 02-26-2004 TrimStruct Mike Gillespie 07-11-2002 07-11-2002 TypeOf Jordan Clark 08-16-2002 08-16-2002 UniqueValueList Nick Giovanni 03-27-2007 03-27-2007 validateXMLFile //Call the SAX parser factory saxFactory = CreateObject("java","javax.xml.parsers.SAXParserFactory").newInstance(); //Creates a SAX parser and get the XML Reader xmlReader = saxFactory.newSAXParser().getXMLReader(); //Turn on validation xmlReader.setFeature("http://xml.org/sax/features/validation",true); //Create an error handler eHandler = CreateObject("java","org.apache.xml.utils.DefaultErrorHandler").init(); //Assign the error handler xmlReader.setErrorHandler(eHandler); ]]> Massimo Foti 02-18-2004 02-18-2004 validateXMLString //Use Java string reader to read the CFML variable jStringReader = CreateObject("java","java.io.StringReader").init(arguments.xmlString); //Turn the string into a SAX input source xmlInputSource = CreateObject("java","org.xml.sax.InputSource").init(jStringReader); //Call the SAX parser factory saxFactory = CreateObject("java","javax.xml.parsers.SAXParserFactory").newInstance(); //Creates a SAX parser and get the XML Reader xmlReader = saxFactory.newSAXParser().getXMLReader(); //Turn on validation xmlReader.setFeature("http://xml.org/sax/features/validation",true); //Add a system id if required if(IsDefined("arguments.baseUrl")){ xmlInputSource.setSystemId(arguments.baseUrl); } //Create an error handler eHandler = CreateObject("java","org.apache.xml.utils.DefaultErrorHandler").init(); //Assign the error handler xmlReader.setErrorHandler(eHandler); ]]> Massimo Foti 02-18-2004 02-18-2004 VarToScript Bert Dawson 09-18-2002 09-18-2002 vCal Chris Wigginton 04-10-2002 04-10-2002 xmlDoctoString ]]> Massimo Foti 08-02-2003 08-02-2003 xmlExtractList ]]> Samuel Neff 01-13-2004 01-13-2004 xmlMerge Nathan Dintenfass 10-15-2008 10-15-2008 xmlToJson true false " " ',substring-after($s,' '))"/> ',substring-after($s,' '))"/> ',substring-after($s,' '))"/> { "text": ,"attributes":{ : , } , : } { : [ ] } , result = arguments.xml; result = reReplace(result,'([\s\S\w\W]*)(<\?xml)','\2','all'); result = xmlTransform(trim(result),xsl); return result; ]]> Tony Felice 02-27-2009 02-27-2009 xsdValidate var parser = createObject("java","org.apache.xerces.parsers.SAXParser"); var err = structNew(); var k = ""; var success = true; var eHandler = createObject( "java", "org.apache.xml.utils.DefaultErrorHandler"); var apFeat = "http://apache.org/xml/features/"; var apProp = "http://apache.org/xml/properties/"; eHandler.init(); if (structKeyExists(arguments, "parseError")) { err = arguments.parseError; } try { parser.setErrorHandler(eHandler); parser.setFeature( "http://xml.org/sax/features/validation", true); parser.setFeature( apFeat & "validation/schema", true); parser.setFeature( apFeat & "validation/schema-full-checking", true); if (structKeyExists(arguments, "noNamespaceXsdUri") and arguments.noNamespaceXsdUri neq "") { parser.setProperty( apProp & "schema/external-noNamespaceSchemaLocation", arguments.noNamespaceXsdUri ); } if (structKeyExists(arguments, "namespaceXsdUri") and arguments.namespaceXsdUri neq "") { parser.setProperty( apProp & "schema/external-schemaLocation", arguments.namespaceXsdUri ); } parser.parse(arguments.xmlPath); } catch (Any ex) { structAppend(err, ex, true); success = false; } ]]> Samuel Neff 09-23-2004 09-23-2004 xslt var source = ""; var transformer = ""; var aParamKeys = ""; var pKey = ""; var xmlReader = ""; var xslReader = ""; var pLen = 0; var xmlWriter = ""; var xmlResult = ""; var pCounter = 0; var tFactory = createObject("java", "javax.xml.transform.TransformerFactory").newInstance(); //if xml use the StringReader - otherwise, just assume it is a file source. if(Find("<", arguments.xslSource) neq 0) { xslReader = createObject("java", "java.io.StringReader").init(arguments.xslSource); source = createObject("java", "javax.xml.transform.stream.StreamSource").init(xslReader); } else { source = createObject("java", "javax.xml.transform.stream.StreamSource").init("file:///#arguments.xslSource#"); } transformer = tFactory.newTransformer(source); //if xml use the StringReader - otherwise, just assume it is a file source. if(Find("<", arguments.xmlSource) neq 0) { xmlReader = createObject("java", "java.io.StringReader").init(arguments.xmlSource); source = createObject("java", "javax.xml.transform.stream.StreamSource").init(xmlReader); } else { source = createObject("java", "javax.xml.transform.stream.StreamSource").init("file:///#arguments.xmlSource#"); } //use a StringWriter to allow us to grab the String out after. xmlWriter = createObject("java", "java.io.StringWriter").init(); xmlResult = createObject("java", "javax.xml.transform.stream.StreamResult").init(xmlWriter); if(StructCount(arguments.stParameters) gt 0) { aParamKeys = structKeyArray(arguments.stParameters); pLen = ArrayLen(aParamKeys); for(pCounter = 1; pCounter LTE pLen; pCounter = pCounter + 1) { //set params pKey = aParamKeys[pCounter]; transformer.setParameter(pKey, arguments.stParameters[pKey]); } } transformer.transform(source, xmlResult); return xmlWriter.toString(); ]]> Mark Mandel 01-16-2006 01-16-2006 XSLTCF5 Joshua Miller 09-20-2004 09-20-2004