Does anyone have any ideas how I might achieve the following:

We have an ASP webpage accessing data via OLEDB using VFP stored procedures
to run the code to achieve this.

What I now need to do is to dynamically serve a page from elsewhere on the
network, lets call the driving page GetFile.asp.


Now in GetFile.asp I have:
Response.BinaryWrite(GetFileVBS("MyFileName.txt"))


GetFile.asp also has a VBS procedure:

GetFileVBS
Function GetFileVBS(cFileNamePath)
        Set GetFileVBS = oConnDB.Execute("GetFileVFP('cFileNamePath')",,4)
End Function


And in the VFP stored procedures we have:
PROCEDURE GetFileVFP
        LPARAMETERS tcFileNamePath
        RETURN FILETOSTR(tcFileNamePath)
ENDPROC


Problem is OLEDB Execute command does not appear to like a string returned:
Response object error 'ASP 0185 : 8002000e' 
Missing Default Property 
/ GetFile.asp, line 15
A default property was not found for the object

In fact even if I could find a way to do this I am not sure that a VFP
stored procedure within OLEDB could run the FileToStr() command anyway.

Any thoughts on a alternative way of serving this file?

Nick




_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/!&!aaaaaaaaaaayaaaaaaaaaoo2khh5xw1oq9etmzh8uaqijqaaeaaaafxpppqcffvfvla7we1utjubaaaaa...@associateddata.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to