Dynamic Queries

[James74]

Right now I have a coldfusion page that creates dynamic queries:
<CFSET qrySmiles = QueryNew("SmilesID,ElementID,Element")>
<CFLOOP index="SmilesIndex" from="1" to="#ArrayLen(SmilesStringArray)#" step="1">
<CFSET LastRow = QueryAddRow(qrySmiles)>
<CFSET temp = QuerySetCell(qrySmiles, "SmilesID", "#SmilesStringArray[SmilesIndex][1]#")>
<CFSET temp = QuerySetCell(qrySmiles, "ElementID", "#SmilesStringArray[SmilesIndex][2]#")>
<CFSET temp = QuerySetCell(qrySmiles, "Element", "#SmilesStringArray[SmilesIndex][3]#")>
</CFLOOP>
Does anyone know if you can do this with the cfxapi?

Thanks

James

[James74 · Accepted solution]

Figured it out, just use the cfx query class:
http://livedocs.adobe.com/coldfusion/5.0/CFML_Reference/CFXRef_C4.htm