Assuming before is required, the following 109 results were found.
-
of a row $a_user_email = $rows[2]->email; Get a Row Count - getNumRows() Note that in Joomla, you have to run the count before using the data! $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select(array('name', 'email', 'username'))...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there is a chance one of your date...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
and press Return/Enter. This has to be a label to the name of the column enclosed between square brackets or double-quotes: Before: SELECT calendar.WeekNumber AS [Academic Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update that fixed my issue. check that this issue isn't being...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
' ', u.LastName) "; Activity Query $w_value = $number_of_weeks_from_now; // usually 0 for this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
display: table; margin: 0; padding: 5px 0 5px 15px; } ol > li { counter-increment: myCounter; display: table-row; } ol > li:before { content: counters(myCounter, ".") ". "; display: table-cell; position: relative; left:-12px; } li ol > li:before {...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related SMG Run SMG from the menu system...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
as the AHK script. It took me a while to get the tooltip to show until I realised you have to specify the tooltip text BEFORE the gui,show command. The above example is used in a search form where "SearchButton" is the name of the variable (picture) to...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
to built-in functions for AHK) alert(), getElementById(), getElementsByName(), getElementsByTagName(), focus(), click() Before we begin, this tutorial will be using examples that start with javascript: - which you will feed through the URL Address bar....
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
you see words in your post being replaced with ****, you have done something wrong. Please edit your post and tone it down before your timer runs out. To edit a post, click the "Edit" button right below it. Cheating the censor system is against the...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
The Gist -- What I have Image00001 (Copy).jpg Image00002 (Copy).jpg -- What I want Image00001.jpg Image00002.jpg How? Before I continue, the undo may work in MS Windows (Control key + Z) but don't count on it. I'm going to use a short batch process but...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
version and deleting the original. SAMPLE USAGE: If you have a portable media player that needs to convert media files before they can be transferred to the device, then this will list all the originals you no longer need and send them to the "Recycle...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my target deploy...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Before you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery and MooTools) conflicting with other scripts but do...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
• A private key to use JoelLipman.com data Note: You should delete/uninstall this app or clear its data before giving your device to someone else as it can login to your online account automatically. Sharing: • Do not share security or personal details....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Zoho Deluge. Why? The aim here is to have a scheduled task that on the 1st of every month, takes the invoices for the month before, and duplicates each one for the new month. How? First you have to get all the applicable fields from the settings API. In...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
screen has interrupted the connection. Your information is still secure because Google Chrome stopped the connection before any data was exchanged. You cannot visit 127.0.0.1 at the moment because the website sent scrambled credentials that Google...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
right of the modal */ .popupClose{position:relative !important;z-index:1000;top:28px;right:46px !important;} .fa.fa-close::before,.fa.fa-close::after{background:#999 !important;} 2. Trigger the notification There are several ways to display this as a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *