Hi,

I've been out of town a few days and just now got a chance to see
these posts. You may have already been given the information I am
about to provide. If so, I apologize.

I have written a complete Remedy web site in Cold Fusion for our
support people. I used the ARS42i Helper Component, a free tool from
James Croom (www.croomweb.com). We are able to add new tickets,
modify existing tickets, view tickets, etc. I used JavaScript to
perform the validation that we normally perform with Active Links. I
let Remedy process all the filters and then use exception handling if
problems occur.

I played around with ARSPerl, but I was able to develop a fully
functional site more quickly with this tool. I highly recommend you
look into it. If you have any questions about it, please feel free to
contact me.

Sharon

-----Original Message-----
From: Greg Gibson [mailto:Greg.Gibson@HSC.COM]
Sent: Thursday, March 29, 2001 4:23 PM
Subject: Re: Remedy and Cold Fusion


**

Until now, I have never noticed "for update" in a select clause.
Apparently, it is SQL standard.
"For update" is also in my Sybase manual.

Still, I think it is better to use Remedy API or ARSperl to Create a
ticket
since I don't know how
the Remedy process would react if they got temporay "locked" out due
to a
"For Update".






EVANSON_MATTHEW@LILLY.COM@LISTSERV.VISTAIT.COM> on 03/29/2001 12:29:08
PM

Please respond to "Action Request System discussion list(ARSList)"


Sent by: "Action Request System discussion list(ARSList)"



To: ARSLIST@LISTSERV.VISTAIT.COM
cc:

Subject: Re: Remedy and Cold Fusion



I don't know about other databases, but you can do this with oracle.

SELECT nextid
FROM arschema
WHERE name = 'Schema Name'
FOR UPDATE;

Note the FOR UPDATE clause. You can then use that number to create
your
ticket, etc. Also update next id.

Remedy will not be able to get the next id until you commit.

If you forget to commit and leave your connection open, remedy will
hang
(and probably timeout) without submitting.

I think this standard SQL and it will work with other dbs as well.

--matt





Greg Gibson

To:

Sent by: "Action
ARSLIST@LISTSERV.VISTAI
Request System T.COM

discussion cc:

list(ARSList)" Subject:

Cold
IT.COM> Fusion



03/29/01 02:44 PM

Please respond to

"Action Request System

discussion

list(ARSList)"








**

I don't really know, here is my guess.

When they need a new Next Id, each Remedy process must ask the
traffic
control process (arservtcd)
for a Next Id. Arservtcd is probably the only process allowed to
manage
(i.e select, update) the Next Id
field.







Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
03/29/2001 10:17:41 AM

Please respond to "Action Request System discussion list(ARSList)"


Sent by: "Action Request System discussion list(ARSList)"



To: ARSLIST@LISTSERV.VISTAIT.COM
cc:

Subject: Re: Remedy and Cold Fusion


**

Greg,
Then tell me how Remedy doing this ( from prev. mail )
> I just want to know how Remedy solving this concurency issue (
> NextID ) when
> more than one user creating calls at the same time?
> Regards..

Ravi





Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001
01:46:42
PM

Please respond to "Action Request System discussion list(ARSList)"


Sent by: "Action Request System discussion list(ARSList)"



To: ARSLIST@LISTSERV.VISTAIT.COM
cc:
Subject: Re: Remedy and Cold Fusion


**

Wrong.
example.
Your app and Remedy get the Next Id value at the same time. Both
apps
think they have the correct value.
Both apps use the same Id and both will increment and update Next Id.




Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
03/29/2001 08:15:12 AM

Please respond to "Action Request System discussion list(ARSList)"


Sent by: "Action Request System discussion list(ARSList)"



To: ARSLIST@LISTSERV.VISTAIT.COM
cc:

Subject: Re: Remedy and Cold Fusion


**

Then, no problem using CF. I don't see any NEW problem using CF and
Remedy
together, because DB will take care of Next ID issue. Or, You can set
up
reocrd
lock, so the other transaction will wait for Next ID
Regards..
Ravi





Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001
12:00:44
PM

Please respond to "Action Request System discussion list(ARSList)"


Sent by: "Action Request System discussion list(ARSList)"



To: ARSLIST@LISTSERV.VISTAIT.COM
cc:
Subject: Re: Remedy and Cold Fusion


**

Transaction control in the database.

--
Jarl Groneng
jarl@nextra.com
http://www.arutil.com


> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy
> Sent: 29. mars 2001 17:31
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> I just want to know how Remedy solving this concurency issue (
> NextID ) when
> more than one user creating calls at the same time?
> Regards..
>
>
>
>
>
> Greg Gibson @LISTSERV.VISTAIT.COM> on
> 03/28/2001 07:01:30
> PM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> Yes it can but, if you use SQL to modify NEXT ID, you have to be
concerned
> that you are not modifying
> NextId at the same time Remedy is trying to modify Next Id.
>
>
>
>
> Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
> 03/28/2001 02:19:58 PM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
>
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> Greg,
> Even that NEXT ID thing can be done with CF or any other web dev.
tool
> Regards..
> Ravi
>
>
>
>
>
> Greg Gibson @LISTSERV.VISTAIT.COM> on
03/28/2001
> 06:15:49
> PM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> You do NOT want to use Cold Fusion or any other product to "INSERT"
a
new
> ticket.
> You DO want to use ARSperl or the API to create a new ticket.
That's
> because their are other factors, i.e.
> the next Ticket id number is stored in Remedy tables.
>
>
>
>
> Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
> 03/28/2001 01:10:48 PM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
>
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> Beth,
> It's doable and we're planing to use web app developed with CF or
Vis.
> IntDev.
> ( using the existing Remedy DB), so that we can eliminate Remedy Lic
fee
> every
> year.
> You can do Inserts, Updates and deletes with Coldfusion ( you nedd
CF app
> server
> too). But, you might miss all tose notification events, and you have
to
> mimic
> all Remedy inserts during a call insert into a form. I mean Remedy
inserts
> the
> records to more than one for form( a HD call goes to two forms), so
you
> have to
> be careful to impliment the entire functionality.
> Regards...
> Ravi
>
>
>
>
>
> Mac McMillan @LISTSERV.VISTAIT.COM> on
03/28/2001
> 04:49:02 PM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
> Subject: Remedy and Cold Fusion
>
>
> **
>
> We are attempting to provide a web-based user tool using Cold
Fusion.
>
> Has anyone ever been able to read and submit request through Cold
Fusion?
> Our developer is building a "read-only" view reading directly from
the
> underlying database tables, but we want users to be able to use the
> interface just like the ARS User Client. (same functionality and
> appearance).
>
> Advise??
>
> Bethel McMillan (Mac)
> Applications Specialist - Remedy
> Xypoint Corporation
>
> (206) 674-1094
> (253) 208-2164 (cell)
>
> http://www.xypoint.com
>
> ______
> _______________________
>
>
>
>
>
>
>
> You may also control your subscription options, including
UNSUBSCRIBE, at
> www.ARSLIST.org
>
> ______
> _______________________
>
>
>
>
>
>
> You may also control your subscription options, including
UNSUBSCRIBE, at
> www.ARSLIST.org
>
> ______
> _______________________
>
>
>
>
>
> You may also control your subscription options, including
UNSUBSCRIBE, at
> www.ARSLIST.org
>
> ______
> _______________________
>
>
>
>
> You may also control your subscription options, including
UNSUBSCRIBE, at
> www.ARSLIST.org
>
> ______
> _______________________
>
>
>
> You may also control your subscription options, including
UNSUBSCRIBE, at
> www.ARSLIST.org
>
> ______
> _______________________
>
>
> You may also control your subscription options, including
> UNSUBSCRIBE, at www.ARSLIST.org
>
>

__________
___________________






You may also control your subscription options, including UNSUBSCRIBE,
at
www.ARSLIST.org

__________
___________________





You may also control your subscription options, including UNSUBSCRIBE,
at
www.ARSLIST.org

__________
___________________




You may also control your subscription options, including UNSUBSCRIBE,
at
www.ARSLIST.org

__________
___________________



You may also control your subscription options, including UNSUBSCRIBE,
at
www.ARSLIST.org

__________
___________________


You may also control your subscription options, including UNSUBSCRIBE,
at
www.ARSLIST.org

_____________________________

Hi,

Basically, all transactions are queued and processed in the order received.
You get Next ID updated in the moment when single transaction is completed.
From the DB point of view, ARS behaves as a single entity, so no place for
confusion there.
It is not tcd talking to the db.

HTH,

Nicky Madjarov
Intellico Solutions, Inc.

1507 Hermitage Pk. Dr.
Hermitage, TN 37076
Phone: (615) 883 7591
Mobil : (201) 747 8672
Pager: 2017478672@mobile.att.net
e-mail: nickym@intellicosolutions.net
http://www.intellicosolutions.net
----- Original Message -----
From: "Greg Gibson"
To:
Sent: Thursday, March 29, 2001 1:44 PM
Subject: Re: Remedy and Cold Fusion


> **
>
> I don't really know, here is my guess.
>
> When they need a new Next Id, each Remedy process must ask the traffic
> control process (arservtcd)
> for a Next Id. Arservtcd is probably the only process allowed to manage
> (i.e select, update) the Next Id
> field.
>
>
>
>
>
>
>
> Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
> 03/29/2001 10:17:41 AM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
>
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> Greg,
> Then tell me how Remedy doing this ( from prev. mail )
> > I just want to know how Remedy solving this concurency issue (
> > NextID ) when
> > more than one user creating calls at the same time?
> > Regards..
>
> Ravi
>
>
>
>
>
> Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001
> 01:46:42
> PM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> Wrong.
> example.
> Your app and Remedy get the Next Id value at the same time. Both apps
> think they have the correct value.
> Both apps use the same Id and both will increment and update Next Id.
>
>
>
>
> Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
> 03/29/2001 08:15:12 AM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
>
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> Then, no problem using CF. I don't see any NEW problem using CF and Remedy
> together, because DB will take care of Next ID issue. Or, You can set up
> reocrd
> lock, so the other transaction will wait for Next ID
> Regards..
> Ravi
>
>
>
>
>
> Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001
12:00:44
> PM
>
> Please respond to "Action Request System discussion list(ARSList)"
>
>
> Sent by: "Action Request System discussion list(ARSList)"
>
>
>
> To: ARSLIST@LISTSERV.VISTAIT.COM
> cc:
> Subject: Re: Remedy and Cold Fusion
>
>
> **
>
> Transaction control in the database.
>
> --
> Jarl Groneng
> jarl@nextra.com
> http://www.arutil.com
>
>
> > -----Original Message-----
> > From: Action Request System discussion list(ARSList)
> > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy
> > Sent: 29. mars 2001 17:31
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Re: Remedy and Cold Fusion
> >
> >
> > **
> >
> > I just want to know how Remedy solving this concurency issue (
> > NextID ) when
> > more than one user creating calls at the same time?
> > Regards..
> >
> >
> >
> >
> >
> > Greg Gibson @LISTSERV.VISTAIT.COM> on
> > 03/28/2001 07:01:30
> > PM
> >
> > Please respond to "Action Request System discussion list(ARSList)"
> >
> >
> > Sent by: "Action Request System discussion list(ARSList)"
> >
> >
> >
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > cc:
> > Subject: Re: Remedy and Cold Fusion
> >
> >
> > **
> >
> > Yes it can but, if you use SQL to modify NEXT ID, you have to be
> concerned
> > that you are not modifying
> > NextId at the same time Remedy is trying to modify Next Id.
> >
> >
> >
> >
> > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
> > 03/28/2001 02:19:58 PM
> >
> > Please respond to "Action Request System discussion list(ARSList)"
> >
> >
> > Sent by: "Action Request System discussion list(ARSList)"
> >
> >
> >
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > cc:
> >
> > Subject: Re: Remedy and Cold Fusion
> >
> >
> > **
> >
> > Greg,
> > Even that NEXT ID thing can be done with CF or any other web dev. tool
> > Regards..
> > Ravi
> >
> >
> >
> >
> >
> > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001
> > 06:15:49
> > PM
> >
> > Please respond to "Action Request System discussion list(ARSList)"
> >
> >
> > Sent by: "Action Request System discussion list(ARSList)"
> >
> >
> >
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > cc:
> > Subject: Re: Remedy and Cold Fusion
> >
> >
> > **
> >
> > You do NOT want to use Cold Fusion or any other product to "INSERT" a
> new
> > ticket.
> > You DO want to use ARSperl or the API to create a new ticket. That's
> > because their are other factors, i.e.
> > the next Ticket id number is stored in Remedy tables.
> >
> >
> >
> >
> > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on
> > 03/28/2001 01:10:48 PM
> >
> > Please respond to "Action Request System discussion list(ARSList)"
> >
> >
> > Sent by: "Action Request System discussion list(ARSList)"
> >
> >
> >
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > cc:
> >
> > Subject: Re: Remedy and Cold Fusion
> >
> >
> > **
> >
> > Beth,
> > It's doable and we're planing to use web app developed with CF or Vis.
> > IntDev.
> > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee
> > every
> > year.
> > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF
app
> > server
> > too). But, you might miss all tose notification events, and you have to
> > mimic
> > all Remedy inserts during a call insert into a form. I mean Remedy
> inserts
> > the
> > records to more than one for form( a HD call goes to two forms), so you
> > have to
> > be careful to impliment the entire functionality.
> > Regards...
> > Ravi
> >
> >
> >
> >
> >
> > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001
> > 04:49:02 PM
> >
> > Please respond to "Action Request System discussion list(ARSList)"
> >
> >
> > Sent by: "Action Request System discussion list(ARSList)"
> >
> >
> >
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > cc:
> > Subject: Remedy and Cold Fusion
> >
> >
> > **
> >
> > We are attempting to provide a web-based user tool using Cold Fusion.
> >
> > Has anyone ever been able to read and submit request through Cold
Fusion?
> > Our developer is building a "read-only" view reading directly from the
> > underlying database tables, but we want users to be able to use the
> > interface just like the ARS User Client. (same functionality and
> > appearance).
> >
> > Advise??
> >
> > Bethel McMillan (Mac)
> > Applications Specialist - Remedy
> > Xypoint Corporation
> >
> > (206) 674-1094
> > (253) 208-2164 (cell)
> >
> > http://www.xypoint.com
> >
> > ______
> > _______________________
> >
> >
> >
> >
> >
> >
> >
> > You may also control your subscription options, including UNSUBSCRIBE,
at
> > www.ARSLIST.org
> >
> > ______
> > _______________________
> >
> >
> >
> >
> >
> >
> > You may also control your subscription options, including UNSUBSCRIBE,
at
> > www.ARSLIST.org
> >
> > ______
> > _______________________
> >
> >
> >
> >
> >
> > You may also control your subscription options, including UNSUBSCRIBE,
at
> > www.ARSLIST.org
> >
> > ______
> > _______________________
> >
> >
> >
> >
> > You may also control your subscription options, including UNSUBSCRIBE,
at
> > www.ARSLIST.org
> >
> > ______
> > _______________________
> >
> >
> >
> > You may also control your subscription options, including UNSUBSCRIBE,
at
> > www.ARSLIST.org
> >
> > ______
> > _______________________
> >
> >
> > You may also control your subscription options, including
> > UNSUBSCRIBE, at www.ARSLIST.org
> >
> >
>
>
________________
_____________
>
>
>
>
>
>
> You may also control your subscription options, including UNSUBSCRIBE, at
> www.ARSLIST.org
>
>
________________
_____________
>
>
>
>
>
> You may also control your subscription options, including UNSUBSCRIBE, at
> www.ARSLIST.org
>
>
________________
_____________
>
>
>
>
> You may also control your subscription options, including UNSUBSCRIBE, at
> www.ARSLIST.org
>
>
________________
_____________
>
>
>
> You may also control your subscription options, including UNSUBSCRIBE, at
> www.ARSLIST.org
>
>
________________
_____________
>

> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________

**

Beth,
It's doable and we're planing to use web app developed with CF or Vis. IntDev.
( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every
year.
You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server
too). But, you might miss all tose notification events, and you have to mimic
all Remedy inserts during a call insert into a form. I mean Remedy inserts the
records to more than one for form( a HD call goes to two forms), so you have to
be careful to impliment the entire functionality.
Regards...
Ravi





Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001
04:49:02 PM

Please respond to "Action Request System discussion list(ARSList)"


Sent by: "Action Request System discussion list(ARSList)"



To: ARSLIST@LISTSERV.VISTAIT.COM
cc:
Subject: Remedy and Cold Fusion


**

We are attempting to provide a web-based user tool using Cold Fusion.

Has anyone ever been able to read and submit request through Cold Fusion?
Our developer is building a "read-only" view reading directly from the
underlying database tables, but we want users to be able to use the
interface just like the ARS User Client. (same functionality and
appearance).

Advise??

Bethel McMillan (Mac)
Applications Specialist - Remedy
Xypoint Corporation

(206) 674-1094
(253) 208-2164 (cell)

http://www.xypoint.com

_____________________________



You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________



_____________________________

**

Hi Bathel,

It's very hard to do it using Cold Fusion 'cause you have to know every
little detail about how remedy stores data in the database tables.

Even if you did that, you can not guarantee compatibility with other
versions of remedy because the way remedy stores data in the database is not
documented, so remedy can change it anytime, and in that case your
application will stop working if you decided to use that new version of
remedy. It's like the old game that Microsoft used to play by using
undocumented functions in their Windows and Office applications and then
used this to make DR-DOS incompatible with Windows.

Anyway, as far as I know, you have two choices here:
1. Using Perl CGI, with ARSPerl
2. Using ASP, with www.croomweb.com
3. Using remedy web products (I don't think you wanna do that).

Your Cold Fusion programmer should find using ARSPerl very easy.

Best regards,

Ashraf Elrefaey
Remedy Consultant
Workflow Solutions Ltd
* Phone: +64 4 385 2885
* Cellular: +64 21 377523
* Fax: +64 4 385 2911
* E-Mail: mailto:refaey@workflow.co.nz
1 Webpage: http://www.workflow.co.nz


-----Original Message-----
From: Mac McMillan [mailto:BMcMillan@XYPOINT.COM]
Sent: Thu, 29 March 2001 08:49
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Remedy and Cold Fusion


**

We are attempting to provide a web-based user tool using Cold Fusion.

Has anyone ever been able to read and submit request through Cold Fusion?
Our developer is building a "read-only" view reading directly from the
underlying database tables, but we want users to be able to use the
interface just like the ARS User Client. (same functionality and
appearance).

Advise??

Bethel McMillan (Mac)
Applications Specialist - Remedy
Xypoint Corporation

(206) 674-1094
(253) 208-2164 (cell)

http://www.xypoint.com

________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________



_____________________________