[ic] Not able to retrieve fields from custom table

Tim Good tim.g at edsd.com
Wed May 12 22:42:04 EDT 2004


> -----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




More information about the interchange-users mailing list