[ic] Data tag not returning result
Paul Jordan
paul at gishnetwork.com
Wed May 12 13:15:53 EDT 2004
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.
[query
ml=100
type=list
sp="@@MV_PAGE@@"
sql=|
SELECT foo, bar
FROM delivery_schedule
WHERE order_number = '[however your getting the order number]'
|]
[on-match]
Delivery Detial:
[/on-match]
[list]
Delivery Schedule #[sql-increment]: [sql-bar]<br>
[/list]
[no-match]
Order is not yet in transit
[/no-match]
[/query]
----------
[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.
HTH
Paul
More information about the interchange-users
mailing list