[ic] Data tag not returning result
tim.g at edsd.com
Wed May 12 13:52:39 EDT 2004
> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org
> [mailto:interchange-users-bounces at icdevgroup.org] On Behalf
> Of Paul Jordan
> Sent: Wednesday, May 12, 2004 11:16 AM
> To: interchange-users at icdevgroup.org
> Subject: RE: [ic] Data tag not returning result
> Tim Good [draco at edsd.com] wrote:
> > Hello list,
> > (mysql 3.23.58 on Redhat 8.0 non threaded perl 5.8.2 interchange 5.2
> > stable) I have a custom table I have added to my database
> > "delivery_schedule". In the order_view page, in admin, I
> would like to
> > pull data from this table
> > according to the order_number being viewed. I have a field
> > "order_number" in the delivery_schedule table which get the
> > order_number from transactions when the order is placed.
> > I have tried several different approaches to solve this
> task. However,
> > none are working. What is the best way to do this?
> > Thanks much,
> > Tim
> Next time include code we can help fix.
> SELECT foo, bar
> FROM delivery_schedule
> WHERE order_number = '[however your getting the
> order number]'
> Delivery Detial:
> Delivery Schedule #[sql-increment]: [sql-bar]<br>
> Order is not yet in transit
> [however your getting the order number] is however you can
> grab the order number on that page, maybe a CGI arg, or a
> value, or scratch, i dunno, you'll have to see what it is giving you.
Thank you for the response. I was using the code below:
[query sql="select charge from delivery_schedule where order_number =
[loop-data transactions order_number]" type=list]
However, I need to use the results in later areas eg.
[total_view subtotal="[loop-data transactions subtotal]"
install="[loop-data transactions install_chrg]" delivery="[sql-param
Total_view is a custom Usertag I developed to return different totals
depending on view and charges.
For instance weither or not there is a delivery charge. I have tried to
wrap the above query in [seti][/seti]
tags then use [scratch foo] to return in delivery="[scratch foo]". This
works once but when I call
it later it dosen't.
Then I tried:
$Tag->data("delivery_schedule", "charge", "[loop-data transactions
This returns nothing.
Also tried to have the query tag ecapsulate the whole area where
[sql-param charge] is needed.
However, if there are no results the "whole area is blank".
More information about the interchange-users