Difference between revisions of "ExecSQL"

From LongJump Support Wiki
imported>Aeric
imported>Aeric
Line 12: Line 12:


====Returns====
====Returns====
:[[Result Class|<tt>Result</tt>]] object. If the return code is greater than zero, use the [[Result_Class#getIterator]] method to cycle through the list of [[Parameters class|Parameters]] objects it contains, one per record.
:[[Result Class|<tt>Result</tt>]] object. If the return code is greater than zero, use the [[Result_Class#getIterator]] method to cycle through the list of [[Parameters Class|Parameters]] objects it contains, one per record.


====Sample App====
====Sample App====

Revision as of 01:15, 8 February 2012

Execute a SQL query.

Syntax

Result result = Functions.execSQL(String query);

Parameters

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

Returns

Result object. If the return code is greater than zero, use the Result_Class#getIterator method to cycle through the list of Parameters objects it contains, one per record.

Sample App

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

Learn More