Set rs1 = Server.CreateObject("ADODB.Recordset")
while not rs1.eof
label = rs1.FIELDS("desc").value
response.write label & "OK"
EMPTY page with a bunc of OKs
- how do i get the data displayed? Heard of the texttoclob thingy but how do i use it?
- Is this a CLI problem?
- am able to display the result from dbaccess .....
- tried the same query with SQL server with same data types. No problems!
I found this in the OLEDB programming manual:
A server-side scrollable cursor (corresponding ADO flags: adOpen-
Dynamic, adOpenStatic, adOpenKeyset) cannot be opened if results
include simple large objects (BYTE and TEXT) or collections. You can
use server-side nonscrollable cursors (adOpenForwardOnly) or
client-side scrollable cursors (adUseClient) with these types.
Maye it might be interesting to test it with CLOB (smart blobs. You will have to define a smart blobspace for that. (onspaces)