Once you have inserted the filname into your database, you would get the filename by querying the database with the Primary Key set on the image in the table.
Assuming the table was like this. * imageID | imageName* * ---------------------------------* * 1 | /mypath/myimage1.jpg* * 2 | /mypath/myimage2.jpg* * 3 | /mypath/myimage3.jpg* * 4 | /mypath/myimage4.jpg* And you have inserted the names into your table with SQL *<cfquery datasource="mydsn">* *INSERT INTO myImagetable (imageName)* *VALUES* *(<cfqueryparam cfsqltype="cfsql_varchar" value="#myFilename#" />)* *</cfquery>* You then would use a URL with the tables ID to get the filename: eg. */index.cfm?imageId=1* * * Then use the URL.imageid in the query to get the filename: *<cfquery name="myimagequery" datasource="mydsn">* *SELECT imageName FROM myImageTable* *WHERE imageId = <cfqueryparam cfsqltype="cfsql_integer" value="#URL.imageid#" /> LIMIT 1* *</cfquery>* Then use the query result in the image src attribute. <cfoutput>*<img src="#myimagequery. imageName#" /></cfoutput>* * * * * Is that what you are asking for? -- /Kevin Pepperman "They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety." - Benjamin Franklin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
