RE: [Arsperl-users] Remedy Query to SQL

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

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.

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...]On Behalf Of Michael Armbrecht
Sent: Thursday, April 07, 2005 2:10 PM
To: ars...@ar...
Subject: Re: [Arsperl-users] Remedy Query to SQL


On Apr 7, 2005 5:53 PM, Bowman, Brent A <Bow...@st...> wrote:
> I want to get the conversion without ever querying the ARS.  I want to =
go directly to Oracle, but let the user input a Remedy style query.

1.) Turn on SQL Logging on your ARS Server.
2.) Run your query in ARS
3.) Turn SQL Logging off.
4.) Check SQL Log file and you will see the SQL that ARS generated
from your ARS Query. Use this for your application.

M.


> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...]On Behalf Of Covert, Jack
> Sent: Thursday, April 07, 2005 12:01 PM
> To: ars...@ar...
> Subject: RE: [Arsperl-users] Remedy Query to SQL
>=20
> How about running the query with SQL logging on?
>=20
> -----Original Message-----
> From: Bowman, Brent A [mailto:Bow...@st...]
> Sent: Thursday, April 07, 2005 7:09 AM
> To: ars...@ar...
> Subject: [Arsperl-users] Remedy Query to SQL
>=20
> Listers,
>=20
> I am wondering if there is a simple algorithm available to convert a =
remedy
> qualification directly to an SQL query that I can use with oracle.  Is =
there
> something available in arsperl?
>=20
> Thanks,
>=20
> Brent Bowman
>=20
> -------------------------------------------------------
> 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_ide95&alloc_id=14396&op=3Dclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>=20
> -------------------------------------------------------
> 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
>=20
> -------------------------------------------------------
> 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_ide95&alloc_id=14396&opclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>



-------------------------------------------------------
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_ide95&alloc_id=14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users