>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?
We're being told to use CFQUERYPARAM in cfqueries. But if I
understand it correctly, there is no CF_SQL types that handle GUIDs.
What we need to be able to do is something like this:
<cfquery "verifyUser">
select * from user
where UserID = <cfqueryparam type="CF_SQL_xxx" value="GUID">
</cfquery>
--
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]
