Assuming variable is required, the following 61 results were found.
-
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
-
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: *
-
, 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
-
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
-
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: *
-
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
-
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
-
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
-
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
-
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: *
-
page (background image filling the page with a logo floating at the centre) and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- 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
-
. " Kb "; echo "Temp file: " . $_FILES["uploaded_file"]["tmp_name"] . " "; The key of the above array is the name of the variable you passed in your HTML form. If the above yields NO empty data (and size is not 0) then it was successful. If not, then...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- 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: *
-
'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
-
trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following loops through directory for any file...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for...
- Type: Article
- Author: Joel Lipman
- Category: Microsoft
- Language: en-GB
-
which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *