Assuming here is required, the following 192 results were found.
-
The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time gets stored in... Resources...the one with the codes...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
$user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test account') AND u.TeamID='$t_value' ORDER BY CONCAT(u.FirstName, ' ', u.LastName) "; Activity...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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 country by IP address list that we can use when parsing our website logs to check where visitors were...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
of time recording and activity logging. The example below however is within a LAMP/MySQL environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me. What I want: ThisDate ThisDay StartTime TimeOut...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
this overwhelming. It's in business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my freelance website development...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1 This method...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
but that's not an excuse. I also found that examples across the web were only partial and thought I'd write a full example here. No jQuery and using the Google Chrome browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
cURL function to receive and send the data. cURL is a standard feature on most LAMP setups. If not you can install it from here: http://curl.haxx.se/download.html I'm demonstrating this with 3 scripts on the intermediary server: 1. to display the HTML...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
sub-component of PHP that allows you to send and receive requests as the server (as opposed to the client device). Why? Yes there's documentation online that TravelPort provide you with but it didn't help. The error I'm going to address has to do with...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
work FIND("″",B1) // will work You could merge all the statements into one but for simplicity's sake I'm putting each step here: In column C put the formula: =MID(B1, 1, FIND("°", B1)-1) In column D put the formula: =MID(B1,FIND("°",B1)+1, FIND("′",B1)-...
- 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: *
-
decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
Radio Controlled cars at the Torch Racing, UK event last Sunday. The FPV latency isn't good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I treat it like a First-Person-Shooter game where I...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
on a small client script to set the Account field on the Quote from a lookup field on the Deal record. Why? The use-case here is that I have a client who is a supplier. The opportunity (aka Deal) will be in the end customer's name so it is their name in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for this solution. In the end, I found it hidden away in the Autohotkey help file and not under the gui events... The issue here is if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB