format. If you want to validate a GUID, you'll have to use something more
than just CFQUERYPARAM. Easiest is probably a simple Refind call, with the
appropriate RE. I don't know the exact format of a GUID, but it should be
something like this (change the numbers, and maybe add another segment):
isValid = refind("^[0-9a-fA-F]{5}-[0-9a-fA-F]{5}-[0-9a-fA-F]{5}$", myGuid);
Cheers,
barneyb
> -----Original Message-----
> From: Lola Lee [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 24, 2004 8:32 AM
> To: CF-Talk
> Subject: RE: Question about CFQUERYPARAM and GUIDs
>
> At 11:16 AM -0600 2/23/04, Justin Hansen wrote:
> >I use CF_SQL_VARCHAR for GUIDs. It works just fine.
>
>
>
> What if a string of characters, formatted just the same as a GUID but
> with one less character, was used? According to my coworker, this
> would validate just the same as a real GUID.
>
> --
>
> Lola - mailto:[EMAIL PROTECTED]
> http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
> I'm in Bowie, MD, USA, halfway between DC and Annapolis.
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
