Assuming last is required, the following 98 results were found.
-
array($db->quote('Joe'), $db->quote('jlipman')) )); $db->setQuery($query); $result = $db->query(); -- retrieve last inserted ID $last_inserted_id = $db->insertid(); UPDATE using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
= json_decode($response, true); return $output; } 5. Get Minutes Remaining on cached token So usually an access token will last for 60 minutes, in this example, we are going to store the token value so it is reused until it is about to expire. Firstly,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[position()=1]') FROM [dbo].[XML_EVENTS] -- to get employee node at last position from root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[last()]') FROM [dbo].[XML_EVENTS] -- to return...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
---------------- -------------- 04/03/2011 Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
; split into an array StringSplit,ReturnedHTMLTableCols,ReturnedHTMLTableColString,| ; add to last found listview LV_Add("", RowIndex, ReturnedHTMLTableCols1, ReturnedHTMLTableCols2, ReturnedHTMLTableCols3, ReturnedHTMLTableCols4,...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); // removes last row which is undefined (ie. "]") myRecords.pop(); // loop through array for (i=0; i
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
hours, holidays and emergencies, added 20/hour Add 20 for restore disk Questions for customers: What do you need to do? Last time it worked? Emails received since? Programs installed since? Alternative documents/programs to do this? Same errors on...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
environment? Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation since the service last worked? Suggestions...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
output port: I connected 1 DP to miniDP cable to the 1st monitor, then another cable from the 1st monitor to the 2nd, and lastly another cable from the 2nd monitor to the 3rd (in other words, a Daisy Chain). New Setup Diagram: The graphics card (RTX...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
Const WM_SYSKEYDOWN = $0104 Const WM_SYSKEYUP = $0105 Const WM_SYSCHAR = $0106 Const WM_SYSDEADCHAR = $0107 Const WM_KEYLAST = $0108 Const WM_IME_STARTCOMPOSITION = $010D Const WM_IME_ENDCOMPOSITION = $010E Const WM_IME_COMPOSITION = $010F Const...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
(original is AHK Basic only, but here is an AutoHotkey_L Version by sinkfaze) Basic Webpage Controls COM Object Reference Last edited by jethrow on Wed Jun 22, 2011 10:18 pm; edited 22 times in total Source: Jethrow @ Autohotkey Forums
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
; Platform: Win9x/XP ; Author: Joel Lipman ; Date Created: 15-July-2014 ; ; Script Function: ; Just a countdown for my last days at BU. ; ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
desk and not in the order of left to right. So the above code tries to determine the leftmost monitor and rightmost with the last being in the centre. First of all here's the code to open a windows application on a non-default monitor: ; Get full screen...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We could have tried out some...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
thread, and you are not allowed to create more than one thread per topic. No Posting Personal Info - You may not post your last name, or your street address on TEU. This is because this information then becomes accessible to anyone. No Threatening to...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have proposed stupid extensive solutions when all you need...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
the following (the string to replace here is " (Copy)" without the quotes) - this is a READ-ONLY process if you leave the last line commented/remarked @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR /f "tokens=*" %%a IN ('dir /b *" (Copy).jpg"') DO ( SET...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
{ English_Ordinal = Ordinal_Map.get(My_Date_Field.toString("d")); } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *