[ic] Not able to retrieve fields from custom table
tim.g at edsd.com
Fri May 14 11:46:26 EDT 2004
> > Paul,
> > As I said in my last post ...
> >> Ofcourse the code above is not the exact code which I was
> using for
> >> the [query ...] tag encaspulating <td>s and <tr>s. I included the
> >> code above as an example to where I was working within the
> >> page.
> > However I negleted to see that the [list][/list] tags are
> required for
> > [no_match][/no_match] to work. At a second glance at the
> > I still don't see where it states that [list][/list] tags
> are requird
> > inorder for the [on_match][/on_match] tags to work so thanks for
> > pointing that out.
> Perhaps you are correct in that the docs do not come out and
> say that. However this was easy to find using the archives,
> which to me are far more useful.
> searching for "no-match not returned" or "no-match not work"
> bring the answer right up.
thanks so much for your help. I am not sure what I was thinking
by going by the documentation. I will use the mail list when
the documentation does not help. Thanks for pointing that out.
> > Some of the examples in the documentation for the [query ]
> tag imply
> > that the [list][/list] are not required for [on_match][/on_match] to
> > work:
> No, that is incorrect. No example shows a SubTag working
> without [list] or type=list. In fact, maybe that says it all
> right there 8-)
So if I understand your explanation of the documentation correctly,
if the [list] tags are not included, you must use type=list. But
you must use one or the other in order for [no_match] to work?
Also the [on_match] tag does not have to be within the [list][/list]
tag for it to work. The [list][/list] tag just needs to exist anywhere
in the [query][/query] tags.
> I assume it is working now?
Just for the record I was using type=list in my query tag. If you go
and read my posts you will see this. I will try using the [list][/list]
tags so I understand how the [query] tag works.
Also I would still prefer to use the [data ...] tag. The [data ...] tag
will not work for my custom table. I am not sure why. The query is sent
the database as expected but nothing is returned. Does this have
to do with Safe Mode?
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
More information about the interchange-users