Search Results
-
Introduction to SQL Query Objects
Updated on: Jan 28, 2011
<p>SQL Yoga provides a SQL Query object in order to facilitate querying the database. With SQL Query objects you set properties rather than build SQL strings. When the time comes to query the database SQL Yoga will generate a SQL query based on the properties of the SQL Query object.</p> <p>SQL ... -
How To Use Cursors With a SQL Query Object
Updated on: Feb 21, 2023
<p>After setting properties for a SQL Query object you can use sqlquery_retrieveAsArray, sqlquery_retrieveAsData and sqlquery_retrieveAsRecords to retrieve your data without having to fuss with a database cursor. But what do you do if you need to access the database cursor for a query? This lesso... -
How Can I Convert a User Search String Into An AND/OR Search When Generating a Query?
<p>Allowing a user to search a database for certain strings is a common operation. Creating a SQL query based on a string entered by the user can be a bit of work, however. SQL Yoga comes to the rescue with some helper commands that can parse strings for you automatically and convert them into se... -
Creating A SQL Query Object
Updated on: Feb 21, 2023
SQL Query objects are arrays that represent a pseudo object. This object defines what a database query will do. You create a SQL Query object by passing the name of a table to sqlquery_create. SQL Queries are not stored anywhere but are stored in temporary variables.
-
How Do I Create Records In a Database Table Using a SQL Query Object?
Updated on: Feb 21, 2023
A SQL Query object provides a quick way of creating data in a database. This lesson will show you how to use sqlquery_create to do so.
Note: When using sqlquery_create none of the validations or callbacks you've defined for Table objects will be triggered.
-
How Do I Delete Records From the Database Table Using a SQL Query Object?
Updated on: Feb 21, 2023
A SQL Query object provides a quick way of deleting data from a database. This lesson will show you how to use sqlquery_delete to do so.
Note: When using sqlquery_delete none of the validations or callbacks you've defined for Table objects will be triggered.