This example demonstrates use of the File Action to Upload, Download, Store and retrieve files from the database, Delete Files and Folders, Transform thumbnail images, detect whether a file is an image and Compress groups of files together.

Within your script logic, you may need to execute a query against the connection configured for OWS. With the Action: Executeaction you may specify the Query to execute, and provide a name for the query

Variables are used to provide a quick and protected solution to using dynamic parameters within your SQL Statements. Similar to the logical process of using parameters in stored procedures, the query variable provides a mechanism for passing values from nearly any source within your runtime directly into the query or queries. To add a Query Variable to your query, first add the Variable to your configuration by clicking the Varaible button in the Ribbon.

Open Web Studio provides the ability to use external connections from standard .Net ODBC supported databases via the Connection property of the Rendering, Action:Execute and Sub queries. The provided list below is a breakdown of example Connection Strings

Open Web Studio supports Custom Paging, which enables the developer to control how the system handles paging, over-riding the default paging handler. The benefit of this – on very large sets of data, or complex long running queries is that the SQL script selects only the information from the database that you require. For instance, if you want only the records that occur in order from rows 75 to 100, because you are paging 25 records per page and are on page 4 of 10,000 – requesting only page

The purpose of this example is to demonstrate how to conduct paging across grouped headers within OpenWebStudio by taking advantage of Custom Paging within SQL Server. The original example queries for Custom Paging (seen here) take a basic idea of paging across a standard table where we always seen a specific number of records on the page. For example - Looking at every record in the LISTS table with 10 records on every page. However, that takes awhile, and it makes it so that sections of your d

There are a limited number of examples for utilizing SOAP to access services. This article extends the examples to contain both Input-Action and Query results for interacting with SOAP web services.

This article provides a rapid demonstration of the capabilities of the iPortable implementation within OpenWebStudio