Assuming variable is required, the following 59 results were found.
-
BY b.user_name ) t2 GROUP BY MONTH(t2.Date); Notes: I use this in a PHP script so where year is specified (2010), I have a variable posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous guests count as...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
before you commit changes -- II. Copy content from the old database to the new database and tweak: -- -- 1. setting some variables -- -- 2. jos_banner -> #__banners -- -- 3. jos_bannerclient -> #__banner_clients -- -- 4. jos_bannertrack ->...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
and source code of each element by dragging the curser over the webpage. Frequently Asked Questions What is a pwb? - A variable that contains a pointer to the web browser object (Internet Explorer). Here is a simple script for creating one: Code: ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html
01–53 %V week of the year 01–53 Month %m mm month 07 %h Mon Jul %b Mon, locale's abbreviated Jul %B locale's full month, variable length July Year %y yy two digit year 00–99 %Y ccyy year 2011 %g 2-digit year corresponding to the %V week number %G...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
You can specify command type and stored procedure name here or you can do this in the next screenshot. Note how all our variables are hidden and cannot be NULL. If you're unsure, right-click on your dataset and bring up its properties... Specify the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
results of this stored procedure. The following are commands that I would run to view the results of the above example: VARIABLE myResultSet REFCURSOR; EXEC sp_get_studentdetails_from_ad(:myResultSet,'jsmith2012'); PRINT myResultSet; Should yield...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
defined function CREATE FUNCTION ufn_DataJumble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int;...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later. style="color:grey" - add a styling to it by default (on initial load), in...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at NUMBER := 0; -- v_char_at : internal variable for string indexing v_rand_param1 VARCHAR2(50) := ''; -- v_rand_param1 : parameter 1 for dbms_random function v_rand_param2...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
function CREATE FUNCTION ufn_DataScramble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
on the dot/period (.) and use substring in a sort of reversed form. For argument's sake, I'm assigning this string to the variable "haystack". How? Perhaps we should determine the position of the last needle first (reverse the haystack string and find...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
, ComponentType = ComponentType.Transform)] public class MyConvertToProperTransform : PipelineComponent { // Create a variable which is used to identify the data column being processed private int[] inputBufferColumnIdx; // Create variables used in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
/J Copies using unbuffered I/O. Recommended for very large files. The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line. Other Sources: Download Microsoft Windows Server 2003 Resource Kit...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
FROM [dbo].[XML_EVENTS] Looping -- From resultset of $i ,assigning it to variable $j using let clause, -- Getting top two employees by using where & order by clause. SELECT Event_XML.query('for $i in /STAFF/student let $j:= $i where ($j/@ID)
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
PHP code to work in earlier PHP versions. - Fixed bug: could not see Hebrew text. - Fixed bug: refer to $fulltext variable which is now obsolete. - Date Uploaded: Mon, 25th Oct 2010 1.2.1- Removed some word OTT extraction functions (eg. applet, map,...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
to change the Admin ID to a number that hasn't been taken yet or to use the current one and is specified as a local variable. -- Specify v2.5.x admin ID and v3.4.x admin ID SET @v25_admin_id=42; -- Set this to the ID number of the user in your Joomla...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
'text/csv'); // send request to the server xhr.send(); // return contents of target file to JS variable var my_csv_file_contents = xhr.responseText; // split contents into array of rows // store each line of the CSV file into a JS array var...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
registered the app with the Google developers console along with the redirect URI being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; //...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
go through each section of the code to go through the logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF