Assuming note is required, the following 299 results were found.
-
A quick note on a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How? Options -Indexes +FollowSymlinks...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
messages were somewhat vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
the web application to use the newly uploaded report, export to a Crystal Report, which in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
"Sort" Select "More Sort Options" Select "Ascending or Descending" and select "Month" (or name of field) from the dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note: Office 2010: If items did not sort, then remove the column...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
40°4′20″N 116°35′51″E Beijing Shahezhen Air Base 40°8′57″N 116°19′17″E Beijing Tongxian Air Base 39°48′40″N 116°42′30″E Note that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that these don't automatically...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
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 myCount FROM my_table; Method #2: Count from results (my...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote character to the beginning and end...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
thread. First getting the messages relating to this chat: You will need a connection that has the necessary scope(s). Note that you have to do this as the super admin to get organization level messages. But in ths example below, we're going to query a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
this stage that I lost track of all the different configurations. The 2nd diagram is the working configuration I have now. Note that I've moved the bottom screens in the display settings to be next to each other as I found moving my mouse from 4 to 5...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
of the HTML part. This is the code in full; apologies for the mess coding but it's a mix between HTML and autohotkey syntax (note we're making a table with 9 columns and 6 rows - there's a spacing column on either side): htmlText:="" htmlText:=htmlText...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
"\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB