I am using an Access db to store a product inventory, i.e. name, price, size and also photo (JPG) of each product. I am storing the links to each photo in Access - After querying the db, how do I use <CFOUTPUT> or another CF tag to open and display the appropriate photo along with the other (text) fields of each product?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Displaying images from Access using CF
- Thread starter suarezweb
- Start date
something like this...
<cfquery datasource="DSN" name="getproducts">
SELECT * FROM Products
ORDER BY ProductID
</cfquery>
<cfoutput query="getproducts">
<img src="/photos/#Photo#" border="0">
#ProductName# - #DollarFormat(ProductPrice)#<BR>
#ProductDescription#
</cfoutput>
Obviously, you'd want to add some HTML formatting, tables, etc..
Hope this helps!
Bobby R
<cfquery datasource="DSN" name="getproducts">
SELECT * FROM Products
ORDER BY ProductID
</cfquery>
<cfoutput query="getproducts">
<img src="/photos/#Photo#" border="0">
#ProductName# - #DollarFormat(ProductPrice)#<BR>
#ProductDescription#
</cfoutput>
Obviously, you'd want to add some HTML formatting, tables, etc..
Hope this helps!
Bobby R
- Thread starter
- #3
- Status