Hey from Denmark!

I am aware that you can use the "column contents are URL links" and then specify the parameter to include in the link so that another grid can catch it with the [numericQueryString:XXX]. However I see that the mentioned option only exists if the content is text.

My question is how can I do the same thing with an image/binary data? In other words: I would like to click an image and be redirected to another page WITH e.g. the ID parameter for that row.

Could I maybe use the HTML attributes option and if so how would it look like?

Thanks,

David
- A proud IndooGrid owner and everyday user, SUPER job developers!

Hey art,

I am not sure I understand you correctly, can you explain it further what you mean by "1) just show the imagelink as a link and 2) make that picture a link using the ID of that row"

The column you refer to is the image content column which has the binary data, right? In this case what should I set the "show binary as" as? As I understand I then select the 2-editor, and do what?

Remember I need to only show the full Image or thumb in the cell (without any text/link) but where the image itself is a link that includes the ID of the row in which it is clicked.

What is the right token to retrieve row ID in view mode, is it at all possible? I have tried setting the ... .aspx?&parameterID=[indoogrid:idValue] in the link both in 2-editor and by using the "html attribute" option with onclick java linking, but these approaches have not worked for me :(

Thanks for reply,

Dave

You could create a new row in the db with a bit, and in the editor do a check to see if the link should be shown or not.

I've also been struggling with how to have the binary image point to a differnt link... no success yet (I need it dynamic). For your needs it sounds like you've gotten very close. You should be able to use "Show data from more columns..." and select option "1-configurable". You would need to put the correct html to accomplish the same thing as you did with option 2, but now you could use the condition column to cause it to return a different image based on the mime type... if you used that field otherwise you would need some indicator for the scenario you are describing, like no file should have null in the binary field.

Hey cutts,

First of all Im a big fan, read a lot of your posts, I can see that youre a big contributer to the community...

Thanks for the idea, I actually remembered something similar in one of your other posts and I will try it out soon.

However, I just tried my approach and found an interesting situation which I would like to share if anybody are interested...

Just to make it clear I now have a "file_content" column, binary, (holding the file I need) and "file_icon" column, varchar(10), (which should show the availability status as well as the available link to another grid that is set to catch the row ID in which the icon was clicked and force the related file to download).

The funny thing is that if the value of "file_icon" IS NULL then no icon/link is shown for the specific row, it is just blank in the grid. That provides me with the two situations I need; if AVAILABLE then "file_icon" value is not null and the grid shows the icon I set in the 2-configuratior, if UNAVAILABLE then no icon is shown since the value for "file_icon" IS NULL.

Given this, I figured that the only thing I need to do is create a short and simple "CASE WHEN THEN" sql statement whenever "file_content" is manipulated, putting this code as part of "on update" or "on insert" actions :-)

Ill update if any interest,

Cheers, Dave