I don't have a solid answer but there area few things to keep in mind when working with COM with cfobject. CF pukes when you try to reference anything with a null value passed back from a com object. CF pukes if you reference a piece of data that is one of the less common datatypes in an ADO recordset (like sql server's decimal). I'm sure the list is a lot longer...I just know these two from experience.
I will say that i've seen the exact problem you have more than once, and almost everytime it is because I am trying to reference a null. If you haven't already, go to http://www.cfcomet.com and read their write-up on using ADO from within CF and the comments in the forum. I have successfully used ADO with cfobject, but it can be very picky. The null problem alone can be a showstopper sometimes though. jon ----- Original Message ----- From: "David Jones" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 26, 2002 11:02 AM Subject: ActiveX DLL to return a collection with CFOBJECT > Hi All, I'm a new subscriber to the list and about 3 projects new to CF. I > recently posted a message but was unsure if it got to the rest of you. So > please paron me if you receive this as a dubplicate. > > ------------------------------------------------------------ > > I am having trouble returning a collection with the <cfobject> command. Any > help would be appreciated. > > I have an ActiveX Dll with the Prog-ID:ghZipLocator.clsghZipLocator > inside that I have a method/function called "GetCompanyNames". > GetCompanyNames returns a recordset. Which works well in ASP. > > <snip> > Everything seem to work fine until it get to the loop. At this point I get > the following error. > > unknown exception condition > > unknown error while executing a tag. > > > I can send the VB project code if any of you think it may be helpful. If I > am doing this incorrectly, an example of the correct procedure would be > greatly appreciated. > > Thanks, > > David > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
