Understanding and Using Setsql Mode
A RidgeStar Interactive 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.3.13 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.
- SetSQL via ExampleRoutine #34
- Select dusKey,dusFirstName,dusLastName from Users where dusReferee=1 order by dusLastName,dusFirstName
Disable Setsql mode by following the instructions under "Turning OFF Setsql mode".
