At 04:41 PM 9/9/2003 -0400, Don wrote: >Have you ever tried to import your RainingData PICK database into a RDBMS like MS SQL >Server or MySQL then run querie against the RDBMS via ODBC driver or the like instead >of going after the "beast" directly, from what you wrote the latter is no fun?
Sure, that would be preferable. But the problem is MV data does not "map" directly to relational data. MV allows a "field" in a "table" to actually contain multiple values or sub-data. Check if your PICK product has some export options that would "flatten" the data. For example, turning all multivalues into a separate relational table. If it doesn't have this ability perhaps you could export to XML (which is hierarchical and is more like MV data than SQL data). Then there are more tools available to translate XML into relational data. >>Yes, I am working on a project right now that uses a RainingData PICK >>database from a ColdFusion website. >>We had all sorts of problems and finally decided to run the website >>from a local database (MySQL, but it could be anything) and have the >>administrator upload data from PICK periodically. >> >>We had trouble with GaExpress and finally wrote our own PICK program >>that listens on a TCP port and parses simple requests for data. In CF >>we use cfhttp to contact the PICK program and the results are put into >>a query object by manually parsing the results and using QueryNew, >>QuerySetCell, etc... >> >>Remember: PICK is single threaded. The entire operating environment. >>Don't let your web site depend on it. >> >>At 08:57 AM 9/5/2003 -0700, LI, Chunshen \(Don\) wrote: >>>Hello, >>> >>>I'm wondering if anyone has ever worked on a >>>Multi-valued Database system like UniData from ROI. >>> >>>Thanks. >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
