Difference between revisions of "XMLCOUNT()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return the number of records from an XML file | Function to return the number of records from an XML file | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|UPDATE]], [[XMLCREATEDTD()]], [[XMLFIRST()]], [[XMLNEXT()]], [[XMLVALIDATE()]] | + | [[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|UPDATE]], [[XML]], [[XML_DECODE()]], [[XML_ENCODE()]], [[XML_GATHER()]], [[XML_SCATTER()]], [[XMLCREATEDTD()]], [[XMLFIRST()]], [[XMLNEXT()]], [[XMLVALIDATE()]] |
| Line 39: | Line 35: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:XML]] | [[Category:XML]] | ||
[[Category:XML Functions]] | [[Category:XML Functions]] | ||
Latest revision as of 14:17, 19 November 2009
Purpose
Function to return the number of records from an XML file
Syntax
XMLCOUNT(<XML filename>)
See Also
COPY, FETCH, SELECT, SET XMLFORMAT, UPDATE, XML, XML_DECODE(), XML_ENCODE(), XML_GATHER(), XML_SCATTER(), XMLCREATEDTD(), XMLFIRST(), XMLNEXT(), XMLVALIDATE()
Description
The XMLCOUNT() function will return the number of records from an XML file.
| Parameters | Required | Default | Description |
|---|---|---|---|
| <XML filename> | Yes | None | The name of the XML file to validate. |
If the XML file contains no records, then a value of zero will be returned.
Example
select company, street, town, state, zip from sales save as xml sales ? xmlcount("sales.xml") 25
Products
Recital, Recital Server
