# Image Path from SQL Table

**URL:** <https://forum.inductiveautomation.com/t/image-path-from-sql-table/9309>\
**Category:** Ignition\
**Created:** [November 10, 2014, 2:54pm UTC](https://forum.inductiveautomation.com/t/image-path-from-sql-table/9309 "2014-11-10T14:54:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cthorpe](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@cthorpe](https://forum.inductiveautomation.com/u/cthorpe)\
**Post date:** [November 10, 2014, 2:54pm UTC](https://forum.inductiveautomation.com/t/image-path-from-sql-table/9309/1 "2014-11-10T14:54:54Z")

</div>

I have a SQL Database setup to store image paths in a BLOB column. I have a Table setup to Query all data that is 90 days old or newer. My question is how can I setup an Image path for the picture in Line 1, a separate image path for Line 2, so on. The issue at hand is that it cant be fixed to, say the Key ID, and I just don’t know how to script this to look for the Newest date, 2nd newest, 3rd newest, so on.

Any Suggestions? ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:")

v7.7.1  
Windows