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.
Example
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> |
Show 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
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
|
