Assuming data is required, the following 229 results were found.
-
to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`, `introtext` intro FROM...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
out. The brief was pretty much just "...fast and works with cms articles...". If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
The Joomla! articles were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
assuming value of DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep our XSLT with some slight modifications. First...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
container. - Added div and parameter "module class" so that class name actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values. - Date Uploaded: Fri, 30th Jul 2010 1.1 -...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
Inline Images - Removed Parameter: Force No Borders - Removed Parameter: Display rank - Enhancement: Model handles database and library variables, Views controls the HTML layout - And tweaks so I have as little to setup on each website :c) - Date...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
= ''; // specify target url and version $apimo_url = 'https://api.apimo.com/api/call'; $apimo_version = 2; // specify data output $apimo_method = 'getAgencies'; $apimo_type = 'xml'; // specify key and encryption $apimo_key =...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
to it working: Checked all headings text boxes are aligned to one gridline and they're the same height. Checked all data field text boxes are aligned and the same width as their respective column heading. Remove any ruler gridlines that don't truly...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
to sort the values Note: Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button Add the column back to the "Row Labels" Move the field back into "Report Filter" Done! The filter dropdown...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
to round brackets, square brackets! Additional: I have made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields go in "Report Filter", "Column Labels", "Row Labels" and sum "Values". But...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
on a criteria var my_array = populate_array_from_csv(this_file_url); // eg. var my_array = populate_array_from_csv('./mydata/data.csv'); // ---- End-ofFile Additional Information(s): StackOverflow: Split string by comma, but ignore commas inside quotes...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Returns false if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive search with the first parameter being the text to search for (can be a range)...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
DVD±RW 24x SATA Drive with Dust Protected Enclosure and Emergency Eject - Sony £17.77 Other 2 X Serial ATA Sata Hard Drive Data Cable Lead - Unbranded £0.90 Total £189.75 Confirmed for January 2013 (2 suppliers): Motherboard / CPU / RAM Bundle Intel®...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *