The GetString method returns the specified Recordset as a string. This method can be used to fill HTML tables in ASP files. Syntax S...
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
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> |
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 |
Goto Recordset Object Complete Reference
