Difference between revisions of "Using the Advanced Recordset Editor"
m (1 revision) |
m (Text replace - "?" to " ") |
||
| Line 1: | Line 1: | ||
==Using the Advanced Recordset Editor== | ==Using the Advanced Recordset Editor== | ||
| − | Databases can potentially contain vast amounts of data. Often there will be more data in the database than you will want to present to your users. Perhaps there are too many rows to show efficiently, or there is sensitive data that you would not want to show to all users who view a page | + | Databases can potentially contain vast amounts of data. Often there will be more data in the database than you will want to present to your users. Perhaps there are too many rows to show efficiently, or there is sensitive data that you would not want to show to all users who view a page like credit card information. NetObjects Fusion provides Recordsets to filter the data that is presented to users. |
Sometimes, however, to implement advanced functionality in your site, it is necessary to query the database in SQL. SQL, or Structured Query Language, is the standard native language used to ask questions of databases. NetObjects Fusion hides this complexity from users in all but the most advanced situations. | Sometimes, however, to implement advanced functionality in your site, it is necessary to query the database in SQL. SQL, or Structured Query Language, is the standard native language used to ask questions of databases. NetObjects Fusion hides this complexity from users in all but the most advanced situations. | ||
# In the Recorset section of the Data Sources panel, double-click the'''Recordset'''that you want to work with. | # In the Recorset section of the Data Sources panel, double-click the'''Recordset'''that you want to work with. | ||
Revision as of 20:21, 10 December 2013
Using the Advanced Recordset Editor
Databases can potentially contain vast amounts of data. Often there will be more data in the database than you will want to present to your users. Perhaps there are too many rows to show efficiently, or there is sensitive data that you would not want to show to all users who view a page like credit card information. NetObjects Fusion provides Recordsets to filter the data that is presented to users. Sometimes, however, to implement advanced functionality in your site, it is necessary to query the database in SQL. SQL, or Structured Query Language, is the standard native language used to ask questions of databases. NetObjects Fusion hides this complexity from users in all but the most advanced situations.
- In the Recorset section of the Data Sources panel, double-click theRecordsetthat you want to work with.
- On theRecordsetdialog, display the Advanced tab.
The recordset is established and reflects the custom SQL filter.
- Add or modify the code, then click the Test button.
- Specify how many recordsets to return and click OK to close the Recordset editor.
- The end result is the creation of a Recordset that describes the data you want to see. For example, "select product name from products where sale price is greater than 0.00" is the type of filter that can be created from the Recordset dialog. You could name this Recordset "productsForSale".
