I've done zilch coding against AS/400, but is there a reason why you
can't grab quantity available in the same query as when you grab the
products? Easily done in most RDBMS's. However, if that doesn't work,
why not add a second qry_ to the fuseaction, where you do your looping.
In each iteration of the loop, create a dynamically named query:
<cfquery name="quant_#productid#" ....> Then when looping over your
products query in the dsp_, grab
#evaluate("quant_#productid#.quantity")#
(there's plenty of other ways to do this, but my point is that it should
be very possible to keep everything in your application level files
without doing includes in your fuses)
---
Billy Cravens
-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 9:44 AM
To: '[EMAIL PROTECTED]'
Subject: Procedural Question
Ok this may cause a lot of feedback, but here goes. I know
you're
SUPPOSED to seperate files into dsp_, act_, and qry_. Now the trouble I
have
is this. One one page I am passing a url parameter of an group number. I
then have a switch file that has a qry based on that group number that
pulls
out the items. Now here is the tricky part. I have to loop over the
query to
display each item on thier own line. The problem is that I have to
access
our AS/400 which tells me how much we have on hand, so in my dsp_ where
I am
looping over I have included an act_ so that it can tell me if the item
is
in inventory. Short of making another script that queries the AS/400
periodically to get inventory how would you go about doing it. One
solution
I have thought of is using query of query to put the 2 queries together,
but
that doens't really solve the problem. What have you done to solve this
problem?
Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
==^================================================================
This email was sent to: [email protected]
EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9
Or send an email to: [EMAIL PROTECTED]
T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^================================================================
