https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/

Photo not displaying as in demo

  • freedomrv
  • freedomrv's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
8 years 2 weeks ago #2074

I have installed Card View JX and have it working as in the demo but have the following issues:
1. I can only get the image to display by inserting an image into Misc area of the contact. When I add the column "image" to the card view jx it only dislays as text i.e. image/example.jpg and not the image itself.

2. I am using the email field as a column but do not want to display the email address but would like it to display as per your demo "send email". Unfortunately the email field in Joomla does not allow for anything other than an email address. Please advise how I achieve this.

Thanks.
Kate.

Please Log in or Create an account to join the conversation.

More
8 years 2 weeks ago #2075

Hi,

Those two are basically the same problem. If you want to display image, you have two options you can insert whole <img src="path_to_image/myimage"> tag in you database or you can create a database view, that concatenates the content of you current database table into an img tag.

Same thing for "send email". You can either put <a href="This email address is being protected from spambots. You need JavaScript enabled to view it.">Send Mail into the database, which for you according to your description is not an option, or create a view that does that for you.

Here are some examples on how to create a view in MySQL: toolsjx.com/faq/3-how-to-create-a-databa...use-it-with-tools-jx .

In our demo we have inserted html tags straight into the original table.

The following user(s) said Thank You: freedomrv

Please Log in or Create an account to join the conversation.

  • freedomrv
  • freedomrv's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
8 years 2 weeks ago #2079

Thanks so much for such a quick reply. Will ready the link and hopefully have this sorted today. Cheers, Kate.

Please Log in or Create an account to join the conversation.

  • freedomrv
  • freedomrv's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
8 years 1 week ago #2084

Hi. I have finally worked out how to create the database view and to CONCAT the fields to show the image. I have created a view called ViewName as per the example. The problem I now have is when going back into Tools JX and selecting the table "ViewName" I am now unable to select the other fields that were in the previous table contact_details such as name, phone, email e.t.c.
I would appreciate some more help!
Cheers,
Kate.

Please Log in or Create an account to join the conversation.

More
8 years 1 week ago #2085

Hi,

In the create view command you should list all the fields that you want to use.

For example something like this:

CREATE VIEW MyView AS SELECT CONCAT('<img src="',photo,'"/>') AS image, name, phone, email FROM MyTable

Last edit: 8 years 1 week ago by tomaz.
The following user(s) said Thank You: freedomrv

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.210 seconds

Contact Us

Contact us on Facebook