DevGuru ADO DataFactory::ConvertToString Method

Quick References

Features

Partners



			METHOD: DataFactory::ConvertToString string = datafactoryobject.ConvertToString (Recordset) The ConvertToString method is used to convert a Recordset object into a MIME64 encoded string. You can use this method with ASP to embed the resulting MIME string in an HTML page on the server-side for transport to the client's machine. Unfortunately, large data sets can take a long time to transport over HTTP. It is best to use ASP versions 2.0 or later since earlier versions of ASP impose a 32K size restriction on the MIME string. On the client-side, you can use Remote Data Service to convert the MIME string back into a Recordset object. However, this will fail if you have more than 400 rows of data. Since the advent of ADO version 2.0, there are better ways than using MIME to transport data from the server to the client and, as a consequence, the ConvertToString method should be considered antiquated. For example, the RDS DataFactory and DataSpace objects allow you to marshal (transfer) data between the server and the client, and vice-versa. There is one mandatory parameter, The Recordset parameter is the ADO Recordset object to be converted. Code (VBScript): Set objDataFactory = objRDS.CreateObject("RDSServer.DataFactory", strConnURL) ... Dim objRecordsetToConvert Set objRecordsetToConvert = objDataFactory.Query(strConnection, strQuery) strConvert = objDataFactory.ConvertToString(objRecordsetToConvert)