I have been reading the documentation and I see xml examples all over. For example in the "Define / Introspect Table" section, there is the following example:
<tables>
<table name="Records" introspect="true">
<field ColumnName="RecordID" CF_DataType="CF_SQL_INTEGER" PrimaryKey="true" Increment="true" />
<field ColumnName="RecordVal" CF_DataType="CF_SQL_VARCHAR" Length="80" />
<field ColumnName="RecordDescrip" CF_DataType="CF_SQL_LONGVARCHAR" />
<field ColumnName="isValueable" CF_DataType="CF_SQL_BIT" Default="false" />
</table>
</tables>
However I can't find any examplanation or examples of how I am supposed to use this xml.
Should it work like this?
<cfset xmlstuff = StructNew()>
<cfsavecontent variable="xmlstuff.xml"><cfoutput>
<tables>
<table name="Records" introspect="true">
<field ColumnName="RecordID" CF_DataType="CF_SQL_INTEGER" PrimaryKey="true" Increment="true" />
<field ColumnName="RecordVal" CF_DataType="CF_SQL_VARCHAR" Length="80" />
<field ColumnName="RecordDescrip" CF_DataType="CF_SQL_LONGVARCHAR" />
<field ColumnName="isValueable" CF_DataType="CF_SQL_BIT" Default="false" />
</table>
</tables>
</cfoutput></cfsavecontent>
<cfset qQuestions = variables.DataMgr.getRecords(tablename="questions",xmlstuff=xmlstuff)>
Help appreciated.
Thanks!