1. 

   ajdjackson, Member

   Hi

   Hopefully this isn't too difficult.

   I have stored several thumbnail images in the database and now I'm writing a report that allows the user to assign an image to a plot.

   I've created the following report:

   CREATE PROCEDURE `sp_DBR_SS_Assign_Images`(inSiteID int, inPlotID varchar(25),inType varchar(25), inImageID int) BEGIN

   select inSiteID,inPlotID,inType, inImageID;

   Eventually the above will be changed to update a field with the image id.

   The first 3 parameters are simple select lists and the 4th one is a stored procedure using 2 the previous selections:

   CREATE PROCEDURE `sp_ADBR_Select_Image`(inSiteID int,inType varchar(25)) BEGIN

   select t.image_id,t.image_thumb from hilmark.images t join hilmark.tblsitesjake u on t.image_site = u.site_name where u.Site_ID = inSiteID and t.image_ctgy = inType order by t.image_id;

   The above all works as the initial report results in the correct output.

   The issue I'm having is that the dropdown for selecting the image is blank - although the data is there.

   Is there something I need to do to have the images visible in the dropdown?

   Thanks

   Jake
2. 

   myDBR Team, Key Master

   Jake,
   browser's native selectlists cannot include images, they are text only.

   --
   myDBR Team

Reply

You must log in to post.