Make a string field unique

ophbalance · September 11, 2015, 12:30am

I cannot recall having to ever enforce this before, but I need to enforce a unique string value for a property of an object. The end content creator is going to create uniquely named coupon that would be best if they cannot accidentally create two instances of (silly content creators). I’ve never had to do that in all the years I’ve been doing FarCry builds. I tried doing a brief search, but does anyone know offhand if that’s something that can forced on a regular 'ol string field?

justincarter · September 11, 2015, 1:23am

You can validate any property in a content type using a function that uses the naming convention ftValidatePROPERTYNAME where PROPERTYNAME is the name of your property.

You can see an example of this in core’s farUser.cfc:

github.com

farcrycore/core/blob/master/packages/types/farUser.cfc#L181


		
		<cfset var oUD = application.security.userdirectories[application.stCOAPI.farUser.ud] /> 
		
		<cfif structKeyExists(arguments.stProperties,"password") and getmetadata(application.security.cryptlib.findHash(arguments.stProperties.password)).alias eq getmetadata(application.security.cryptlib.getHashComponent('none')).alias>
			<cfset arguments.stProperties.password = application.security.cryptlib.encodePassword(password=arguments.stProperties.password,hashName=oUD.getOutputHashName()) />
		</cfif>
		
		<cfreturn super.createData(arguments.stProperties,arguments.user,arguments.auditNote,arguments.dsn) />
	</cffunction>
	
	<cffunction name="ftValidateUserID" access="public" output="true" returntype="struct" hint="This will return a struct with bSuccess and stError">
		<cfargument name="objectid" required="true" type="string" hint="The objectid of the object that this field is part of.">
		<cfargument name="typename" required="true" type="string" hint="The name of the type that this field is part of.">
		<cfargument name="stFieldPost" required="true" type="struct" hint="The fields that are relevent to this field type.">
		<cfargument name="stMetadata" required="true" type="struct" hint="This is the metadata that is either setup as part of the type.cfc or overridden when calling ft:object by using the stMetadata argument.">
		
		<cfset var stResult = structNew()>	
		<cfset var qDuplicate = queryNew("blah")>		
		<cfset stResult = createObject("component", application.formtools["field"].packagePath).passed(value=stFieldPost.Value) />
		
		<!--- --------------------------- --->

Note that the returned value is a result from either the passed() or failed() methods from the formtool component that matches the field.