using adobc.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

 

[onpnt]

forum333 but I see you posted there already. try not to post multiple threads.

____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-3811[/sub]

http://www.onpntwebdesigns.com