Re: Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

2012-05-09 Thread Joe Martin D'Souza
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

Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

2012-05-08 Thread smiley
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

Re: Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

2012-05-08 Thread Axton
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

Re: Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

2012-05-08 Thread Joe Martin D'Souza
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

Re: Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

2012-05-08 Thread Nancy Tietz
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

Re: Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

2012-05-08 Thread Chuck
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

Re: Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

2012-05-08 Thread Joe Martin D'Souza
: 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