rc169

Thanks Kim.

I have created the new thread:-

https://www.ads-software.com/support/topic/cannot-create-url-link-in-sql-view/

Thanks in advance for your help.

Nigel (rc169)

Hi Kim,

Thanks for your message. I am importing to the local WordPress database, and I had also reported the issue to my hosting supplier. The hosting company adjusted a setting, and advised me that the import procedure should now work – which it did, ultimately. However, I did find that I had configured the name of the view wrongly, and it included a period. After removing the period, so that the name of the view has only letters, then the import worked correctly. Maybe it would also have functioned if I had wrapped the name of the view in quotation marks.

Now that the SQL view has been created, another issue has arisen with the use of the view on a WordPress page. In WP Data Access, I have setup Data Tables, and in the data tables, I have some columns which are URLs of files located on the website. In “Table Builder” – “Data Tables”, “Publication type”, I have set these up with the following settings:-

Type = Modal

Hyperlinks on modal = Always

Show icons = Yes

However, with these settings on the SQL View, the URLs are shown as plain text, and do not open the corresponding page. In “Data Explorer”, I have set the columns as Column Type “Hyperlink”, and the save of the settings functions correctly. However, the setting seems to become “lost” subsequently, so that the hyperlinks do not work in the browser. This problem does not arise with the actual data tables, only with the views.

Can you help with this issue? Let me know if I need to setup a separate entry on the forum.

Thanks in advance for your help.

Nigel (rc169)

OK, it seems clear that this is not going to be possible. Not such a great hardship, as it is not difficult to hand code the links at the position that I want them to appear.

However, that leaves the issue of removing the ‘read more’ link that appears at the bottom of the excerpt. How does one do that? I am using ‘the_excerpt’ as it contains thumbnail images, and other items, so a short version of ‘the_content’ is not acceptable. I can find a number of plugins to edit and style the ‘read more’ link, but nothing to remove it. Does anyone have any suggestions?

Thanks in advance, Nigel

It looks as if I had inadvertently removed the closing “}” from the CSS file. I have now unzipped the download file again, and the untouched version is correct.

I can also add new styles in Dreamweaver at the end of the file, and they are now working fine.

Nigel

Alchymyth, it looks as if your answer on this thread

https://www.ads-software.com/support/topic/change-the-font-size-in-twentyten

regarding the lines of media print styles in style.css is the clue to the problem. Before the media print styles, there are also styles for mobile Safari, iPods etc, so I have moved my additional styles before those – around line 1240 – and they seem to be taking effect now. So thanks for that!

Nigel

Thanks.

The CSS is as follows:-

.cat_prod_right {
	float: left;
	width: 400px;
	padding-left: 10px;
}

img.excerpt_thumb {
	float: left;
	width: 150px;
}

.clearfloat {
	clear: both;
}

As I am developing on a local machine, I cannot provide a working URL. If there is a way of showing a screenshot, then I can provide that. However, the principal issue is that the ‘description’ part of the excerpt (i.e. within the cat_prod_right div tags) is appearing under the thumbnail, not to the right of it.

The inline styles are working fine.

Thanks, Nigel