On Tue, Aug 4, 2009 at 11:56 AM, Nick Causton<[email protected]> wrote: > 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? --------------------------
I do not think that F2Str is exposed to the OLE-DB. How much string in length is really coming back? Why not just pass the file path back to ASP and let it do that. VBScript is better at strings like this then VFP is. You have a presentation problem, not a string problem. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ 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/[email protected] ** 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.
