I want to pull a file from a recordset but add a suffix after the filename.

i.e. Using Smart Image Processor - It saves an uploaded filename to database and also creates a thumbnail with the suffix _small. I can pull out the original filename but how do I add the the _small suffix to the the filename

Thanks

Hello Fergus,

Making thumbnails and save filenames in a database check the following tutorial: dmxzone.com/showDetail.asp?TypeId=2&NewsId=3977&LinkFile=tutorials/Make_Thumbnails_database/index.htm

However, here is another solution provided by Alan:
<i>
You do not need to enter the thumb into the database because as long at the 'suffix' for the thumb is always the same you can write a 'replace' so you can get the thumb to act dynamically on the page.
eg,. =Replace(rsPics("Pic_Enlarge", ".jpg", "_small.jpg" )
</i>
Regards,
DMX Zone Support Team

Great thanks. These things so obvious when you see the solution

Fergus