Difference between revisions of "ExecSQL"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 15: Line 15:


====Sample App====
====Sample App====
:* [[Create a JSP Record List from a SQL Query]]
:* [[HowTo:Use a SQL Query to List Records in a Custom Page]]
:: This sample uses the execSQL operation to populate a JSP page with a list of object records.
:: This sample uses the execSQL operation to populate a JSP page with a list of object records.



Revision as of 01:43, 12 January 2012

Execute a SQL query.

Syntax

<syntaxhighlight lang="java" enclose="div">

Result result = Functions.execSQL(String query); </syntaxhighlight>

Parameters

query
The SQL query to execute.
Learn more: SQL Syntax

Returns

Result object

Sample App

This sample uses the execSQL operation to populate a JSP page with a list of object records.

Learn More