Re: [Arsperl-users] Remedy Query to SQL

[Michael A. <mic...@gm...>]

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 reme=
dy
> qualification directly to an SQL query that I can use with oracle.  Is th=
ere
> 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
>