[Arsperl-users] How to Connect to ARS Remedy Database

[Lamb J. <jos...@ya...>]

Hello,

How do I connect to a Remedy database and query the
information in a form? 

In the Remedy::Arstools I found the following
statement:
 You should get a read-only database account with
select access on the aradmin views, and use something
like DBIx::YAWM to query the database directly.

Does even one have an example using DBIx::YAWM or some
other common method?



The following did not work:
use strict;
use DBI;


my  $dbh = DBI->connect('dbi:ODBC:Remedy',
'user','pass' ) or die "Cannot connect\n";
my $statement = "SELECT
    Assigned_To_Group_
FROM
    HelpDesk
WHERE
   Assigned_To_Group_ LIKE 'NFS%'";
     
my $sth = $dbh->prepare($statement) or die "Cannot
prepare\n";




Joseph Lamb

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com