Re: [Reactor for CF] UUID Validation

Beth Bowden Thu, 31 Aug 2006 11:00:06 -0700

Brian, can you attach a create table script to the trac ticket? Beth

On 8/31/06, Brian Kotek <[EMAIL PROTECTED] > wrote:

Also possibly related is that the XML dictionary entry for our UUID column looks like this:

<useruuid>
            <label>userUUID</label>
            <comment/>
            <maxlength>0</maxlength>
            <invalidType>The userUUID field does not contain valid data. This field must be a string value.</invalidType>
        </useruuid>

Note that the error message says the field must be a string. No idea if this has anything to do with the issue we're discussing but I thought I'd point it out. I'll keep digging as well and post if I discover anything else of note.

Thanks

Brian

On 8/31/06, Brian Kotek < [EMAIL PROTECTED]> wrote:

All I know is that a valid SQL Server UUID in the format 8-4-4-4-12 is definitely failing the validation that Reactor is applying to it. Is Doug saying then that the real issue is in Reactor not properly formatting the UUID internally ( i.e. it should be re-formatting that UUID to a CF-compliant 8-4-4-16 format?)

On 8/31/06, Beth Bowden < [EMAIL PROTECTED] > wrote:

Let me see if I understand. The "formatValue()" in convention.cfc and various places in the dao.project.xsl should handle the conversion between the two formats. So changing the validator xsl is a moot point.

On 8/31/06, Doug Hughes < [EMAIL PROTECTED] > wrote:

But wouldn't this always be a CF UUID here because of how Reactor translates these?

Doug

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Beth Bowden
Sent: Thursday, August 31, 2006 8:22 AM
To: [email protected]
Subject: Re: [Reactor for CF] UUID Validation

Doug,

It's just the validation portion. Here's a snippet from the ticket:

    The UUID validation code that Reactor generates looks like this:

   
   <cfif NOT ReFindNoCase("[A-F0-9]{8,8}-[A-F0-9]{4,4}-[A-F0-9]{4,4}-[A-F0-9]{16,16}",    arguments. UserRecord?.getuserUUID())>
   <cfset arguments.ErrorCollection?.addError("User.userUUID.invalidType ") />
   </cfif>

Beth

On 8/31/06, Doug Hughes <[EMAIL PROTECTED]> wrote:

FYI, Reactor translates MSSQL uuids to CF uuids and back again. Based on the number of characters in Oracle's uuids this should work too. However, it might not work in all cases if the uuids are not 32 (useful) characters long. In these cases they'd have to be varchars.

Doug

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Beth Bowden
Sent: Thursday, August 31, 2006 7:52 AM
To: [email protected]
Subject: [Reactor for CF] UUID Validation

Brian put in a request to expand the UUID validation to include the Microsoft/DCE standard. Looking around, I've found these UUID formats:

ColdFusion UUID format: xxxxxxxx-xxxx-xxxx-xxxxxxxxxxxxxxxx (8-4-4-16).
Microsoft/DCE standard: xxxxxxxx-xxxx-xxxx-xxxxxx-xxxxxxxxxx (8-4-4-4-12)
Oracle: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (32)

Does this cover your needs? Can you add another UUID format?

Thanks, Beth

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Re: [Reactor for CF] UUID Validation

Reply via email to