Hi,
I have 4 Tables in my Databse:
Product
Location
Manager
Loaner
I am trying to filter out Loaners (transactions)
by Product.
I have written this SQL CF QUERY:
---------
<CFQUERY NAME="getFiles" DATASOURCE="Loaner" DBTYPE="ODBC">
SELECT InputDate, QtyOnHand, LocationName, LocationContact, ManName
FROM Loaner, Manager, Location
Where Loaner.ProdID = #FORM.ProdID#
ORDER BY InputDate
</CFQUERY>
---------
I do not get an error on my page but the cfoutput is repeating the info.
----------
How can I fix this?
Please help,
Thanks,
Monoone
I have 4 Tables in my Databse:
Product
Location
Manager
Loaner
I am trying to filter out Loaners (transactions)
by Product.
I have written this SQL CF QUERY:
---------
<CFQUERY NAME="getFiles" DATASOURCE="Loaner" DBTYPE="ODBC">
SELECT InputDate, QtyOnHand, LocationName, LocationContact, ManName
FROM Loaner, Manager, Location
Where Loaner.ProdID = #FORM.ProdID#
ORDER BY InputDate
</CFQUERY>
---------
I do not get an error on my page but the cfoutput is repeating the info.
----------
How can I fix this?
Please help,
Thanks,
Monoone