[ic] Not able to retrieve fields from custom table

[David Hagen]

could someone please take us off your emailing list - its becoming
embarrassing to have 30-40 emails coming in that are of no interest
whatsoever
thanks

----- Original Message -----
From: "Tim Good" <tim.g at edsd.com>
To: <interchange-users at icdevgroup.org>
Sent: Thursday, May 13, 2004 12:42 PM
Subject: RE: [ic] Not able to retrieve fields from custom table


> > -----Original Message-----
> > From: interchange-users-bounces at icdevgroup.org
> > [mailto:interchange-users-bounces at icdevgroup.org] On Behalf
> > Of Stefan Hornburg
> > Sent: Wednesday, May 12, 2004 3:46 PM
> > To: interchange-users at icdevgroup.org
> > Subject: Re: [ic] Not able to retrieve fields from custom table
> >
> >
> > On Wed, 12 May 2004 15:31:54 -0600
> > "Tim Good" <tim.g at edsd.com> wrote:
> >
> > >
> > > [snip]
> > >
> > > > Check if the table appears in the UI.
> > > > Check your SQL log for the query issued by Interchange.
> > > >
> > > > Bye
> > > > Racke
> > > Racke,
> > >
> > > Yes table is in UI and I can manipulate it through UI.
> > > No entries in logs. Is there a place to turn on sql
> > > debugging within interchange?
> >
> > Yes, enable debug logging and look up the DataTrace
> > directive in the docs.
> >
> > Cheers
> > Racke
> To all who have given feed back,
>
> I have developed a work-a-round but still would like to get the data
> tag to work. I turned on debuging and the results showed the query as
> expected:
>  prepare('select charge from delivery_schedule where order_number =
> 00020')= DBI::st=HASH(0x9e2fbd0) at DBI.pm line 1935
>     <- execute= 1 at DBI.pm line 1937
>     <- FETCH('NAME')= [ 'charge' ] at DBI.pm line 1957
>     <- fetchall_arrayref= [ ARRAY(0x9d089ec) ] row1 at DBI.pm line 1959
>     <- DESTROY= undef at Interpolate.pm line 4621
>     <- DESTROY= undef at DBI.pm line 746
>     <- disconnect= 1 at Server.pm line 955
> !   <- DESTROY= undef during global destruction
>
> I am just not getting the results to page. My work-a-round usertag, if
> interested is:
> UserTag getdelchrg PosNumber 2
> UserTag getdelchrg addAttr
> UserTag getdelchrg Routine <<EOR
> sub {
>         my ($curo) = @_;
>
>         my ($charge, $sql);
>
>         $charge = 0;
>         $sql = "select charge from delivery_schedule where order_number
> = $curo";
>         $charge = $Tag->query({ table=>'delivery_schedule', sql=>$sql,
> wantarray=>1 });
>
>         return $charge->[0]->[0];
> }
> EOR
>
> I really would like to understand why the data tag is not working for
> the
> delivery_schedule table. All continued feedback is greatly appreciated
> and
> thank you to all the feedback thus far.
>
> Tim
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>