5 Replies Latest reply on Sep 26, 2006 7:12 AM by Newsgroup_User

    Images in document

    score1 Level 1
      I have a query with a list of names in an A to Z selectable list. When you select a name it pulls up all the details of courses individuals have sat. They each have a unique principal _id. I have a list of corresponding images names with unique principal ids to tie in with the users principal ID's so that when a name is selected from the list it loads all their course info and also their picture. I cannot however get it to load the image it just comes up blank. The database itself does not have any images the images are in a seperate folder.

      Query I am using is

      SELECT DISTINCT dbo.PPS_TRANSCRIPTS.PRINCIPAL_ID
      FROM (dbo.PPS_SCOS JOIN dbo.PPS_TRANSCRIPTS ON dbo.PPS_SCOS.SCO_ID = dbo.PPS_TRANSCRIPTS.SCO_ID)
      JOIN dbo.PPS_PRINCIPALS ON dbo.PPS_TRANSCRIPTS.PRINCIPAL_ID = dbo.PPS_PRINCIPALS.PRINCIPAL_ID
      WHERE dbo.PPS_PRINCIPALS.NAME LIKE '#start#'


      The output I am using to try and pickup the image is:

      <td width="22%" rowspan="5"><img src="images"<cfoutput>#profileImage.PRINCIPAL_ID#</cfoutput>"></td>