RidgeStar
About
Locations
Manual
Preface
Introduction
Versions
Concepts
Construction
Usage
Operations
Questions
Features
Settings
Internals
Cookies
Database
Debug
Diagnose
Properties
Server Software
Setsql
Appendices
Reference
Service
Logon
RidgeStar

Manual: Internals-Setsql

Logontranslate
Get Started |Calendar |Locations

Understanding and Using Setsql Mode

A RidgeStar Interactive SiteInteractive Site typically consists of one or more functional pages that rely in interacting with a database respository containing site related data. This is accomplished using mysqlnd 8.2.17 currently, which has an extensive range of support for a variety of SQL (Structured Query Language) commands.

If you would like to be able to view the variety of SQL commands being issued by the various pages, activate Setsql mode.

Turning ON Setsql mode
You can activate Setsql mode by adding the keyword sequence "setsql=1" to any interactive page. You need to understand how HTTP uses the question mark (?) and ampersand (&) to separate keywords from the page name, but here's an example using this page of what you'd put in the Address/Location area:

http://ridgestar.com/setsqlmode.php?setsql=1

Turning OFF Setsql mode
To disable Setsql mode, add the keyword sequence "Setsql=0" to any interactive page, as

http://ridgestar.com/setsqlmode.php?setsql=0

What happens when Setsql is on?

Setsql Mode will display the actual SQL Command(s) that is(are) being issued to the Database processor. This can be extremely useful when determining precisely what the Query Language construct is for and doing.

To display an example of Setsql output in this page, turn on Setsql mode as described in the paragraph titled "Turning ON Setsql mode".