1.) In FrontPage or whatever your favorite HTML editor (even the vfp edior or Notepad) put in something like the following and call it orderlist.htm
<HTML>
<BODY>
<orders>
Date ID Amount
< %= tCursor.Order_Date %> < %= tCursor.Order_id %> < %= tCursor.order_net%>
</orders>
</BODY>
</HTML>
No, AVFP won't do this part automatically for you.
2.) In your vfp code(in the main.prg), put in a block of code like this
CASE oProp.Action=='mytest'
SELE * FROM Order INTO CURSOR tCursor
lcHTMLfile = 'orderlist.htm'
lcHTMLout= FILETOSTR(oProp.HtmlPath+lcHTMLfile)
lcHTMLout= oHTML.htmlTable('orders',lcHTMLout,10,.T.,'#E5E5E5',.F.;
,VAL(oRequest.querystring("page")),oRequest.querystring("nav"))
lcHTMLout=oHTML.mergetext(lcHTMLout)
3.) Call the routine with:
/mywebapp/default.aspx?action=mytest
>well, may be I don't know much about HTML stuff. I try to do this
>
>
>CASE oProp.Action=='hello'
> lcHTMLout= oHTML.htmlTable('tcursor',lcHTMLout,5,.F.,'#E5E5E5',.F.,0,'')
> lcHTMLout= oHTML.mergetext(lcHTMLout)
>
>
>but what i don't undesrtand, is what do I need to publish the content of my cursor in the html page
>do I need to create the page with macromedia fisrt and then put that code in the web app? does the active vfp does it for me?
>please forgive my ignorance but, I really think that the documentation isn't enough for my little uderstanding on this matter. would you please guide me up?
>
>what I am looking for is a simple solution to get the content of a table into a web page with some textboxes for impu, then send a link to that particular page through email and the user will click on the link, fill the textboxes and click submit or somthing like that, then the information in my sql server will be update.