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
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate is for developers who want to document their knowledge of JavaScript and the HTML DOM.
The XML Certificate is for developers who want to document their knowledge of XML, XML DOM and XSLT.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
The PHP Certificate is for developers who want to document their knowledge of PHP and SQL (MySQL).
|
|
