RE: [Arsperl-users] Remedy Query to SQL

[Bowman, B. A <Bow...@st...>]

Thanks Jeff.  I guess I'll have to do it myself.  I was hoping that it =
was done before :)

Brent

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...]On Behalf Of Jeff Murphy
Sent: Thursday, April 07, 2005 2:43 PM
To: ars...@ar...
Subject: RE: [Arsperl-users] Remedy Query to SQL


On Thu, 2005-04-07 at 14:16 -0400, Bowman, Brent A wrote:
> Is this the only way?  How does remedy do it.  And how do I turn =
logging on from the same perl script?  Also, how do I know that the log =
entry is from my query and not from another users' request?  Really, the =
algorithm would be better here.


you can examine a query and derive the algorithm. i think they replace
spaces and non-alphanum characters in field and form names with
underscores. some forms are special ("User" is "USER_X").=20

so if you have "My Form #1" and it contains a field "Phone #" and
"Entry-Id". the view should be "MY_FORM__1" and it should contain
"PHONE__" and "ENTRY_ID".

you'll need to grant your oracle users permission to query the view.

jeff




-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users