0 Replies Latest reply on Jun 28, 2007 9:00 AM by redeftboy_original

    ASP to Coldfusion accessing COM recordset

      I am attempting to rewrite some ASP code with CF MX 7. The ASP code originally returned a recordset from Microsoft Indexing Service. I can create the object and return the number of objects within the recordset but I don't know how to access the records within the recordset (i.e. output the records).

      I've tried the code below to loop over the collection without any success as I receive the error: " The cause of this exception was that: java.lang.NoSuchMethodException: There is no method called Item."

      Any help would be appreciated.

      <cfobject action="create" type="com" name="q" class="ixsso.query">
      <cfset q.query(#searchstring#)>
      <cfset q.catalog(#catalogtosearch#)>
      <cfset q.sortby(#searchrankorder#)>
      <cfset q.columns("doctitle, filename, size, write, rank, directory, path")>
      <cfset q.maxrecords(#maxrecords#)>

      <cfset rs = q.createrecordset("nonsequential")>

      This object has #rs.recordcount# items.

      <cfloop collection = "#rs#" item = "file2">
      Path: #file2.path# <BR>