using adodb.recordset getString method

[michaelcoleman]

Hello,

I'm having trouble getting the getstring method to work in vbscript over asp.

set oADOConnection = openDBConnection()

Set oADORecordset = oADOConnection.Execute(buildsql(report_type)) '''call function in sqlUtility.asp and get data

Response.Write(oADORecordset.GetString(adClipString,-1,",",chr(13)&chr(10),"(NULL)&quot)


---I know that there is data
---I know that it works in vb6
---I know that the rest of the asp code is correct

But it causes an error and nothing is displayed....


Can anyone offer insite?

One of my guesses is that the two are using different dll's, if that is true, how to specify which one in vbscript

MJC

 

[MarkSweetland]

Not sure what error you're receiving, but the getstring method should use html in the column and row delimiters:

.GetString (adClipString,1,&quot;   &quot;, &quot;<br>&quot;,&quot;(Null)&quot

Mark

&quot;You guys pair up in groups of three, then line up in a circle.&quot;
- Bill Peterson, a Florida State football coach