> At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
>>
>> Any character string will validate if you use CF_SQL_VARCHAR, regardless of
>> 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);
>
> Isn't this counterintuitive?
No. SQL allows you to even create your own datatypes. Why would
some cf_sql-type automagically exists when I write my own
datatype for GUIDs or ISBN numbers?
The SQL standard has a number of predefined datatypes. For those
cf_sql-types are provided. If you wish to use other datatypes you
are on your own.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
