Image displays on list view but NOT on detail view

[puzzled]

Hi Troester - thank you so much for your help so far.

I have decided to go the proper route rather than a work around.

I have now created a separate table with just the facility icons in and I would like to try what you mentioned here...

a repeat group has it's data in an additional table table_X_repeat (x=groupID), every "repeated" entry has one record id, parent_id, element1,....
This is displaying fine on my site in list and details view.

The only thing is that I am really quite new to fabrik and joomla and have no php experience so I don't know how to do what you mention - I need the images stored in my new facilities table to display in the list and details view of my other table.

I am guessing joins and groups are involved but if you could point me at an example or a basic written wiki I would be very grateful.


Thanks

 

[troester]

There are several ways to handle multiple images inside Fabtik:
-Add a fileupload element, set ajax =yes, that's it

-Add a group to your form, set to repeatable
Then add a fileupload element ajax = no
Or add an image element

 

[puzzled]

Thanks for the tips - I have managed to link my facilities table into my main table using the databasejoin element and it seems to be working fine.

The only issue I have now is that the databasejoin field in my main table just shows the image path/name and I want it to display it as an actual image.

How do I do this?

Thanks in advance

 

[puzzled]

friendly bump

 

[troester]

In the dbjoin element you can use the concat field (I think it's only working in list snd details view), something like
'<img src="', {Thistable}.your-column,'">'

But can't you use the image element directly?

 

[puzzled]

Thanks for your reply troester

I really don't know if I can use the image element directly - I have been in so many circles.

I am putting login details on the mysite area - if your able to take a look and work it out you may have just saved my sanity.

Thanks

 

[puzzled]

joomla admin is on your mysite area now - the 2 lists I am having problems with are 77(main) with 87(joined)

if you view data on 77 you will see that the databasejoin field has a list of images in it but in path form only - these are what I want to display as actual images in both list and detail view

 

[puzzled]

Hi Troester - you probably heard my screams of delight just now!!!!! - I got your suggestion of

In the dbjoin element you can use the concat field (I think it's only working in list snd details view), something like
'<img src="', {Thistable}.your-column,'">'

to work!!!!!

Excuse me while I dance a round a bit......................

I had to put in a full path though as it was not finding the image so I now have
'<img src="http://www.mysitename.com/mysubdir/', {thistable}.my-column,'">'

Is there a way to make it not need that as the site won't be in the subdir when it goes live.

Thanks

 

[troester]

I'm not on my PC.
You may try with or without starting /.
I would suggest to hardcode the path on your live site, too at the moment as it seems you need it running urgently.

 

[puzzled]

Thanks - I have hardcoded for now and it is working great.

Just one small thing - it displays 11 of the images great but for the 12th onward it does not display properly

image 11 working fine:
<li>
<img src="http://www.mysite.com/mysubdir/images/dir/toys-for-toddlers.gif">
</li>
image 12 not working:
<li><img src="http://www.mysite.c</li></ul></span>
        </li>
 
images 13 & 14 don't come in at all

Any ideas?

 

[puzzled]

friendly bump

 

[puzzled]

another friendly bump

 

[troester]

I have no idea what your are doing exactly with a dbjoin element and 14 images in it.

Where is your data coming from? What does it look like in the database?
What are your exact fabrik element settings? (Screenshots)
Do you have a repeated group?

You can't blame fabrik for displaying non-fabrik-generated data in a way you don't expect.
Maybe there's a Fabrik or MySQL string length limitation (e.g. VARCHAR 255)