The actual SQL statements will be almost exactly the same as you usually use except with the result typically going to a cursor. The result set is then output to HTML with the htmlTable method of the HTML object like the following:

lcHTMLout= oHTML.htmlTable('customers',lcHTMLout,999,.F.,'#E5E5E5',.T.,,)

Alternatively, you can do the whole script in the following HTML like the following (which includes a text box):
http://www.activevfp.com/avfpdemo2/Default.aspx?action=showcode
There's also plenty of room for variations in this, but, in general, it's straight .vfp. programming and just redirecting the output to HTML...
>Hi Claude,
>Thanks for the reply,
>as i said at the other thread first step i wantto show only query result on htm+asp pages . so that i need some sample forms which is containing textbox,combobox and i use sometimes between() for record ranges for date,id etc in sqlstrings.anyway i need like this qurery examples. if you help me about this it would be very appreciated.
>
>TIA