Thanks, I'll do that. I don't absolutely have to use ADO, it just so happened that the component I picked to test with returned an ADO record set. To be honest, the components I write in the future will more than likely return arrays anyway. I believe this will help performance in the long haul when traffic picks up. I read some where that record sets take up more resources. I'll read up on it anyway though.
I'm glad I found this list. Nothing is a better teacher than experience and I'm sure there is a lot of experience in here. I searched and search the web for help on my problem and didn't find anything except examples of things that didn't work for me.. Lol. Thanks, Dave -----Original Message----- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 11:32 AM To: CF-Talk Subject: Re: ActiveX DLL to return a collection with CFOBJECT 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 > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
