[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