Webbot component non-editable

[Thanasis \(sch\)]

Hi to everyone,

what i want to achieve is to edit the code generated by FP (database
interface wizard).
More specifically i want to order the records inside an asp page by date
field in ascending order.
I just want to type the sql statement ORDER BY dateA inside the webbot.
I swith to code view, i locate the webbot and i type "ORDER BY dateA "
besides "SELECT * FROM Results".
But i'm always getting the error message:
The contents of a FrontPage component have been modified. These contents
will be overwritten when you save this page.

Thanks in advance
thanasis

 

[Kathleen Anderson [MVP - FrontPage]]

The SQL appears in two places, and in two colors. Modify the SQL statement
in the gray-colored code and save your change. The change will get
replicated to the maroon colored code.

 

[Thanasis \(sch\)]

THANKS A LOT.It works

The SQL appears in two places, and in two colors. Modify the SQL statement
in the gray-colored code and save your change. The change will get
replicated to the maroon colored code.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/