Have you tried turning on SQL logging at the server and taking a look at exactly what Remedy is passing to the SQL server and what the SQL server is returning?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of brooksm Sent: Thursday, June 21, 2007 1:11 AM To: [email protected] Subject: Odd results in Active Link SQL Set Fields I've created a SQL view from another SQL Server 2005 database. When I run a query on this view ins SQL Server management Studio, everything works as expected. But when I do a SQL Set fields Active Link, I only get 29 characters in the field. Here is the SQL that I used to create my view: CREATE VIEW [dbo].[VIEW_ALT_ASSETS_USERS] AS SELECT * FROM OPENQUERY([D-DBSERVER],'SELECT vc.[Guid], vc.[Name], vc.[User], sn.[System Manufacturer], sn.[Computer Model], sn.[Serial Number] FROM vComputer vc LEFT JOIN Inv_AeX_HW_Serial_Number sn ON vc.[Guid] = sn.[_ResourceGuid] ORDER BY sn.[Computer Model]') My problem is the Guid field. Querying this view in SQL Server Management Studio gives me values like this: 51A22A9E-2AE1-422F-B99C-53B841D38C92 But when I do the same query in my Set fields AL, I get this returned: {51A22A9E-2AE1-422F-B99C-53B8 Note the "{" and the trailing 8 characters missing. I'm stumped... Anyone have an idea? Thanks Brooks -- View this message in context: http://www.nabble.com/Odd-results-in-Active-Link-SQL-Set-Fields-tf395673 8.html#a11227200 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
