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