Assuming should is required, the following 192 results were found.
-
and it doesn't have a clue. Anyway, enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
hour. How? I used to use a lot more PHP but since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
in 37:00 total. // Our working week starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your first query should loop through the users list, within the loop run the activities query and replace the string...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
For those of you who are familiar with this, I am simply using an alternative to the DATE_FORMAT() function in mySQL. Should yield: AcademicWeek Mon Tue Wed Thu Fri CalendarWeek -------------- ----------- ----------- ----------- ----------- -----------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
@stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET @stringtoReplaceWith=' ';...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Files Please submit any images, videos or files that will be included in the project and that our design and direction should focus on. The end product will revolve around what you submit here. For you to do: Submit drafts or sketches (rough layouts -...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
throughout other systems. IMO: Somewhere in the Javascript (based on jquery), the script is using the remainder when it should be discarding it.
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
directory is writable by Apache. This is the full path to the folder that you will be uploading the files to and should be 755 (ie. rwxr-xr-x). The change ownership command in shell is 'chown -R apache:apache '. 3. Check that your PHP ini specifies a...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
$title = $row->title; } This fix has so far worked for Arabic, Chinese, Hebrew, Russian, and Slovak. Fingers crossed this should work for all characters that Joomla! can handle by default anyway. Cause: Q. Why does this work for Joomla! articles and not...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
unit value to its label for($i=0;$i0 ? $a_UnitValues[$i].' '.$a_UnitLabels[$i] : ''; // grammar for plural/singular (should always be a positive number) $v_Str .= $a_UnitValues[$i]>1 ? 's' : ''; // only add to array if not empty/zero if($v_Str!='')...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
to create a vertical guideline. Click one of the fields in the section, and drag it to the vertical guideline. The field should ‘snap’ to the guideline. When the corners are highlighted in red, this indicates the field is snapped to the guideline....
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
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 substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
this is so that the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
much) 3 plugs in. It came with heat shrinks to join the power cables but I may change this to a plug later. Hmm... maybe I should have painted my Phantom in chrome. My DJI Phantom FC40 repainted and gimballed. Very close to the ground so will have to...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
if there is a vehicle underneath... Um, so I'm sharing the marshall's area. {youtube}L0uJyA6sXKk{/youtube} I reckon they should make drones that go right a tipped over car or bring it back to the track... Then again, couldn't those cars self-right...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
the jQueryMobile library but that started messing up the template layouts for me. I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and...
- Type: Article
- Author: Joel Lipman
- Category: Bootstrap
- Language: *
-
Sign in with your Amazon username and password. After you have logged in, look for the menu option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and content > Manage...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
to Accounts) field. EITHER the Distributor or Reseller field will be populated but this will be the company the quote should be raised for. Setup up the Client Script: Login to ZohoCRM > Setup (cog icon next to profile photo) > Developer Hub > Client...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB