Passing a UUID through URL

Better yet, use <cfqueryparam>

Adam Cameron wrote:
>> i pass this
>> &selection=D8660E35-1372-69E5-F732112DB40A7696
>>
>> and get this
>> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
>> Driver][SQL Server]Invalid column name 'D8660E35'.
>>
>> i guess this is more of a sql problem than a CF problem
>
> Yeah. Your query sounds screwed, as if you're using the VALUE (ie: the
> UUID in this case) in place of a column name. Which is what the error
> suggests.
>
> What's your query SQL?
>

Actually that is the error one gets when one forgets the quotes around a
string with dashes in it. The SQL parser is trying to subtract what it
perceives as one column name "D8660E35" from what it perceives as
another "1372".

Try putting single quotes around your string value.

> i pass this
> &selection=D8660E35-1372-69E5-F732112DB40A7696
>
> and get this
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
> Driver][SQL Server]Invalid column name 'D8660E35'.
>
> i guess this is more of a sql problem than a CF problem

Yeah. Your query sounds screwed, as if you're using the VALUE (ie: the
UUID in this case) in place of a column name. Which is what the error
suggests.

What's your query SQL?

--
Adam

> I am having trouble passing a CreateUUID() through a URL because of the hyphens

There's nothing wrong with having hyphens in a URL
( http://tools.ietf.org/html/rfc3986#section-2.3). Well there shouldn't be.
And, indeed, we use UUIDs on URLs all the time, and nary a problem.

What is this problem you are perceiving you are having?

--
Adam

Try using the URLEncodedFormat and URLDecode functions.
On the page where the UUID is being created:
<cfset myUUID = CreateUUID()/>
<cfoutput>#URLEncodedFormat(myUUID)#</cfoutput>
On the page that needs to read the variable:
<cfoutput>#URLDecode(myUUID)#</cfoutput>