Assuming from is required, the following 413 results were found.
Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html
on the website. Unauthorised use of this website may give rise to a claim for damages and/or be a criminal offence. From time to time this website may also include links to other websites. These links are provided for your convenience to provide further...
Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html
the eggs into it. Then begin whisking the eggs - any sort of whisk or even a fork will do - incorporating any bits of flour from around the edge of the bowl as you do so. Next gradually add small quantities of the milk and water mixture, still whisking...
on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an...
EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the...
my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence Development Studio (BIDS) IDE from Microsoft. Required: Windows XP (ODBC Data Source...
engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple terms are not supported;...
of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep --invert-match...
network - joellipman.com is not a social networking site). I don't have a newsletter so it's unlikely you'll ever hear from my site. I never email for personal details, passwords etc so if something comes from my site it should only be if you contacted...
2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour...
SELECT ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName WHERE ItemDate BETWEEN '01/01/2010' AND '08/01/2011' GROUP BY DATEPART(dayofyear, ItemDate), DATEPART(year,...
a list of month names? January comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter" to "Row Labels" (put it at the top as parent) Right-click on the pivotTable on one of the values of the row...
the following, the first query is how MySQL interprets the query and the second is what I want it to do: SELECT value FROM my_table WHERE my_id IN ('1, 2, 3') SELECT value FROM my_table WHERE my_id IN ('1', '2', '3') The Solution I must confess that the...
admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you got from revolvermaps.com into the module parameter. Important Note: The ID it installs with is for my demo site. If you want to...
use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my...
So this is an article to serve as documentation for one of the data sources available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a refreshable...
the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data as to your...
note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin...
companies). This will have an impact on some of the systems date and time operations (eg. if you get an e-mail at 2am PST from the server, this is also 10am GMT – e-mails from people will use the timezone they are accessing the service from). Additional...
v3.2.3 (Joomla.org) jComments v3.0.0 (JoomlaTune.com) PlayThru v1.1.8 (AreYouAHuman.com) What? This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using the alternative...
changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break...