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.
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 goal of this video, "How to query data and display it on your page" is to briefly explain the use of Open Web Studio's template system.
The concepts of the Query and Template are presented. By gaining an understanding of
The goal of this video, "How to group your output results", is to extend your knowledge of the Open Web Studio template structure.
In the video I create an all-encompassing implementation of a grid table structure, made up of the already-demonstrated que
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.