coldfusion converts GUID to binary

Forum|Forum|20 years ago
May 26, 2006
2 replies
1427 views

here's a simple stored procedure

CREATE PROCEDURE guidTEST
AS
SELECT newID() as guidTEST,
'8B710BAD-2F8C-42AA-BA67-8984CBA81BD6' as guidTEST2

when i run this sproc from the query analyzer (exec guidTEST)
it returns, as expected, a query with a new GUID and the 2nd GUID as a string

BUT, when I run this:

<cfstoredproc procedure="guidTEST" datasource="test">
<cfprocresult resultset="1" name="test">
</cfstoredproc>
<cfdump var="#test#">

the first column is converted to binary, (the second column is still a string).
how do i make sure the first col stay returns as a string?

i'm running CF7, SQL2000, apache

THANKS!!

Database access

This topic has been closed for replies.

A

Anonymous

okay, i can cast the guid as a string it it works....

unfortunately, this won't work as a solution for me because I'm dealing with a legacy app that passes a ton of GUIDs back and forth to the DB.

i'm running CF7, SQL2000, apache locally. the production site uses CF6.1. The only thing I can think of is that 6.1 interprets GUIDs differently than 7. Can anyone else even replicate this issue? I'm confused and have been serching for a week with no luck.

A

Anonymous

You can try running "SELECT @@OPTIONS" against both databases and see if there are any differences.

But the fact is GUIDS become strings the moment you use them in CF6 and 7.

Attach the EXACT error message you get and the code that generated it.

A

Anonymous

mike-- thanks for sticking with me on this. i've posted this issue to some other forums with no luck.

i tired select@@ options...
my dev box returned 5496
the production box returned 1080
(note, the production box is running sql 7)

here are 2 screen shots of the error, the stack, and a dump of the relevant query-- in the dump, it labels the 2 GUIDs as binary objects, but i think they are byte arrays (at least, they certainly are not binary, and when I run anything on them, coldfusion tells me what i'm doing will not work with byte arrays)

http://www.thepokerhound.com/bpoerror.gif
http://www.thepokerhound.com/stackerr.gif

also, it occurs to me that the problem may be because I'm using an ODBC connection... i could not get the standard sql server connector to work (presumably JDBC), and they are a number of posts that suggest the ODBC workaround.

thanks again.

A

Anonymous

SELECT
CAST (newID() AS varchar(55)) as guidTEST

A

Anonymous

thanks... i'm wondeirng if there's anything that would work as a global solution since there are a ton of instances in which i grab GUIDs from the db.

also, actually, i was a little bit off here. apparently cf 6 and above convert GUIDs to bytearrays. what's strange is that this problem isn't happening on the production server. it's only occuring on my local dev machine. is there some global setting that i'm missing that automatically converts bytearrays to strings? or perhaps a setting on the database side thate ensures more friendly encoding of GUIDs?

if not, can someone recommend a workaround that will let me convert the bytearrays when i need to?

thanks

-j

A

Anonymous

quote:

Originally posted by: JJBBDD
... if not, can someone recommend a workaround that will let me convert the bytearrays when i need to?

See the post above!

Anyway, you are quite incorrect, "CF6 and above" does not "convert GUIDs to bytearrays". If you examine the type of the returned column it is "uniqueidentifier" but it normally behaves just like a string in CF. Output and string functions work just as on any string.

Anyway, you're a fool if you use GUIDs. Google "COMB GUIDS".

COMB GUID's would be the global workaround you asked for.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded