arsperl-users — Discussions regarding the use of ARSperl

[Arsperl-users] DBI error on bind_columns

[Kelly L. <kel...@ra...>]

G'day all,
=20
This is an odd one.  I have a script that uses DBD:ODBC to connect to an =
SQL
Server database and run some queries.
=20
I modified one of the queries, adding another table and field to the =
total:
=20
Before
-------------
select t1.plannbr_fi, t1.domain_ind, t2.fname, t2.lname, t3.fname, =
t3.lname,
t4.gso_code_alpha,
                t5.notepad, t6.market_region_name
        from (((((plan_base t1 LEFT OUTER JOIN staff_gso t2 ON
t1.id_sales_rep =3D t2.rep_id_idnty)
                LEFT OUTER JOIN staff_gso t3 ON t1.id_acct_mgr =3D
t3.rep_id_idnty)
                LEFT OUTER JOIN gso_offices t4 ON t1.gso_idnty =3D
t4.gso_idnty)
                LEFT OUTER JOIN plan_notepad t5 ON t1.plannbr_idnty =3D
t5.plannbr_idnty)
                LEFT OUTER JOIN regions_ops t6 ON t1.ops_region_idnty =
=3D
t6.ops_region_idnty)
        where ...
=20
After
-------------
select t1.plannbr_fi, t1.domain_ind, t2.fname, t2.lname, t3.fname, =
t3.lname,
t4.gso_code_alpha,
                t5.notepad, t6.market_region_name, t7.bus_name
        from ((((((plan_base t1 LEFT OUTER JOIN staff_gso t2 ON
t1.id_sales_rep =3D t2.rep_id_idnty)
                LEFT OUTER JOIN staff_gso t3 ON t1.id_acct_mgr =3D
t3.rep_id_idnty)
                LEFT OUTER JOIN gso_offices t4 ON t1.gso_idnty =3D
t4.gso_idnty)
                LEFT OUTER JOIN plan_notepad t5 ON t1.plannbr_idnty =3D
t5.plannbr_idnty)
                LEFT OUTER JOIN regions_ops t6 ON t1.ops_region_idnty =
=3D
t6.ops_region_idnty)
->             LEFT OUTER JOIN specialty_risk_names t7 ON t1.id_tpa =3D
t7.srisk_idnty)
        where ...
=20
After adding this line into the query, the script no longer ran, giving =
me
the following error:
bind_columns called with 9 refs when 10 needed. at =
C:/Perl/site/lib/DBI.pm
line
1787.
=20
Here's that section of code in DBI.pm:
=20
   sub bind_columns {
 my $sth =3D shift;
 my $fields =3D $sth->FETCH('NUM_OF_FIELDS') || 0;
 if ($fields <=3D 0 && !$sth->{Active}) {
     return $sth->set_err(1, "Statement has no result columns to bind"
      ." (perhaps you need to successfully call execute first)");
 }
 # Backwards compatibility for old-style call with attribute hash
 # ref as first arg. Skip arg if undef or a hash ref.
 my $attr;
 $attr =3D shift if !defined $_[0] or ref($_[0]) eq 'HASH';
=20
1787-> die "bind_columns called with ".@_." refs when $fields needed."
     if @_ !=3D $fields;
 my $idx =3D 0;
 $sth->bind_col(++$idx, shift, $attr) or return
     while (@_);
 return 1;
    }

Is there a max on the fields that can be passed?
=20
=20
=20
Kelly Logan
Rapid Technologies
(313) 645-4552
kel...@ra...
=20

RE: [Arsperl-users] Getting closer...

[Steve M. <ste...@ch...>]

Please disregard, I've gotten past this...

  _____  

From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Steve McDonald
Sent: Tuesday, May 17, 2005 1:37 PM
To: ars...@ar...
Subject: RE: [Arsperl-users] Getting closer...


I neglected to add the lines following the bootstrap error.  They point to
the "t" files and all are erroring on the "use ARS" line.
 
   Compilation failed in require at t/00connect.t line 12.
   BEGIN failed--compilation aborted at t/00connect.t line 12.
   t/00connect..........dubious
           Test returned status 2 (wstat 512, 0x200)
 
Do I need to have a path set somewhere?

  _____  

From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Steve McDonald
Sent: Monday, May 16, 2005 7:23 AM
To: ars...@ar...
Subject: [Arsperl-users] Getting closer...


Good morning all,
 
I'm getting closer.  
 
"Makefile.PL" works
"make" works
"make test" does not
 
Here's one of the 13 nearly identical errors:
 
  - ARS object version 1.83 does not match bootstrap parameter 1.8001 at
/gnu/lib/perl5/5.6.0/sun4-solaris/DynaLoader.pm line 219
 
Here's my environment:
  - SunOS 5.8
  - Perl v5.005_03
  - ARS v6.3
  - API v6.3
  - ARSPerl v1.83
 
Thanks in advance for your help!
 
 
Steve

RE: [Arsperl-users] Getting closer...

[Steve M. <ste...@ch...>]

I neglected to add the lines following the bootstrap error.  They point to
the "t" files and all are erroring on the "use ARS" line.
 
   Compilation failed in require at t/00connect.t line 12.
   BEGIN failed--compilation aborted at t/00connect.t line 12.
   t/00connect..........dubious
           Test returned status 2 (wstat 512, 0x200)
 
Do I need to have a path set somewhere?

  _____  

From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Steve McDonald
Sent: Monday, May 16, 2005 7:23 AM
To: ars...@ar...
Subject: [Arsperl-users] Getting closer...


Good morning all,
 
I'm getting closer.  
 
"Makefile.PL" works
"make" works
"make test" does not
 
Here's one of the 13 nearly identical errors:
 
  - ARS object version 1.83 does not match bootstrap parameter 1.8001 at
/gnu/lib/perl5/5.6.0/sun4-solaris/DynaLoader.pm line 219
 
Here's my environment:
  - SunOS 5.8
  - Perl v5.005_03
  - ARS v6.3
  - API v6.3
  - ARSPerl v1.83
 
Thanks in advance for your help!
 
 
Steve

[Arsperl-users] Getting closer...

[Steve M. <ste...@ch...>]

Good morning all,
 
I'm getting closer.  
 
"Makefile.PL" works
"make" works
"make test" does not
 
Here's one of the 13 nearly identical errors:
 
  - ARS object version 1.83 does not match bootstrap parameter 1.8001 at
/gnu/lib/perl5/5.6.0/sun4-solaris/DynaLoader.pm line 219
 
Here's my environment:
  - SunOS 5.8
  - Perl v5.005_03
  - ARS v6.3
  - API v6.3
  - ARSPerl v1.83
 
Thanks in advance for your help!
 
 
Steve

RE: [Arsperl-users] ars_LoadQualification problem...

[<Chr...@Ve...>]

David,

Thanks!  Swapping in the Field ID worked like a champ.  I must have had my
blinders on.  :-/

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...]On Behalf Of David Adams
Sent: Friday, May 13, 2005 5:37 AM
To: ars...@ar...
Subject: Re: [Arsperl-users] ars_LoadQualification problem...


Chris,

I believe that ars_LoadQualification uses the field label rather than the 
field name, though that doesn't explain what you're seeing.

You could try the workaround of replacing 'Login Name +' with the fieldId in

single quotes.

David Adams
Corporate Information Services
Information Systems Services
University of Southampton

----- Original Message ----- 
From: <Chr...@Ve...>
To: <ars...@ar...>
Sent: Thursday, May 12, 2005 10:30 PM
Subject: [Arsperl-users] ars_LoadQualification problem...


> Hi,
>
> Bizarre problem.  I have a program I wrote on Windows (ActiveState Perl
> 5.8/ARSperl 1.82) that worked fine (for more than 1 week with hundreds of
> entries).  After putting it on the UNIX box (Solaris 8/Perl 5.8/ARSperl
> 1.83) this happens...
>
> I'm iterating through a list of logins and calling ars_LoadQualication as
> follows for every login:
>
> $queryForThis = "'Login Name +' = \"$loginOld\"";
> ( $q = ars_LoadQualifier( $c, "User", $queryForThis ) ) || die 
> $ars_errstr;
>
> This always works on the first time.  However, on the second try it will
> always fail and pass back:
> [ERROR] Unknown field referenced in query line (position 14   ('Login Name
> +'^=...
>
> I know that is the name of the field on User.  I can paste the query line
> directly into the advanced search bar (immediately before it fails) on 
> User
> and it works every time.  I tried to set $q and $c to undef after using 
> them
> but that didn't work either.  Any ideas?  The boss wants this run off the
> UNIX box and not a PC...
>
> --Chris
> ___________________________________________________________________
> The information contained in this message and any attachment may be
> proprietary, confidential, and privileged or subject to the work
> product doctrine and thus protected from disclosure.  If the reader
> of this message is not the intended recipient, or an employee or
> agent responsible for delivering this message to the intended
> recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please notify me
> immediately by replying to this message and deleting it and all
> copies and backups thereof.  Thank you.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 



-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] ars_LoadQualification problem...

[David A. <D.J...@so...>]

Chris,

I believe that ars_LoadQualification uses the field label rather than the 
field name, though that doesn't explain what you're seeing.

You could try the workaround of replacing 'Login Name +' with the fieldId in 
single quotes.

David Adams
Corporate Information Services
Information Systems Services
University of Southampton

----- Original Message ----- 
From: <Chr...@Ve...>
To: <ars...@ar...>
Sent: Thursday, May 12, 2005 10:30 PM
Subject: [Arsperl-users] ars_LoadQualification problem...


> Hi,
>
> Bizarre problem.  I have a program I wrote on Windows (ActiveState Perl
> 5.8/ARSperl 1.82) that worked fine (for more than 1 week with hundreds of
> entries).  After putting it on the UNIX box (Solaris 8/Perl 5.8/ARSperl
> 1.83) this happens...
>
> I'm iterating through a list of logins and calling ars_LoadQualication as
> follows for every login:
>
> $queryForThis = "'Login Name +' = \"$loginOld\"";
> ( $q = ars_LoadQualifier( $c, "User", $queryForThis ) ) || die 
> $ars_errstr;
>
> This always works on the first time.  However, on the second try it will
> always fail and pass back:
> [ERROR] Unknown field referenced in query line (position 14   ('Login Name
> +'^=...
>
> I know that is the name of the field on User.  I can paste the query line
> directly into the advanced search bar (immediately before it fails) on 
> User
> and it works every time.  I tried to set $q and $c to undef after using 
> them
> but that didn't work either.  Any ideas?  The boss wants this run off the
> UNIX box and not a PC...
>
> --Chris
> ___________________________________________________________________
> The information contained in this message and any attachment may be
> proprietary, confidential, and privileged or subject to the work
> product doctrine and thus protected from disclosure.  If the reader
> of this message is not the intended recipient, or an employee or
> agent responsible for delivering this message to the intended
> recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please notify me
> immediately by replying to this message and deleting it and all
> copies and backups thereof.  Thank you.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 

[Arsperl-users] ars_LoadQualification problem...

[<Chr...@Ve...>]

Hi,

Bizarre problem.  I have a program I wrote on Windows (ActiveState Perl
5.8/ARSperl 1.82) that worked fine (for more than 1 week with hundreds of
entries).  After putting it on the UNIX box (Solaris 8/Perl 5.8/ARSperl
1.83) this happens...

I'm iterating through a list of logins and calling ars_LoadQualication as
follows for every login:

$queryForThis = "'Login Name +' = \"$loginOld\"";
( $q = ars_LoadQualifier( $c, "User", $queryForThis ) ) || die $ars_errstr;

This always works on the first time.  However, on the second try it will
always fail and pass back:
 [ERROR] Unknown field referenced in query line (position 14   ('Login Name
+'^=...  

I know that is the name of the field on User.  I can paste the query line
directly into the advanced search bar (immediately before it fails) on User
and it works every time.  I tried to set $q and $c to undef after using them
but that didn't work either.  Any ideas?  The boss wants this run off the
UNIX box and not a PC...

--Chris  
___________________________________________________________________
The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work
product doctrine and thus protected from disclosure.  If the reader
of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify me
immediately by replying to this message and deleting it and all
copies and backups thereof.  Thank you.

Re: [Arsperl-users] ars_Export

[David A. <D.J...@so...>]

I have now.  I get:

[ERROR] Invalid number of arguments (ARERR #80000)
[ERROR] Cannot open catalog: Message number = 132 () (ARERR #132)

When I try

my $val = ars_Export($c,"",&ARS::AR_VUI_TYPE_NONE,$type,$name, undef,undef);

I get:

[ERROR] Unknown export type (ARERR #80009)

I've tried 0 and and &ARS::AR_EXPORT_FORMAT_AR_DEF in place of that first 
undef with similar results.

David Adams
Corporate Information Services
Information Systems Services
University of Southampton

----- Original Message ----- 
From: <jar...@te...>
To: <ars...@ar...>
Sent: Tuesday, May 10, 2005 6:21 AM
Subject: RE: [Arsperl-users] ars_Export


>
> The documentation is not updated to v6 I think.
>
> Have you tried:
> my $val = ars_Export($c,"",&ARS::AR_VUI_TYPE_NONE,$type,$name, undef);
>
> --
> Jarl
>
>> -----Original Message-----
>> From: ars...@ar...
>> [mailto:ars...@ar...]On Behalf Of David Adams
>> Sent: 9. mai 2005 15:26
>> To: ARSperl mailling list
>> Subject: [Arsperl-users] ars_Export
>>
>>
>> I am trying to get ARSperl 1.83 compiled with the 6.01 API
>> working against a
>> 6.01 server.
>>
>> The example script DumpSetup.pl supplied with 1.83 belongs to
>> the previous
>> century and calls ars_Export with too few arguments.
>>
>> When I follow the supplied HTML manual and try:
>>
>> my $val = ars_Export($c,"",&ARS::AR_VUI_TYPE_NONE,$type,$name);
>> print $ars_errstr, "\n";
>>
>> Then I get:
>>
>> [ERROR] Unknown object lock level specified (User) (ARERR #8832)
>>
>> (The same ars_Export call works fine for ARSperl 1.8002 with
>> the 5.1 API
>> library against the same server.)
>>
>> Is this simply a case of the documentation lagging behind, or
>> is there a
>> bug?
>>
>> David Adams
>> Corporate Information Services
>> Information Systems Services
>> University of Southampton
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: NEC IT Guy Games.
>> Get your fingers limbered up and give it your best shot. 4
>> great events, 4
>> opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
>> win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
>> _______________________________________________
>> Arsperl-users mailing list
>> Ars...@ar...
>> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_ids93&alloc_id281&opÌk
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
> 

RE: [Arsperl-users] ars_Export

[<jar...@te...>]

The documentation is not updated to v6 I think.

Have you tried:
my $val =3D ars_Export($c,"",&ARS::AR_VUI_TYPE_NONE,$type,$name, undef);

--
Jarl

> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...]On Behalf Of David Adams
> Sent: 9. mai 2005 15:26
> To: ARSperl mailling list
> Subject: [Arsperl-users] ars_Export
>=20
>=20
> I am trying to get ARSperl 1.83 compiled with the 6.01 API=20
> working against a=20
> 6.01 server.
>=20
> The example script DumpSetup.pl supplied with 1.83 belongs to=20
> the previous=20
> century and calls ars_Export with too few arguments.
>=20
> When I follow the supplied HTML manual and try:
>=20
> my $val =3D ars_Export($c,"",&ARS::AR_VUI_TYPE_NONE,$type,$name);
> print $ars_errstr, "\n";
>=20
> Then I get:
>=20
> [ERROR] Unknown object lock level specified (User) (ARERR #8832)
>=20
> (The same ars_Export call works fine for ARSperl 1.8002 with=20
> the 5.1 API=20
> library against the same server.)
>=20
> Is this simply a case of the documentation lagging behind, or=20
> is there a=20
> bug?
>=20
> David Adams
> Corporate Information Services
> Information Systems Services
> University of Southampton
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best shot. 4=20
> great events, 4
> opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
> win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=3D20
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>=20

RE: [Arsperl-users] ars_Export

[Hutchinson, D. C MSER:E. <Dav...@go...>]

Have not tried 1.83 yet but will try on our test server soon.  Currently
using 1.82 but can't make ARS Documentor work (alas).

Solaris 2.9
ARS 6.0.1
Perl 5.8.6

Am very hopeful that clever people will get ARS Documentor working against
ARS 6 soon - we sure miss it :-)

Regards,
Dave Hutchinson
Middleware Team Leader
Hosting - Application Enabling Services
Common IT Services
Solutions BC - Province of British Columbia
4000 Seymour Place, Victoria BC


-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of David Adams
Sent: May 9, 2005 6:26 AM
To: ARSperl mailling list
Subject: [Arsperl-users] ars_Export


I am trying to get ARSperl 1.83 compiled with the 6.01 API working against a

6.01 server.

The example script DumpSetup.pl supplied with 1.83 belongs to the previous 
century and calls ars_Export with too few arguments.

When I follow the supplied HTML manual and try:

my $val = ars_Export($c,"",&ARS::AR_VUI_TYPE_NONE,$type,$name);
print $ars_errstr, "\n";

Then I get:

[ERROR] Unknown object lock level specified (User) (ARERR #8832)

(The same ars_Export call works fine for ARSperl 1.8002 with the 5.1 API 
library against the same server.)

Is this simply a case of the documentation lagging behind, or is there a 
bug?

David Adams
Corporate Information Services
Information Systems Services
University of Southampton




-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] Install problem - v1.83 on Solaris 9

[Joshua S. <jos...@ya...>]

Hi,

I compiled 1.82 against the 6.0.1 API.  It was the
only way it would find auto/ARS/autosplit.ix.  This
was using Solaris 8 and Perl 5.8.0.

Hope this helps,
Josh.


--- Amir Sedighi <sed...@ya...> wrote:

> Joshua,
> Does that mean you also had to use an older version
> of
> the API, or did you get an older version of ARSperl
> to
> compile properly with 6.3 libraries?  If so, which
> ARSperl version?
> Thanks,
> Amir.
> 
> --- Joshua Schuller <jos...@ya...>
> wrote:
> > Amir,
> > 
> > I had some trouble with a clean install as well. 
> I
> > ended up installing one of the previous versions
> of
> > ARSPerl first and was able to resolve the issue.
> > 
> > Good luck,
> > 
> > JS
> > 
> > 
> > --- Amir Sedighi <sed...@ya...> wrote:
> > > This problem I'm having sounds almost identical
> to
> > > one
> > > discussed earlier by Missi and Mark, but
> following
> > > the
> > > same steps did not resolve my problem.
> > > 
> > > I run perl Makefile.PL and everything works,
> then
> > I
> > > do
> > > a make, and that works without any errors.  Then
> I
> > > run
> > > make test and I get a ton of errors stating
> > > 
> > > Can't locate auto/ARS/autosplit.ix in @INC (@INC
> > > contains:
> > > /export/home/asedighi/ARSperl-1.83/blib/lib
> > > /export/home/asedighi/ARSperl-1.83/blib/arch
> > >
> /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> > >
> /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> > > /export/home/asedighi/perl/lib/5.8.6
> > >
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> > >
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> > > /export/home/asedighi/perl/lib/site_perl/5.8.6
> > >
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> > > /export/home/asedighi/perl/lib/site_perl/5.8.6
> > > /export/home/asedighi/perl/lib/site_perl .
> > >
> /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> > > /export/home/asedighi/perl/lib/5.8.6
> > >
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> > > /export/home/asedighi/perl/lib/site_perl/5.8.6
> > > /export/home/asedighi/perl/lib/site_perl .) at
> > >
> /export/home/asedighi/perl/lib/5.8.6/AutoLoader.pm
> > > line 160.
> > > 
> > > These commands have been run following the make
> > and
> > > before the make test:
> > > 
> > > bash-2.05$  ls -l blib/lib/auto/ARS/
> > > total 0
> > > 
> > > bash-2.05$ perl -e "use AutoSplit;
> > > autosplit("ARS.pm","blib/lib/auto",0,1,1);"
> > > Illegal division by zero at -e line 1.
> > > 
> > > 
> > > Any idea what's wrong here?
> > > 
> > > Thanks,
> > > Amir.
> > > 
> > > 
> > > oh btw
> > > Perl 5.8.6
> > > SunOS 5.9
> > > GNU Make 3.80
> > > ARS 6.3
> > > 
> > > 
> > > 
> > >
> >
>
-------------------------------------------------------
> > > This SF.Net email is sponsored by: NEC IT Guy
> > Games.
> > > Get your fingers limbered up and give it your
> best
> > > shot. 4 great events, 4
> > > opportunities to win big! Highest score wins.NEC
> > IT
> > > Guy Games. Play to
> > > win an NEC 61 plasma display. Visit
> > > http://www.necitguy.com/?r=20
> > > _______________________________________________
> > > Arsperl-users mailing list
> > > Ars...@ar...
> > >
> >
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > > 
> > 
> > 
> > 		
> > Discover Yahoo! 
> > Find restaurants, movies, travel and more fun for
> > the weekend. Check it out! 
> > http://discover.yahoo.com/weekend.html 
> > 
> > 
> > 
> >
>
-------------------------------------------------------
> > This SF.Net email is sponsored by: NEC IT Guy
> Games.
> > Get your fingers limbered up and give it your best
> > shot. 4 great events, 4
> > opportunities to win big! Highest score wins.NEC
> IT
> > Guy Games. Play to
> > win an NEC 61 plasma display. Visit
> > http://www.necitguy.com/?r=20
> > _______________________________________________
> > Arsperl-users mailing list
> > Ars...@ar...
> >
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > 
> 
> 
> 
>
-------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best
> shot. 4 great events, 4
> opportunities to win big! Highest score wins.NEC IT
> Guy Games. Play to
> win an NEC 61 plasma display. Visit
> http://www.necitguy.com/?r=20
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 



		
Discover Yahoo! 
Have fun online with music videos, cool games, IM and more. Check it out! 
http://discover.yahoo.com/online.html

Re: [Arsperl-users] Install problem - v1.83 on Solaris 9

[Amir S. <sed...@ya...>]

Joshua,
Does that mean you also had to use an older version of
the API, or did you get an older version of ARSperl to
compile properly with 6.3 libraries?  If so, which
ARSperl version?
Thanks,
Amir.

--- Joshua Schuller <jos...@ya...> wrote:
> Amir,
> 
> I had some trouble with a clean install as well.  I
> ended up installing one of the previous versions of
> ARSPerl first and was able to resolve the issue.
> 
> Good luck,
> 
> JS
> 
> 
> --- Amir Sedighi <sed...@ya...> wrote:
> > This problem I'm having sounds almost identical to
> > one
> > discussed earlier by Missi and Mark, but following
> > the
> > same steps did not resolve my problem.
> > 
> > I run perl Makefile.PL and everything works, then
> I
> > do
> > a make, and that works without any errors.  Then I
> > run
> > make test and I get a ton of errors stating
> > 
> > Can't locate auto/ARS/autosplit.ix in @INC (@INC
> > contains:
> > /export/home/asedighi/ARSperl-1.83/blib/lib
> > /export/home/asedighi/ARSperl-1.83/blib/arch
> > /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> > /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> > /export/home/asedighi/perl/lib/5.8.6
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> > /export/home/asedighi/perl/lib/site_perl/5.8.6
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> > /export/home/asedighi/perl/lib/site_perl/5.8.6
> > /export/home/asedighi/perl/lib/site_perl .
> > /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> > /export/home/asedighi/perl/lib/5.8.6
> >
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> > /export/home/asedighi/perl/lib/site_perl/5.8.6
> > /export/home/asedighi/perl/lib/site_perl .) at
> > /export/home/asedighi/perl/lib/5.8.6/AutoLoader.pm
> > line 160.
> > 
> > These commands have been run following the make
> and
> > before the make test:
> > 
> > bash-2.05$  ls -l blib/lib/auto/ARS/
> > total 0
> > 
> > bash-2.05$ perl -e "use AutoSplit;
> > autosplit("ARS.pm","blib/lib/auto",0,1,1);"
> > Illegal division by zero at -e line 1.
> > 
> > 
> > Any idea what's wrong here?
> > 
> > Thanks,
> > Amir.
> > 
> > 
> > oh btw
> > Perl 5.8.6
> > SunOS 5.9
> > GNU Make 3.80
> > ARS 6.3
> > 
> > 
> > 
> >
>
-------------------------------------------------------
> > This SF.Net email is sponsored by: NEC IT Guy
> Games.
> > Get your fingers limbered up and give it your best
> > shot. 4 great events, 4
> > opportunities to win big! Highest score wins.NEC
> IT
> > Guy Games. Play to
> > win an NEC 61 plasma display. Visit
> > http://www.necitguy.com/?r=20
> > _______________________________________________
> > Arsperl-users mailing list
> > Ars...@ar...
> >
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > 
> 
> 
> 		
> Discover Yahoo! 
> Find restaurants, movies, travel and more fun for
> the weekend. Check it out! 
> http://discover.yahoo.com/weekend.html 
> 
> 
> 
>
-------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best
> shot. 4 great events, 4
> opportunities to win big! Highest score wins.NEC IT
> Guy Games. Play to
> win an NEC 61 plasma display. Visit
> http://www.necitguy.com/?r=20
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 

[Arsperl-users] ars_Export

[David A. <D.J...@so...>]

I am trying to get ARSperl 1.83 compiled with the 6.01 API working against a 
6.01 server.

The example script DumpSetup.pl supplied with 1.83 belongs to the previous 
century and calls ars_Export with too few arguments.

When I follow the supplied HTML manual and try:

my $val = ars_Export($c,"",&ARS::AR_VUI_TYPE_NONE,$type,$name);
print $ars_errstr, "\n";

Then I get:

[ERROR] Unknown object lock level specified (User) (ARERR #8832)

(The same ars_Export call works fine for ARSperl 1.8002 with the 5.1 API 
library against the same server.)

Is this simply a case of the documentation lagging behind, or is there a 
bug?

David Adams
Corporate Information Services
Information Systems Services
University of Southampton

Re: [Arsperl-users] Install problem - v1.83 on Solaris 9

[Joshua S. <jos...@ya...>]

Amir,

I had some trouble with a clean install as well.  I
ended up installing one of the previous versions of
ARSPerl first and was able to resolve the issue.

Good luck,

JS


--- Amir Sedighi <sed...@ya...> wrote:
> This problem I'm having sounds almost identical to
> one
> discussed earlier by Missi and Mark, but following
> the
> same steps did not resolve my problem.
> 
> I run perl Makefile.PL and everything works, then I
> do
> a make, and that works without any errors.  Then I
> run
> make test and I get a ton of errors stating
> 
> Can't locate auto/ARS/autosplit.ix in @INC (@INC
> contains:
> /export/home/asedighi/ARSperl-1.83/blib/lib
> /export/home/asedighi/ARSperl-1.83/blib/arch
> /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> /export/home/asedighi/perl/lib/5.8.6
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> /export/home/asedighi/perl/lib/site_perl/5.8.6
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> /export/home/asedighi/perl/lib/site_perl/5.8.6
> /export/home/asedighi/perl/lib/site_perl .
> /export/home/asedighi/perl/lib/5.8.6/sun4-solaris
> /export/home/asedighi/perl/lib/5.8.6
>
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
> /export/home/asedighi/perl/lib/site_perl/5.8.6
> /export/home/asedighi/perl/lib/site_perl .) at
> /export/home/asedighi/perl/lib/5.8.6/AutoLoader.pm
> line 160.
> 
> These commands have been run following the make and
> before the make test:
> 
> bash-2.05$  ls -l blib/lib/auto/ARS/
> total 0
> 
> bash-2.05$ perl -e "use AutoSplit;
> autosplit("ARS.pm","blib/lib/auto",0,1,1);"
> Illegal division by zero at -e line 1.
> 
> 
> Any idea what's wrong here?
> 
> Thanks,
> Amir.
> 
> 
> oh btw
> Perl 5.8.6
> SunOS 5.9
> GNU Make 3.80
> ARS 6.3
> 
> 
> 
>
-------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best
> shot. 4 great events, 4
> opportunities to win big! Highest score wins.NEC IT
> Guy Games. Play to
> win an NEC 61 plasma display. Visit
> http://www.necitguy.com/?r=20
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 


		
Discover Yahoo! 
Find restaurants, movies, travel and more fun for the weekend. Check it out! 
http://discover.yahoo.com/weekend.html 

[Arsperl-users] Install problem - v1.83 on Solaris 9

[Amir S. <sed...@ya...>]

This problem I'm having sounds almost identical to one
discussed earlier by Missi and Mark, but following the
same steps did not resolve my problem.

I run perl Makefile.PL and everything works, then I do
a make, and that works without any errors.  Then I run
make test and I get a ton of errors stating

Can't locate auto/ARS/autosplit.ix in @INC (@INC
contains: /export/home/asedighi/ARSperl-1.83/blib/lib
/export/home/asedighi/ARSperl-1.83/blib/arch
/export/home/asedighi/perl/lib/5.8.6/sun4-solaris
/export/home/asedighi/perl/lib/5.8.6/sun4-solaris
/export/home/asedighi/perl/lib/5.8.6
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
/export/home/asedighi/perl/lib/site_perl/5.8.6
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
/export/home/asedighi/perl/lib/site_perl/5.8.6
/export/home/asedighi/perl/lib/site_perl .
/export/home/asedighi/perl/lib/5.8.6/sun4-solaris
/export/home/asedighi/perl/lib/5.8.6
/export/home/asedighi/perl/lib/site_perl/5.8.6/sun4-solaris
/export/home/asedighi/perl/lib/site_perl/5.8.6
/export/home/asedighi/perl/lib/site_perl .) at
/export/home/asedighi/perl/lib/5.8.6/AutoLoader.pm
line 160.

These commands have been run following the make and
before the make test:

bash-2.05$  ls -l blib/lib/auto/ARS/
total 0

bash-2.05$ perl -e "use AutoSplit;
autosplit("ARS.pm","blib/lib/auto",0,1,1);"
Illegal division by zero at -e line 1.


Any idea what's wrong here?

Thanks,
Amir.


oh btw
Perl 5.8.6
SunOS 5.9
GNU Make 3.80
ARS 6.3

Re: [Arsperl-users] RE: Error Compiling ARSperl 1.83

[Jeff M. <jcm...@je...>]

http://sourceforge.net/mailarchive/message.php?msg_id=11553821

On Fri, 2005-04-29 at 09:33 -0700, Steve McDonald wrote:
> I saw Lori's message regarding the make:
> 
> 	Skip blib/lib/artypes.ph (unchanged)
> 
> 	/bin/perl -I/usr/perl5/5.00503/sun4-solaris
> -I/usr/perl5/5.00503 /usr/perl5/5.00503/ExtUtils/xsubpp 
> 
> 	-typemap /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap ARS.xs
> >xstmp.c && mv xstmp.c ARS.c
> 
> 	Error: Cannot parse function definition from ' ARControlStruct *
> ctrl' in ARS.xs, line 989
> 
> 	make: *** [ARS.c] Error 1
> 
> I got the same message this morning. Did anyone have a fix? I just
> resubscribed and was reading yesterday's archives.
> 
> Thanks for your help,
> 
> Steve
> 
> Remedy Applications Programmer
> 
> Choice Hotels International
> 
> 602-953-4955

[Arsperl-users] RE: Error Compiling ARSperl 1.83

[Steve M. <ste...@ch...>]

I saw Lori's message regarding the make:
 
 	Skip blib/lib/artypes.ph (unchanged)
 	/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 /usr/perl5/5.00503/ExtUtils/xsubpp  
 	-typemap /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap ARS.xs >xstmp.c && mv xstmp.c ARS.c
 	Error: Cannot parse function definition from '  ARControlStruct *       ctrl' in ARS.xs, line 989
 	make: *** [ARS.c] Error 1
 
I got the same message this morning.  Did anyone have a fix?  I just resubscribed and was reading yesterday's archives.

Thanks for your help,

 
Steve
Remedy Applications Programmer
Choice Hotels International
602-953-4955

Re: [Arsperl-users] Database connection to populate ARS form

[Thomas W. <tm...@ya...>]

Mark,

I have done this in the past.  You need to have client
software on the Solaris box to connect to SQL Server. 
I used a package called FreeTDS to do this.  Then, I
used the DBD::Sybase module to use DBI to access SQL. 
Since SQL Server was forked from Sybase, the Sybase
module works.

HTH,

Tom Worth
--- Mark Vaughan <mva...@ev...> wrote:
> This is not a specific ARSperl question.
> 
>  
> 
> I am trying to copy data from an MS SQL Server
> database into an ARS
> form.  The perl script is running on a Solaris 5.8
> box with perl 5.6.1
> but the source DB is on a Win2k server.  I have
> installed the DBI module
> from CPAN and read the docs, but I still can't get a
> connection.
> 
>  
> 
> My environment:
> 
> Solaris 5.8
> 
> Perl 5.6.1
> 
> ARSperl: 1.83
> 
> AR API: 6.0
> 
>  
> 
> MS database is running on a Win 2000 Server.
> 
>  
> 
> Any and all help would be greatly appreciated.
> 
>  
> 
> Thanks,
> 
> Mark
> 
>  
> 
> Mark Vaughan
> 
> Programmer III
> 
>  
> 
> Direct: +1 303 802 2426
> 
> Cell: +1 303 601 4434
> 
> Fax: +1 303 802 1420
> 
> mar...@ev...
> <mailto:mar...@ev...> 
> 
> Evolving Systems, Inc. 
> 
> 9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA
> 80112
> 
> www.evolving.com
> 
>  
> 
> This e-mail and any attachments may be confidential
> and/or legally privileged. If you have received this
> e-mail and you are not a named addressee, please
> inform Evolving Systems TIS at ti...@ev... and
> then delete the e-mail from your system. If you are
> not a named addressee you must not use, disclose,
> distribute, copy, print or rely on this e-mail. To
> ensure regulatory compliance and for the protection
> of our clients and business, Evolving Systems may
> monitor and read e-mails sent to and from its
> servers. Although Evolving Systems routinely screens
> for viruses, addressees should scan this e-mail and
> any attachments for viruses. Evolving Systems makes
> no representation or warranty as to the absence of
> viruses in this e-mail or any attachments. 
> 
> Registered Office: 9777 Mt. Pyramid Ct Suite 100,
> Englewood, CO 80112
> 

Re: [Arsperl-users] arsperl date/time value

[Thomas W. <tm...@ya...>]

Also, make sure you have "use POSIX" at the top of the
script, with the other use statements.

And no, I am not rich yet!  Poor is more like it.

Tom
--- "Meier, Lori" <lor...@ci...> wrote:
> 
> Hello,
> 
> I'm a newbie to perl/arsperl.  I am able to create
> tickets, however,
> the date/time values that I pass are all set back to
> 12/31/1969 7:00:01.
> 
> I've read that I need to use mktime, but I'm pretty
> clueless on how to use it.
> 
> Does anyone have an example of using the mktime
> function to convert
> the time so that I get the correct time and not
> 12/31/1969 7:00:01?
> 
> Thanks,
> Lori
> 
> 
> 
>
-------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software
> development plans!
> Take this survey and enter to win a one-year sub to
> SourceForge.net
> Plus IDC's 2005 look-ahead and a copy of this survey
> Click here to start! 
> http://www.idcswdc.com/cgi-bin/survey?id5hix
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 

Re: [Arsperl-users] arsperl date/time value

[K P <kp...@ya...>]

oops had some other stuff in there from the copy/paste
of code I had...
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)
= localtime(time);
$year += 1900; $mon++;
my($timestamp) = mktime(0, 0, 0, $day, $month, $year);

there that's better.

--- K P <kp...@ya...> wrote:
> try:
>
($sec1,$min1,$hour1,$mday1,$mon1,$year1,$wday1,$yday1,$isdst1)
> = localtime(time-86400);
> 
> $year1 += 1900; $mon1++;
> 
> my($timestamp) = mktime(0, 0, 0, $day, $month,
> $year);
> 
> Hope this helps.
> 
> --- "Meier, Lori" <lor...@ci...> wrote:
> > 
> > Hello,
> > 
> > I'm a newbie to perl/arsperl.  I am able to create
> > tickets, however,
> > the date/time values that I pass are all set back
> to
> > 12/31/1969 7:00:01.
> > 
> > I've read that I need to use mktime, but I'm
> pretty
> > clueless on how to use it.
> > 
> > Does anyone have an example of using the mktime
> > function to convert
> > the time so that I get the correct time and not
> > 12/31/1969 7:00:01?
> > 
> > Thanks,
> > Lori
> > 
> > 
> > 
> >
>
-------------------------------------------------------
> > SF.Net email is sponsored by: Tell us your
> software
> > development plans!
> > Take this survey and enter to win a one-year sub
> to
> > SourceForge.net
> > Plus IDC's 2005 look-ahead and a copy of this
> survey
> > Click here to start! 
> > http://www.idcswdc.com/cgi-bin/survey?id5hix
> > _______________________________________________
> > Arsperl-users mailing list
> > Ars...@ar...
> >
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> http://mail.yahoo.com 
> 
> 
> 
>
-------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software
> development plans!
> Take this survey and enter to win a one-year sub to
> SourceForge.net
> Plus IDC's 2005 look-ahead and a copy of this survey
> Click here to start! 
> http://www.idcswdc.com/cgi-bin/survey?id=105hix
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

Re: [Arsperl-users] arsperl date/time value

[K P <kp...@ya...>]

try:
($sec1,$min1,$hour1,$mday1,$mon1,$year1,$wday1,$yday1,$isdst1)
= localtime(time-86400);

$year1 += 1900; $mon1++;

my($timestamp) = mktime(0, 0, 0, $day, $month, $year);

Hope this helps.

--- "Meier, Lori" <lor...@ci...> wrote:
> 
> Hello,
> 
> I'm a newbie to perl/arsperl.  I am able to create
> tickets, however,
> the date/time values that I pass are all set back to
> 12/31/1969 7:00:01.
> 
> I've read that I need to use mktime, but I'm pretty
> clueless on how to use it.
> 
> Does anyone have an example of using the mktime
> function to convert
> the time so that I get the correct time and not
> 12/31/1969 7:00:01?
> 
> Thanks,
> Lori
> 
> 
> 
>
-------------------------------------------------------
> SF.Net email is sponsored by: Tell us your software
> development plans!
> Take this survey and enter to win a one-year sub to
> SourceForge.net
> Plus IDC's 2005 look-ahead and a copy of this survey
> Click here to start! 
> http://www.idcswdc.com/cgi-bin/survey?id5hix
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
>
https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 

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

[Arsperl-users] arsperl date/time value

[Meier, L. <lor...@ci...>]

Hello,

I'm a newbie to perl/arsperl.  I am able to create tickets, however,
the date/time values that I pass are all set back to 12/31/1969 7:00:01.

I've read that I need to use mktime, but I'm pretty clueless on how to =
use it.

Does anyone have an example of using the mktime function to convert
the time so that I get the correct time and not 12/31/1969 7:00:01?

Thanks,
Lori

[Arsperl-users] Database connection to populate ARS form

[Mark V. <mva...@ev...>]

This is not a specific ARSperl question.

=20

I am trying to copy data from an MS SQL Server database into an ARS
form.  The perl script is running on a Solaris 5.8 box with perl 5.6.1
but the source DB is on a Win2k server.  I have installed the DBI module
from CPAN and read the docs, but I still can't get a connection.

=20

My environment:

Solaris 5.8

Perl 5.6.1

ARSperl: 1.83

AR API: 6.0

=20

MS database is running on a Win 2000 Server.

=20

Any and all help would be greatly appreciated.

=20

Thanks,

Mark

=20

Mark Vaughan

Programmer III

=20

Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev... <mailto:mar...@ev...>=20

Evolving Systems, Inc.=20

9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com

=20

This e-mail and any attachments may be confidential and/or legally privil=
eged. If you have received this e-mail and you are not a named addressee,=
 please inform Evolving Systems TIS at ti...@ev... and then delete t=
he e-mail from your system. If you are not a named addressee you must not=
 use, disclose, distribute, copy, print or rely on this e-mail. To ensure=
 regulatory compliance and for the protection of our clients and business=
, Evolving Systems may monitor and read e-mails sent to and from its serv=
ers. Although Evolving Systems routinely screens for viruses, addressees =
should scan this e-mail and any attachments for viruses. Evolving Systems=
 makes no representation or warranty as to the absence of viruses in this=
 e-mail or any attachments.=20

Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112

Re: [Arsperl-users] question regarding the query() method

[<ix...@on...>]

> ARS "Advanced Search Bar" syntax goes something like this:
>    Field names (Current View's Label, or fields DB name) should be in
> single quotes. (Or you can use the field ID too.)
>    Literal strings should be in double quotes.
>    integers are NOT quoted (double or single)
>    Spacing really does not matter that much. (Extra white space is
> welcome, but sometimes "2AND" may not parse as well as "2 AND". So try
> to use some white space or at least parentheses.)
> 
> 
> API search strings only differ by this one simple (and easy to trip
> over) difference:
>      The fields DATABASE NAME (Each field has multiple English names,
> one for the DB name that is guaranteed to be unique on the form, and
> one per view where the field is included for the users reference.)
> should be in single quotes.
> 
> 
> So if the field id is 240000005 and the fields DB name is 'Login Name'
>  the following two syntax should do the same thing:
> 
> 'Login Name' = "some user"
> 
> vs.
> 
> '240000005' = "some user"
> 
> 
> However, if the fields label (view dependent name) is actually 'Login
> Name' and the field's DB name is 'Login' then the first example above
> would fail and the second one should work. (and 'Login' = "some user"
> should also work.)

thanks to everyone for all the fast feedback! .. after posting last night
i did discover that retrieving a mapping of the field entries to field ids
via ars_GetFieldTable() and using the field id itself works fine for all
cases i could think to throw at it. - 

'240000005' = "some_user"
'240000005' like "%some%"

etc

when trying to enclose 'Login Name' in single quotes, i receive :

EXCEPTION :
type => 2
message => [ERROR] Unknown field referenced in query line (position 14   (( 'Login name'^ = "some_user" ))) (ARERR #1587)

examining the form with remedy administrator, the ID is listed as
'240000005' and the 'Name' is shown as 'Login Name' in the Database tab
under Field Properties, so maybe i'm not looking in the proper place for
the database name?

for the time being things are fine so long as i've an easy way to
form queries by caching the field ids via ars_GetFieldTable() - much
better than dumping the entire database and post-filtering, heheh

now all i've left to figure out is ars_GetListSchema() and i think i'll
have everything i need to do what i want to do :)

thanks again everyone!


- tom

Table driven reporting from Remedy (was RE: [Arsperl-users] question regarding the query() method)

[Richard H. <rl...@ls...>]

	With all this discussion about remembering which symbols to use when
(i.e. when assembling qualifiers or embedding field-ids ), I thought I'd
share the way I generate reports/emails etc from Remedy.  Precisely because
of the differences between inner/outer labels and the need to add new fields
to reports or change column order or sort order, what I do now is to hold
the fields of interest in a table which is traversed automatically (e.g. for
ars_GetListEntryWithFields() calls) and also for the subsequent formatting.

For example, for a "helpdesk" schema, you could have:

My @field_tab = (
[ 'Userid',	'User ID', [1,1], undef ],
[ 'Create Date', undef, [2,1], \&fix_date ],
[ 'Description', undef, undef, undef],
	:
	:
	etc
);

Before showing how this is used, I'll explain what each row contains.  There
are four fields in each line:
1)	Internal name of the field 
2)	External name of the field (will be later used as a column header
when HTML/spreadsheet is generated). If the same as (1), then undef is used.
3)	Sort specifier.  If undef, then this field is ignored for sort
purposes but otherwise the number pair specifies the sort order and whether
this field should be sorted up or down
4)	Lastly there is a function pointer that (if not undef) refers to a
perl function that will be called on each "ticket" to post-process a
particular field (e.g. to turn 111181810 into "July 10th ..."). No fixup
means that the field's contents are emitted verbatim.

OK, to find the "tickets" matching some $qualifier using GLEWF, I put (with
ctrl, schema, fids having their normal meaning):

my @ticket_list = ars_GetListEntryWithFields(
                $ctrl
                $schema,
                $qualifier,
                0,
                0,
                [
                        map {
                                $fids->{$_->[0]}
                        } grep {
                                defined($_->[0])
                        } @field_tab
                ],
                map {
                        ($fids->{$_->[0]}, $_->[2]->[1])
                } sort {
                        $a->[2]->[0] <=> $b->[2]->[0]
                } grep {
                        defined($_->[2])
                } @field_tab
        );

OK, so far we have a list of matches generated from the @field_tab above and
the choice of fields to use/sort on is kept separate from the query itself
so different queries can be handled by using alternative field tables. The
gain here is when the boss comes in and says, "No, I want this column here
and that one there and the whole thing sorted on such-and-such".  All you do
is change the order of the rows in the table above and (maybe) change the
sort specifiers (Adding / Deleting rows has the obvious effect as does
commenting out some lines during testing).

Next, displaying the results.  I do (more or less (using the Perl CGI module
to get HTML shortcuts)):


First the column headers are extracted from the field table (using the
"default" mechanism I mentioned above)


my @rows;
push @rows, Tr(
       {
             -class => 'odd',
       },
       th(
               [
                      map {
                            $_->[1] || $_->[0]
                      } @field_tab
                ]
        )
);

Then the "meat" is emitted by traversing the @ticket_list, and for each one,
the @field_tab to pick out and (possibly) post-process the value.

for (my $i = 0; $i < scalar(@ticket_list); $i += 2) {
	my ($ticket_no, $ticket_props) = @ticket_list[$i, $i + 1];

      my @this_row;

      foreach my $f (@$field_tab) {
          my ($arLabel, $webLabel, $sortKey, $fixup) = @$f;

          next unless ($arLabel);

          my $value = $ticket_props->{$fids->{$arLabel}};

          $value = $fixup->($q, $value) if ($fixup);

          push @this_row, $value;
      }

      push @this_row, a(
            {
                   -title=>"Show full details of ticket $ticket_no",
                   -target=>"_new",
                   -href=> SOME URL ...
            },
            '... more',
     );

     push @rows, Tr(
                       td(\@this_row)
	);
}

The @rows structure is then emitted using the table() function.


----------------------


If this wasn't clear, please let me know.

Cheers,

Richard.