Hey guys I have a customer who wants a simple intranet site but want to host it on thier Sun Server Using Chillisoft.

I do most of my work in ASP and wondered what limitations there would be using behaviors like Pure ASP uplaod and such?

Thanks.

Hi saw this on the internet:

3. What are the limitations?

As can be seen from the Chili!Soft ASP vs Microsoft ASP 3.0, the limitations of Chili!Soft ASP are virtually none to speak of. Certain adjustments need to be taken into account:

1MySQL as a database platform rather than MS-Access or SQL-Server 7.0 . Please refer to the database conversion point-form guide below.

2. ADO RecordsetIssueSolutionAbsolute Positioning (ie. AbsolutePage and AbsolutePosition properties) is an unsupported ADO Recordset method / property. In our experience, this is only a real issue when a database query returns a large number of rows which are impractical to display all on one page.

The solution here is to modify the SQL query so as to display only the number of rows desired per page.

EXAMPLE:
"Select * from my_table LIMIT " . Start . "," . End . ";"

The logic to control "Start" and "End" is then done within the ASP code and the query executed each time the "Next" or "Previous" Button (etc.) is pressed within the web page. Add new, Delete and Update methods make use of SQL INSERT, DELETE and UPDATE statements directly.

The above does become a considerable limitation however if the ASP code is being generated by a code generating tool, capable only of using the above methods and properties (eg. MS FrontPage). We therefore recommend that such code generators should not be used to develop ASP pages for the Chili!Soft ASP platform.