Assuming want is required, the following 277 results were found.
-
complexity is due to content also being dynamically resized in height. What? Basically I have a menu in a sidebar, I don't want it to overlap the header nor the footer.I have a content page next to it which changes in height dynamically (a separate...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
+ CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE' -- yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = @EmployeeStr -- yields 0 -- After (replacing the = with...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as amazing but old news:...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first thing I did was to create the logic: // default...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
at time of print), I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add an alias to the field: -- Note the alias for the field SELECT COUNT( DISTINCT `my_field`) AS...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this: I want this to happen: The code of this is the addedn overflow:hidden;height:1%;: A long heading that wraps over several lines...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
goes: Why? Because I can. And because as someone said, a "reset" button is so 1990. I have a confirmation page and don't want the button to show so... How? Well edit the HTML... Now to do this, follow the below steps: Find the CSS class name of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want: #copyright a{margin:10px 0 0 85px;box-shadow:5px 5px 5px 0px rgba(51,51,51,0.3);} How? So I'm doing this with a regular...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
input.finalStringLength).replaceAll(" ", "0"); } This looks like pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions instead and is clearer for me personally to understand: // I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
// With URL rewriting enabled www.joellipman.com/index.php/4-category-alias/123-article-alias.html // What I want www.joellipman.com/category-alias/article-alias.html How? You could buy an SEF extension that does this for you or spend time tweaking your...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to Read More" all without hacking away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF