How to check if a value is a valid MS SQL ID?
The following function will check if a given value is indeed a valid MS SQL ID.
<!--- Function that will check if variable is a SQL newid() UUID syntax: IsSQLID(value)--->
<cffunction name="IsSQLID" access="public" returntype="boolean" output="no">
<cfargument name="uuid" required="Yes" default="" type="string" hint="A GUID value to be checked.">
<cfreturn REFindNoCase("^[0-9A-F]{8}-[0-9A-F]{4}-[0-9A-F]{4}-[0-9A-F]{4}-[0-9A-F]{12}",uuid)>
</cffunction>
4231 viewed | Your opinion... | del.icio.us | Digg it | Tjarko @ 08/08/03 0:00 cet



