I was wondering if there's anything wrong with this code:
<cfquery datasource="SSHInven" name="vAll">
a.pType, a.sOnHand, a.DateModified,
FROM iParts a, iWSpares b, iMSpares c
I want to be able to select those particular fields from my DB, but, when I <cfoutput> it keeps repeating all seven items I have in the iParts table (I'm testing with that first to see what's going on). The <cfoutput> tag I have looks like:
#pType# | #sOnHand# <br />
And, like I said before, it just keeps repeating that same info about 7 times. Any particular reason why???
Thanks in advance!!