Mark are you saying that you can see the file Phone.htm in the C:\INETPUB\WEBPUB\ directory what I think that the do _genhtml isn't executing
I think that _genhtml is available only at development.
As I have said your best bet is build an XSL that transform your XML and this is easy.
>Thanks Alex
>
>I am pretty well doing what you advise already, it is my COM object that is having the trouble.
>Here is my method (It is just a test method)
>
>
> FUNCTION GETDATA(lcStr as string) AS String
> LOCAL lcRetVal as String
> SELECT 0
> SELECT * from C:\INETPUB\WEBPUB\PHONE.DBF WHERE name=lcStr INTO TABLE C:\INETPUB\WEBPUB\result
> *SET FILTER TO NAME=lcStr
> *CURSORTOXML('PHONE','lcRetVal', 1, 8, 0, "1")
> DO (_GENHTML) WITH "C:\INETPUB\WEBPUB\PHONE.HTM","result"
> lcRetVal=FILETOSTR("C:\INETPUB\WEBPUB\PHONE.HTM")
> RETURN lcRetVal
>
>It is the files created by my method that seem to be the problem
>This method can see the PHONE.DBF but can not see the
>C:\INETPUB\WEBPUB\PHONE.HTM
>file in spite of my being able to see it in file manager.
>
>I am pretty sure I am putting all my files in the wrong places because I can not find any documentation on where they are all supposed to live:(
>
>Thanks for all this help. Your points score must have rocketed of late with all the points I have been awarding you:)
>
>
>
>
>>Hi Mark you don't need to create a file for that if your web service returns the html then you can do the following:
>>
>>lchtml = losoap.MyWebServiceMethod()
>>Response.Write lchtml
>>
>>>I have created a web service that does a select into a cursor and then runs GENHTML.prg on the cursor and then FILETOSTR on the output ogf GENHTML.
>>>
>>>I am now getting file does not exist when I call my WS from an ASP page.
>>>where is the best place to put my temporary files to ensure that they are seen when called from a browser.
>>>
>>>So far I have tried putting them in the c:\temp\ folder on the workstation that has IIS installed and also putting them in my C:\INETPUB\WEBPUB\ folder
>>>
>>>Many thanks
Alexandre Palma
Senior Application Architect