Images in document

[Guest]

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>

[dempster]

If your IMG tag looks like this:

<img src="images"<cfoutput>#profileImage.PRINCIPAL_ID#</cfoutput>">

The problem is the quotation marks after images. Assuming images is your subdirectory, you'd want:

<img src="images/<cfoutput>#profileImage.PRINCIPAL_ID#</cfoutput>">

[Guest]

I have left out the quotes but it is still not bringing up any images. The code I listed, the query name is profileimage so it should pick up the images but does not.

[Newsgroup_User]

<img src="images/<cfoutput>#profileImage.PRINCIPAL_ID#</cfoutput>">

Or the cleaner, IMHO

<cfoutput><img src="images/#profileImage.PRINCIPAL_ID#"></cfoutput>

[Guest]

Ian,

I have tried the code below but it is still not picking up the images, I get no errrors just no pictures. Any ideas gratefully received.

[Newsgroup_User]

Standard debugging techniques.

1) View the source of you resulting page to make sure the <img...> tag
is complete and correct.

2) Print out the profileImage.Principal_ID variable to make sure it
contains the correct value.