I would not use TIMESTAMP in direct sql in active links. You will get different times from different users, depending on what timezone the client machine is configured for.
Axton Grams On Thu, May 10, 2012 at 10:37 AM, smiley <[email protected]> wrote: > Hi all - > > This Direct SQL seems like it should work, but I am getting an error > message > (in Mid-Tier, 7.6.03). > > UPDATE HPD_Help_Desk SET UM_Opened_By = '$USER$', UM_Opened_Date = > DATEDIFF(second,'01/01/1970 00:00:00','$TIMESTAMP$') +14400 WHERE > Incident_Number = '$Incident Number$' ; > > The above Direct SQL should translate to this: (which actually works as is > in ARUtilities' SQL); > > UPDATE HPD_Help_Desk SET UM_Opened_By = 'myuserid', UM_Opened_Date = > DATEDIFF(second,'01/01/1970 00:00:00','05/09/2012 03:00:00 PM') +14400 > WHERE Incident_Number = 'INC000000031826' ; > > So what is Direct SQL doing to this sQL??? Is it the $Incident Number$ or > $USER$ or $TIMESTAMP$ ??? > > I actually tried it withOUT the $TIMESTAMP$... and I had some NULL / IS > NULL > etc in there and had to take that out as I couldn't get the nulls to work > in > the WHERE statement. > I thought it was working --- although that was in the BMC Remedy Client, > not > Mid-Tier. > It is easier for me to test in the Client because I don't have to Flush > Cached every time I tinker with the AL's. > > So close.... > On the Client I was testing and found that the fields were being updated > every Other time! However I am looking at ARUtilites in a SELECT statement > after every step to see what happened... and maybe IT is only working every > other time. Good grief! > > Any other ideas out there? Or maybe sympathy?? > I know the Client works differently than the Mid-Tier but this is very > tiring. > Thanks for listening!! > > > -- > View this message in context: > http://ars-action-request-system.1093659.n2.nabble.com/Direct-SQL-in-Active-Link-problems-tp7547138.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
