Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL question - in Log file
ARACTSQL(xxx,0,-1,-2,100161)
**
True, but smiley could do something like
Action 1 Set Fields setting a display only integer field to $SERVERTIMESTAMP$
Action 2 Direct
Hi all -
I thought maybe I have my Direct SQL sort of working now. But I can't find
any evidence of an Update occuring. Any ideas?
Here is the Update statement in the Direct SQL:
UPDATE HPD_Help_Desk SET UM_Opened_By = '$USER$', UM_Opened_Date =
DATEDIFF(second,'1970-01-01
Look in the SQL logs on the server.
On Tue, May 8, 2012 at 2:20 PM, smiley nti...@umich.edu wrote:
Hi all -
I thought maybe I have my Direct SQL sort of working now. But I can't find
any evidence of an Update occuring. Any ideas?
Here is the Update statement in the Direct SQL:
UPDATE
to achieve the same results with any of the native ARS
functions..
I do understand this kind of qualifies to be one such example..
Joe
From: Axton
Sent: Tuesday, May 08, 2012 4:19 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL question - in Log file
hope it works this time!
J
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza
*Sent:* Tuesday, May 08, 2012 4:28 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Direct SQL question - in Log file
ARACTSQL(xxx,0,-1,-2,100161
So for my edification, why aren't you using the AR Time Functions?
On Tuesday, May 8, 2012 2:20:28 PM UTC-5, smiley wrote:
Hi all -
I thought maybe I have my Direct SQL sort of working now. But I can't
find
any evidence of an Update occuring. Any ideas?
Here is the Update statement
: Direct SQL question - in Log file
ARACTSQL(xxx,0,-1,-2,100161)
**
So for my edification, why aren't you using the AR Time Functions?
On Tuesday, May 8, 2012 2:20:28 PM UTC-5, smiley wrote:
Hi all -
I thought maybe I have my Direct SQL sort of working now. But I can't find
any
7 matches
Mail list logo