mrjohnson

Comments

  • The entries in the Contact Group column contain only alphabetical characters, so that can't be the problem.
    in Help with SQL query in Alert Comment by mrjohnson June 2011
  • Yes I have tried that but I am still getting the "invalid column name 'XXXX'" error message. 'XXXX' is the result I am expecting ${ContactGroup} to return, so it is returning what I expect, but SQL does not like the format is which it is returned? Thanks for the suggestion though. 
    in Help with SQL query in Alert Comment by mrjohnson June 2011
  • I am working with dhardy to repair his query as it no longer works after an update to Orion. (Note this is a SQL statement in an email sent by an alert meant to give the contact information for the managers of a node) {SQL:SELECT First_Name FROM Contacts INNER JOIN Nodes ON Contacts.Company = Nodes.ContactGroup WHERE…
    in Help with SQL query in Alert Comment by mrjohnson June 2011
Avatar