1 Reply Latest reply on Feb 27, 2007 12:14 PM by James74

    Dynamic Queries

    James74 Level 1
      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