Hi there I am trying to complete the development of an application.
In one of the programs where a user is entering data I am asking a user to enter details of a photo that will be added to a record. So far I have a query that will select all available photos that are available. Here is the query. <cfquery name="qgetphotonames" datasource="#Request.DSN#"> select * from photos order by photothbname </cfquery> Then I have in the main part of the program <tr> <td valign="top"> <select name="photoid"> <cfoutput query="qgetphotonames"> <option value="#photoid#">#photothbname# </option> </cfoutput> </select> </td> </tr> What I am trying to do is the following. As well as displaying the photo.name I would also like to display the thumbnail picture so a user can actually see the thumbnail when selecting the picture to use. Wondering if anyone has any idea of how this can be done. Regards & thanks in advance. Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4