@ARSLIST.ORG
Subject: Re: Direct SQL in Active Link problems
Nancy,
I do not have the error message form installed on my server. Do you have
the luxury of installing it on your server? This form when installed and
populated with the data by importing the related arx file that comes with
its def file
:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL in Active Link problems
No I don't have this form. We are not on Unix, we are on Windows - and I
don't even know which one.
I come from an Oracle / Unix background, and here I'm now in MS SQL Server
and Windows. Go figure!
I
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
:
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
Hi Axton –
Oh that’s right – somebody said to use ‘$SERVERTIMESTAMP$’…
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Axton
*Sent:* Thursday, May 10, 2012 11:50 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Direct SQL in Active Link problems
mentioned getting an error.
What is that error?
Joe
From: Nancy Tietz
Sent: Thursday, May 10, 2012 12:00 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL in Active Link problems
**
Hi Axton –
Oh that’s right – somebody said to use
Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, May 10, 2012 12:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL in Active Link problems
**
Yes $SERVERTIMESTAMP$ is a better candidate when you need
Okay - I'll try that. Thanks!
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, May 10, 2012 1:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL in Active Link problems
Mid-Tier may
The error message was:Error in parsing the Run Process or Direct SQL
command (ARERR 9102)
thanks
-Original Message-
From: Nancy Tietz [mailto:nti...@umich.edu]
Sent: Thursday, May 10, 2012 1:45 PM
To: arslist@arslist.org
Subject: RE: Direct SQL in Active Link problems
Okay - I'll try
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
Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller
*Sent:* Thursday, May 10, 2012 1:59 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Direct SQL in Active Link problems
** Hi Nancy,
It has been fun to help you to work out these issues. I have a question
...@umich.edu]
*Sent:* Thursday, May 10, 2012 2:42 PM
*To:* arslist@arslist.org
*Subject:* RE: Direct SQL in Active Link problems
Hi Jason – thanks for your help –
I did try the other form method first as it seemed to be the better option,
however I never got it to work.
What happened
10, 2012 5:21 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Direct SQL in Active Link problems
**
Do it in an action just before the direct SQL action
i.e. In your Active Link
Action 1: Set Fields
$zMyDisplayOnlyInteger$ = $SERVERTIMESTAMP$
Action 2: Direct SQL
update
:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL in Active Link problems
The error message was:Error in parsing the Run Process or Direct SQL
command (ARERR 9102)
thanks
-Original Message-
From: Nancy Tietz [mailto:nti...@umich.edu]
Sent: Thursday, May 10, 2012 1:45 PM
: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL in Active Link problems
**
Hi again –
Is there something I have to do to get the Integer value INTO the Date field???
Here is the ONLY way I could put the DATEDIFF into the Integer field… just
before doing the UPDATe in the Direct SQL
15 matches
Mail list logo