MQSeries.net :: View topic - Data (column) conversion issue on SQL select

schroederms · Posted: Wed Jul 09, 2008 1:07 pm Post subject:

I'm simply building a string and doing a passthru, what is happening is in this case PartnerID is a uniqueIdentifier (SQL Server) and the SQL finds the row just fine, but when it populates my result set, the PartnerID looks as though it is a hex value and the dashed are gone. I'm runninng the broker on AIX as well.

Any ideas?

Thanks.

Input string and result below.

(0x03000000):SQL1 = 'SELECT dbo.Partner.PartnerID, dbo.Partner.FirstName,
dbo.Partner.LastName, dbo.Partner.MiddleName, dbo.Partner.PreferredName,
dbo.Partner.BusinessName, dbo.Partner.LanguageId,
dbo.Prefix.Name AS Prefix, dbo.Suffix.Name AS Suffix, dbo.Partner.PartnerId
FROM dbo.Partner LEFT OUTER JOIN
dbo.Suffix ON dbo.Partner.SuffixId = dbo.Suffix.SuffixId LEFT OUTER JOIN
dbo.Prefix ON dbo.Partner.PrefixId = dbo.Prefix.PrefixId INNER JOIN
dbo.PartnerStatus ON dbo.Partner.PartnerStatusId = dbo.PartnerStatus.PartnerStatusId
WHERE (dbo.Partner.PartnerStatusId = 1) AND dbo.Partner.PartnerId in ('cc3812c3-fcd7-4fed-9171-3bded8f3cec4')'
(
(0x01000000):RESULT = (
(0x03000000):PartnerID = X'cc3812c3fcd74fed91713bded8f3cec4'
(0x03000000):FirstName = 'Lucas'
(0x03000000):LastName = 'Carder'
(0x03000000):MiddleName = 'D'
(0x03000000):PreferredName = 'Luke'
(0x03000000):BusinessName = NULL
(0x03000000):LanguageId = 1
(0x03000000):Prefix = 'Dr.'
(0x03000000):Suffix = 'II'
(0x03000000):PartnerId = X'cc3812c3fcd74fed91713bded8f3cec4'
)