ADO GetString Method
 Complete Recordset Object Reference
The GetString method returns the specified Recordset as a string. This method
can be used to fill HTML tables in ASP files.
Syntax
Set str=objRecordset.GetString(format,n,coldel,rowdel,nullexpr)
|
| Parameter |
Description |
| format |
Optional. A StringFormatEnum
value that specifies the format when retrieving a Recordset as a string
|
| n |
Optional. The number of rows to be converted in the Recordset |
| coldel |
Optional. If format is set to adClipString it is a column delimiter.
Otherwise it is the tab
character
|
| rowdel |
Optional. If format is set to adClipString it is a row delimiter.
Otherwise it is the carriage return
character
|
| nullexpr |
Optional. If format is set to adClipString it is an expression used
instead of a null value. Otherwise it is an empty string
|
Example
To create an HTML table with data from a recordset, we only need to use three of the parameters above:
- coldel - the HTML to use as a column-separator
- rowdel - the HTML to use as a row-separator
- NullExpr - the HTML to use if a column is NULL
Note: The GetString() method is an ADO 2.0 feature. You can download ADO 2.0 at
http://www.microsoft.com/data/download.htm.
In the following example we will use the GetString() method to hold the
recordset as a string:
<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT Companyname, Contactname FROM Customers", conn
str=rs.GetString(,,"</td><td>","</td></tr><tr><td>"," ")
%>
<table border="1" width="100%">
<tr>
<td><%Response.Write(str)%></td>
</tr>
</table>
<%
rs.close
conn.close
set rs = Nothing
set conn = Nothing
%>
</body>
</html>
|
View example
StringFormatEnum Values
| Constant |
Value |
Description |
| adClipString |
2 |
Delimits rows by the rowdel parameter, columns by the coldel
parameter,
and null values by the nullexpr parameter |
Complete Recordset Object Reference
Learn XML with <oXygen/> XML Editor - Free Trial!
 |
|
oXygen helps you learn to define,
edit, validate and transform XML documents. Supported technologies include XML Schema,
DTD, Relax NG, XSLT, XPath, XQuery, CSS.
Understand in no time how XSLT and XQuery work by using the intuitive oXygen debugger!
Do you have any XML related questions? Get free answers from the oXygen
XML forum
and from the video
demonstrations.
Download a FREE 30-day trial today!
|
|
HOME
Printer friendly page
