• General
  • Introducing SebTags
  • Global Attributes
  • Skins
  • Special Component Methods
    • getFieldsStruct()
    • getMetaStruct()
    • getFieldsArray()
  • Session Messages
• cf_sebForm
  • Basics
  • HTML attributes
  • Submit to a CFC Method
  • Getting Data
  • Adding and Updating Records
  • Format
  • Sending Email
  • Validations
  • Filters
  • Forwarding
  • Output Configuration
  • Direct Table Editing
  • sebformjs
• cf_sebField
  • sebField General Attributes
  • Generic Field Types
  • Buttons
  • Formats
  • Multi-Value Fields
    • "Other" Options
  • Files
    • Folders
    • Thumbnails
  • Textarea
  • Yes / No
  • Date Fields
  • Custom Types
• cf_sebTable
  • Overview
  • Display Options
  • Getting Data
  • Paging
  • Sorting
  • Edit Records
  • Links
  • Components
• cf_sebColumn
  • General Attributes
  • Linking
  • Basic Column Types
  • Form Column Types
  • Submit
• cf_sebGroup
  • Overview
  • Types
  • Adding Related Record
• cf_sebMenu
  • Basics
• Change Log
  • Change Log

Getting Data

In order to display data in cf_sebTable, it must be available to the tag. This can be done a few ways.

One of the following methods must be used and one attribute is required in all cases:

• pkfield (required): The name of the primary key field for the data (which must be a column in the query)

Loading Data from a Query

The cf_sebTable tag can take a "query" attribute. This can either be a recordset variable or the name of a query that is on the page calling cf_sebTable.

Example

<cf_sebTable query="qEmployees">
	<cf_sebColumn dbfield="FirstName" label="First Name">
</cf_sebTable>

Getting Data from a CFC

The cf_sebTable tag can get a query from a CFC using the following variables.

• CFC_Component (required): a reference to the CFC in memory
• CFC_GetMethod (required): The name of the method that will return the needed query.
• CFC_GetArgs (optional): A structure representing arguments to be passed into the method.
• CFC_HideGetArgCols (optional): If true, no column will be displayed if it has a matching key in the structure passed to "CFC_GetArgs".

Example

<cf_sebTable CFC_Component="#Application.Employees#" CFC_GetMethod="getEmployees">
	<cf_sebColumn dbfield="FirstName" label="First Name">
</cf_sebTable>

Datasource and Table

Although it is not recommended, you can get data to cf_sebTable directly from a database table. Note that this may not be supported in future versions. Use the following arguments:

• datasource (required): The datasource to query
• table (required): The table to query