I am trying to establish a connection between LibreOffice (5.4.6.2) and Mariadb (10.1.29)/mysql. I have researched various resources on the web but am stuck not being able to establish a connection preliminary steps taken: * the file mariadb-java-client-2.4.0.jar is downloaded from [https://downloads.mariadb.com/Connectors/java/connector-java-2.3.0/](https://downloads.mariadb.com/Connectors/java/connector-java-2.3.0/) * JRE is installed and enabled under LibreOffice Tools > Options > Advanced * in that Advanced tab, Class Path is set with `mariadb-java-client-2.4.0.jar` (I have tried with a path `/opt/mariadb-java-client-2.4.0.jar` and `/home/<my user name>/mariadb-java-client-2.4.0.jar`) Based on web site and youtube tutorials, the next steps are to connect via LibreOffice Base. Using the wizard: * Connect to an …

Member Avatar
Member Avatar
+0 forum 3

The challenge I need to resolve is getting a sub-string from strings such as those below. Each line is of an array so I am iterating and working on one line at a time in a JavaScript loop. All of the strings have the names at the start of the line: Joe Smith will run... Jane Jones will follow... Bridget Burns and Jack Jones will be away... Jack Jones, Gracie Burns and George Burns have three days in... The sub-string I need is the name(s) at the start of each string. My JavaScript is handling an example of the first …

Member Avatar
Member Avatar
+0 forum 7

I am a novice at JavaScript an jQuery. I am writing a project and trying to incorporate $(this) to read a data attribute. Once the data attribute is determined and assigned to a variable, I intend to use that to access other form elements. Instead of reading the data attribute as intended, clicking the button is submitting the form. This is a code sample: <fieldset class="new_inputs" id="new_inputs1"> <label for="file_input_1">Input File:1</label> <input class="fileRenamingFormInput" name="file_input_1" id="file_input_1" type="text" value=""> <br> <select class="fileRenamingFormSelect" name="destinationFile_1 id="destinationfile_1">...</select> <input class="fileRenamingFormFileOut" name="file_out_1" id="file_out_1" type="text" value=""> <br> <textarea class="copyCommandBlock" name="copyCommandBlock1" id="copyCommandBlock1"></textarea> <button type="submit" class="btnGenerate" id="btnGenerate1" data-idx="1">Generate command</button> <- Button …

Member Avatar
Member Avatar
+1 forum 12

Is it possible to attach a jquery autocomplete input to a form initiated by ajax editing a table? I have the following method for making a table cell editable using AJAX. I.e., user clicks on the cell and it transforms to a mini form. Hit Enter and the changes are sent to a script, updating a database and the new content is sent back to the table. This code I am certain is error free and working. I want to expand functionality so the input for the new value comes into the DOM using jQuery ui autocomplete. $(function (){ $('tbody').on('click','td:not(.exclude)',function() …

Member Avatar
Member Avatar
+0 forum 1

I have 3 td's in a portion of a table. Sometimes, the data coming in from the database is less than 3. I need a method that will lay-out the data precisely compared to a rank in the table. Ideal situation: array |-0 |-name => Joe |-rank => 0 |-1 |-name => Dick |-rank => 1 |-2 |-name => Mike |-rank => 2 Yields: <tr> <td data-rank="0"> Joe </td> <td data-rank="1"> Dick </td> <td data-rank="2"> Mike </td> </tr> Problem situation: array |-0 |-name => Dick |-rank => 1 |-1 |-name => Mike |-rank => 2 Yields: <tr> <td data-rank="0"> Dick …

Member Avatar
Member Avatar
+0 forum 7

I am trying to create databases in Ubuntu 14.04 running LibreOffice 4.4.3 and can not due to not connecting with JRE or JDK. Research carried out and things I have tried lead me to understand I need JDK-8 now instead of JRE. Is this accurate? JDK-8 and Java 8 are installed. From the command prompt: $ sudo update-alternatives --config java Selection Path Priority Status ------------------------------------------------------------ 0 /usr/lib/jvm/java-8-oracle/jre/bin/java 1081 auto mode 1 /usr/lib/jvm/java-6-openjdk-i386/jre/bin/java 1061 manual mode 2 /usr/lib/jvm/java-7-openjdk-i386/jre/bin/java 1071 manual mode * 3 /usr/lib/jvm/java-8-openjdk-i386/jre/bin/java 1069 manual mode 4 /usr/lib/jvm/java-8-oracle/jre/bin/java 1081 manual mode $ sudo update-alternatives --config javac Selection Path Priority Status …

Member Avatar
Member Avatar
+0 forum 6

I am starting a project that has been managed using a spreadsheet until now but needs to be converted to a mysql/php application. The amount of rows in the spreadsheet has exceeded something that can be easily sorted, filtered and edited. A particular field has a weak entity that is not worthy of its own field in the database. It concatenates data from other fields in the same database record plus some arbitrary text. I want to display this concatenation in a textarea for each record. The application will display anywhere from 1 to 10 rows on a screen page. …

Member Avatar
Member Avatar
+0 forum 11

I have an endless scroll application in PHP and jQuery. This my javascript: var base_url = window.location.origin; $(window).scroll(function() { if($(window).scrollTop() + $(window).height() > $(document).height() - 100) { var offset = $(".badge-item").length; console.log(offset); $.ajax({ url : base_url+'/index.php/display/jQuery_movies', type : "post", data : { offset_cnt : offset }, datatype : 'html', success : function(response){ $("#badgesWrapper").append(response); offset = offset+12; }, error :function(){ alert("failure"); $("#result").append('Error Occurred while fetching data.'); } }); } }); This is my php (using CodeIngiter): function jQuery_movies(){ $this->load->model('Model_display'); $offset = $this->input->post('offset_cnt',TRUE); $result = $this->Model_display->fetch_movies($offset,$limit=12,$method='ajax'); echo $result; } As designed, the objective is to count the number of occurences of a …

Member Avatar
Member Avatar
+0 forum 6

I have some experience when it comes to CodeIgniter. I am trying to figure out a method for determining the window size of a browser and assign it POST or $this or the user session (also part of $this). I need the variable to persist for the session. In my site there is a table of data that needs to be formatted differently for width greater than 768px. By trial and error, I have tried different methods using CSS media queries but there is no way around it: I need to know, server-side, what the browser window width is so …

Member Avatar
Member Avatar
+0 forum 10

After writing out that which appears below I realise help I am asking for might be outside the scope of support for Owl Carousel. The plug-in itself is working as it should. It is functions within this plug-in that I want to emulate for the rest of the content that appears on my site. I am using Owl Carousel and it works great. I wish to adapt some of the CSS and/or javavscript to the rest of the page displaying the carousel but have hit a wall and hoping someone can assist. This link http://carouselhelp.position-is-everything.com/ will demonstrate how I am …

Member Avatar
Member Avatar
+0 forum 3

This is a typical entry of many on a page: <div class="link_entry"> <div class="link_actions left"> <span class="LibraryItemDelete"> <img src="images/ajax-urls/delete_icon.png" title="Delete this link" alt="Delete this link"> </span>&nbsp; <span class="LibraryItemEdit"> <img src="images/ajax-urls/edit_icon.png" title="Edit this link" alt="Edit this link"> </span> </div><!-- /link_actions --> <div class="link right"> <input type="hidden" value="92" name="id"> <--want to find and assign that value <a href="http://www.somewhere.com">somewhere.com</a> </div><!-- link --> </div><!-- /link_entry --> This is the start of a jQuery function for an ajax call: $(document).on('click', '.LibraryItemEdit', function() { var url_id = $(this).find('input[name="id"]').val(); } I want a way to find and assign to a variable the value of the hidden input …

Member Avatar
Member Avatar
+0 forum 4

I have two forms that are fairly identical located on different pages of a site. In order to call distinct jQuery ajax functions there are two class names I need to alter. For one of the pages, I place this script <script> $(document).ready(function(){ $(".itemDelete").switchClass("itemDelete","LibraryItemDelete"); $(".itemEdit").switchClass("itemEdit","LibraryItemEdit"); }); </script> and it is not working. I have tried with that script loaded in the header or the footer. Most examples of switchClass I found on the net have examples where the trigger event is clicking on a div. Is what I am trying to do possible?

Member Avatar
Member Avatar
+0 forum 2

I have the following snippet of function and call to another function for returning tabs to format code. public function makelinks ($urls_data) { ...code... $i = 5; $tabs = $this->echo_tabs($i); $output = "$tabs<ul class=\"url_list\">\n"; ...code... } public function echo_tabs($i){ $x = 0; $o = ''; for ($x;$x<$i;$x++) { $o .= "\t"; } return $o; } What I would like is for $output to result in `\t\t\t\t\t<ul class=\"url_list\">\n` the \t's translating to actual tabs when a browser view source is generated. I am aware if I simply had that block string of characters assigned to $output, then they would have the …

Member Avatar
Member Avatar
+0 forum 2

This might be a duplicate but I can not find a solution for the small challenge I am facing. I want to assign the href and text in an `<a>` tag to variables and use them in a jquery script. Examples I have found pertain to diving into the DOM and retrieving several `<a>` based on class or specific ones based on an id. I think there should be a way to drill down and select a particular one. I have a list of links rendered from php. Currently, they all have the same class. An admin user has the …

Member Avatar
Member Avatar
+0 forum 3

I am converting a PHP application from MySQL to PostgresSQL. The MySQL works flawlessly. The database for this application is a one to many relationship. I have a while loop nested inside another while loop <?php while ($movie_row = pg_fetch_array($movie, PGSQL_ASSOC)) { ?> [html code to echo various elements of $movie_row] [a record in this part will have multiple records of information from another table in the db which the following code will fetch and process] <?php $movie_file_result = pg_query ($conn, "SELECT DISTINCT(cd_name) FROM movie_files WHERE data_id=".$movie_row[id]." ORDER BY cd_name");?> <div class="files"> <p>Find in:</p> <ul class="file_list"> <?php while ($filesrow = …

Member Avatar
Member Avatar
+0 forum 3

I have a php application for a cookbook site. To make this application responsive for all devices, I need to convert the listing of ingredients from a table format to div's but I am having a challenge with how to set-up the div structure and css. To better explain what I have presently and what I want, kindly [click here](http://dwlamb.com/demo/demo.html). This is a typical block of recipe ingredients: <table id="recipe"> <tr> <td class="ingramt">2½</td> <td class="ingred">cups flour</td> <td class="ingramt">1 tbsp</td> <td class="ingred">baking powder</td> </tr> <tr> <td class="ingramt">½ cup</td> <td class="ingred">butter or shortening</td> <td class="ingramt">1</td> <td class="ingred">egg</td> </tr> <tr> <td class="ingramt">1 tsp</td> …

Member Avatar
Member Avatar
+0 forum 7

I am working on a responsive web design. For some resolutions like below 800px across, I hide a whole div with syntax such as: @media only (max-width : 800px) { div.well._menu { display: none; } } How do I bring the div back to its default if the display property has not been declared originally? Do I use inherit? @media only (min-width : 801px) { div.well._menu { display: inherit; } }

Member Avatar
Member Avatar
+0 forum 3

I am having a challenge with the spacing of breadcrumbs items in IE8. The attached pics show how the area displays in browsers. Those shots are from a brand new fresh install of Joomla 3. ![65b575f43580aac9921698a85dc658f8](/attachments/small/3/65b575f43580aac9921698a85dc658f8.png "align-left") This is how they appear in IE 8. Notice the wrap of how Home and the arrow are not on the same line. If I am a bit deeper in the navigation, all of the links in the breadcrumbs appear not in a line. ![60650e82c41a4264fa3fc132f916326c](/attachments/small/3/60650e82c41a4264fa3fc132f916326c.png "align-left") In this shot, it displays how the breadcrumbs are supposed to appear and do appear in Chrome, …

Member Avatar
Member Avatar
+0 forum 1

I am trying to debug some CSS in IE8 and the item I need to look at involes either hover or focus. The CSS has to be edited in IE8 for it is filters for IE browsers to achieve gradients. These filters are not showing in Firebug under FF or Chrome. Attempts to examine this by using the Developer tools under F12 or the Debug Bar add-on have not been succesful for examining what is being applied in a hover state. Is there an option such as the one in Firebug to lock the item in that state?

Member Avatar
Member Avatar
+0 forum 1

Is there some standard trick to styling labels and checkboxes so they appear consistently in all browsers? The attatched pic with the label obscured by overlapping checkbox is what I get with Chrome and Safari for Windows. The other attatched pic is what I see in Firefox, IE and Opera. This is the code for the HTML: <div class="login-fields"> <label for="remember" id="remember-lbl">Remember me</label> <input type="checkbox" alt="Remember me" value="yes" class="inputbox" name="remember" id="remember"> </div> The only css is this: .login-fields label, .contact-form label { float: left; width: 8em; }

Member Avatar
Member Avatar
+0 forum 4

I am trying to implement a font package I downloaded from Font Squirrel. The demo included css & html code and works ok but everything is in the root. For the application I am using, I need relvant paths. This is my tree structure: /site-root |--/Fonts | /*.ttf files |--/Styles | /stylesheet.css |--/Text /*.html that will call these fonts This is what I have for my css: @font-face { font-family: 'LibreBaskervilleRegular'; src: local('LibreBaskerville-Regular-webfont'), url('../Fonts/LibreBaskerville-Regular-webfont.ttf') format('truetype'); font-weight: normal; font-style: normal; } @font-face { font-family: 'LibreBaskervilleItalic'; src: local('LibreBaskerville-Italic-webfont'), url('../Fonts/LibreBaskerville-Italic-webfont.ttf') format('truetype'); font-weight: normal; font-style: normal; } @font-face { font-family: 'LibreBaskervilleBold'; src: local('LibreBaskerville-Bold-webfont'), url('../Fonts/LibreBaskerville-Bold-webfont.ttf') …

Member Avatar
Member Avatar
+0 forum 1

I am cleaning up the code in an e-pub file. It was converted from a PDF and a number line break occur where not desired. I am using the following syntax to find the errand breaks `</p>\n\n <p class="calibre2">[a-z]` For replace I wish to insert a space and whatever the character is found by the [a-z]. Is this feasible with only a regular expression replace, no script?

Member Avatar
Member Avatar
+0 forum 9

I am having a challenge with a hover state and css. In this [pic of hovering over menu item Gallery](http://dwlamb.com/hoverChallenge/hoverState1.png) the background bleeds down. This is the code for regular state: #navigace ul.menu li a { display:block; font-size:11px; font-weight:bold; line-height:37px; padding:0 20px; text-transform:uppercase; } To get rid of the bleed state, all I could find that would work was #navigace ul.menu li a:hover { display:inline; } However, if the user hovers over the active menu item - as in [this pic of hovering over menu item Store](http://dwlamb.com/hoverChallenge/hoverState2.png) the background effect changes to only encompass a smaller area of the anchor, …

Member Avatar
Member Avatar
+0 forum 6

I am trying to set-up some virtual hosts on a fresh install of Ubuntu 12.04 and not getting expected results. I am using [this tutorial](http://blog.code4hire.com/2011/03/setting-up-virtual-hosts-for-apache-on-ubuntu-for-local-development/) which I have used before without fail. The challenge seems to come with restarting apache. $> sudo service apache2 restart * Restarting web server apache2 apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName .. waiting apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName If I go through all of the steps, the alias I am trying to establish renders the root …

Member Avatar
Member Avatar
+0 forum 2

Working on some CSS for a WordPress site, I came across this: img[class*="align"], img[class*="wp-image-"], img[class*="attachment-"] { height: auto; /* Make sure images with WordPress-added height and width attributes are scaled correctly */ } Are thes wild cards that will work for any instance of, for instance, `class="wp-image-a"`, `class="wp-image-b"`, `class="attachment-vacation"`?

Member Avatar
Member Avatar
+0 forum 1

I want to use regular expression to clean-up some CSS files. I used a Friebug add-on, CSS Usage, to analyse some CSS from a jquery demo. Exporting the files, this add-on places 'UNUSED' at the front of a declaration and rule. Below is a sample of the output. html #demo-config-menu li a:link, UNUSED* html #demo-config-menu li a:visited { padding:1px 8px 2px; } UNUSED#demo-config-menu li a:active, #demo-config-menu li a:hover { background-color:#f6f6f6; } UNUSED#demo-config-menu h4 { font-size:13px; color:#666; font-weight:normal; border:0; padding-left:18px; } New to regular expressions, I have tried in vain to come up with search parameters for what I want. 1. …

Member Avatar
Member Avatar
+0 forum 2

I am wondering if I am trying to do too much or if there is a better way for a client-side form I wish to create. A limited working prototype for what I have so far appears here: [http://cookbook.dwlamb.com/edit.html](http://cookbook.dwlamb.com/edit.html) I am using a table as the frame for the form so that rows can be dynamically added or deleted (after clicking a checkbox at the left of a row's beinning) I am looking for a method/plug-in that will allow me to sort the form by the Order column. As users enter data, they might forget to add something in sequence. …

Member Avatar
+0 forum 0

I am looking for a method with one or more php functions for manipulating form textarea data. I want to clean it up by indenting it and wrapping it after a certain length with EOL but not necessarily html <br> or <br /> before it is inserted in My database. Or alternatively, I want to take a large block of text from the database and clean it up before populating it in a form textarea. Can anyone offer which series of functions might satisfy these needs?

Member Avatar
Member Avatar
+0 forum 1

Good day, I am working on atomizing a template creating includes in a sub-directory called includes and calling them like this <?php include 'includes/head.php'; ?> I have also tried <?php include('includes/head.php'); ?> My page won't load. All I get is a blank browser window. I tried tailing the error.log and nothing is appearing there. Googling the issue, I have come across this challenge some had on network servers after upgrading from PHP 4 to 5 and Zend optimizer. My server isn't complex as it is only a development environment. Has anyone else had a similar issue and can offer a …

Member Avatar
Member Avatar
+0 forum 10

A script I am writing on works on the DVD present in the drive at time of script execution. I want to extract merely the label of whatever appears after '/media/'; ./script.sh /media/DVDRW-43/ An obvious solution would be to get the substring by `path='echo ${file:7:9}' #renders DVDRW-43` but I would rather a substring extraction based on capturing from the second occurence of '/' to third occurence of '/'. I can't get my head around regex or the substring commands to do this.

Member Avatar
Member Avatar
+0 forum 4

The End.