>
> 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>
Not at all
What you have to remember is that a GUID is just a string of characters
- different systems produce them differently
CF, SQL Server and other apps won't produce the same data layout
If you expand it for GUID, people will ask for a data-type for emails,
Zip, telephone numbers and credit cards ("But they're valid data-types,
right?")
You're meant to do the validation yourself, and then pass your data to
the server
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
