Miscellaneous
getTableNamePrefix()
Signature
Section titled “Signature”getTableNamePrefix() — returns any
Description
Section titled “Description”Returns the table name prefix set for the table.
Examples
Section titled “Examples”getTableNamePrefix() <!--- Get the table name prefix for this user when running a custom query --->
<cffunction name="getDisabledUsers" returntype="query">
<cfset var loc = {}>
<cfquery datasource="#get('dataSourceName')#" name="loc.disabledUsers">
SELECT
*
FROM
#this.getTableNamePrefix()#users
WHERE
disabled = 1
</cfquery>
<cfreturn loc.disabledUsers>
</cffunction>