timsilva2
Forum Replies Created
-
Thanks Peter. All good now.
Thanks Peter,
Now all that I have to translate is the word “Search” next to the search box. Can you please tell me how to do that?
Hi Peter,
The instruction in the link does not seem to apply for the big “SHOW MORE” button or the “Search:” at the top of the table. Where can I change those? Thanks
Morning Peter.
Random did work with the table view, as you mentioned. I couldn’t import the view directly in the plugin though and had to do so in the phpmyadmin. It works now.
Where should I go to translate the word “SHOW MORE” and “Search:” to another language?
Thanks
Hi Peter,
I was able to create the view mentioned above in Data Explorer but I had to remove the empty line or would get erros.
create view [my view] as
select * from my_table
order by rand();Now, how do I use the view in the front end, so visitors can see a table with different content (random) rows every time the page is refreshed?
Thanks
Good morning Peter,
Sorry, but I’ll need more guidance about this: “you can create a view and use the view instead”. I searched in documentation and couldn’t find any info on how to “create a view”. Thanks
Hi Peter. Just to give you as much info as possible, I thought that maybe the problem was that my table didn’t have a numerical column, so I am now using a table that has a sequential number as first column. Still, 1,rand() does not work. Thanks
Morning Peter,
Thanks for the reply. When I tried 1,rand() I get “No matching records found”. 1,desc or 1,asc works, but not 1,rand(). I’m sure I’m missing something. 🙁
Good morning Peter. In Data Publisher, after properly setting it up, I get a very nice html table that shows in almost every page in the site. This html table has some default values (before any search is done): 10 rows and the first row of the html table is the first row of the database table. How can I have the default first row NOT to be always the first row of the DB table, but a random row instead? The 2nd, 3rd, 4th… rows can be the sequence to the first row, that’s ok. BTW, I have avery large DB table (over 30,000 rows). I hope I made it clearer now. haha
Hi Peter. To be even more specific, what I’m trying to do is to have a way to populate a tooltip dynamically. So, in the example above, if a user clicks (or hover) over the word “Texas” in a page content, it will pull the Texas info from the DB. If a Bible verse reference, it will pull the actual verse from the DB. There are plugins that do that already, but for some reason they slow the page load too much if you have a large database (I’ve tried many). Your programing skills seems to have solved this major obstacle. I would appreciate any pointer. Thanks