Assuming match is required, the following 56 results were found.
-
to enter the verification code and proceed with resetting your password.\n\n %s \n\nThank you.” Check that email addresses match (case-sensitive!!!): Login to your Joomla Admin Panel Navigate to Global Configuration > Site > Site Settings > Feed Email =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
On the dashboard, note the Scoring key (eg. "64d6d442b7e846acfaacef642e1ad173b35503") On the dashboard, check the site URL matches the domain you are trying this on (eg. if you are testing on "http://test.mycompany.com" then the site specified in the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
for admin images (joomla 3.x) RewriteCond %{HTTP_COOKIE} !JoomlaAdminSession=1234567890 # change this to the code to match the above PHP script RewriteRule .* - [L,F] How-to-use: Browse to the folder you created in step 1 and this will be your new...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work was for a Personnel/HR project, and data...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
this also allows NULLs so, our sequence identifier and student reference are never blank so it is safe to to use "Lookup Match Output" as rows with neither sequence nor student reference will not come through the system. Lookups that failed will return...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
My fault really, the field name aliases specified in my second select query (the one preceded with "open cursor for") didn't match my SSRS report field name mapping. Done! Well almost as you still need to design your report. At least this article should...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Internet Explorer 7 As you can tell, not the most up-to-date but unfortunately I need to stay near to my customer base and match their setups as closely as possible. Objective My aim is to have IE 8 installed as my Windows browser (I wanted IE7 and the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
3 of the columns (which measure in milliseconds) and convert to a time value with milliseconds showing. Now why don't these match? Using in an aggregate, how do I get the milliseconds between start and end times instead of summing the remaining columns?...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
'Not Available', 'dbo'; ** ** ** ** Return Values : Table of two columns: ** ** - Value: Your search term and matching variations ** ** - Source: The table_name.column_name it found this value (Maximum) ** ** ** ** Additional: ** ** - For performance,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
''; -- Declare temporary table to use CREATE TABLE #myScrambledTable (dummyIndex INT); -- Alter temporary table structure to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
of a basic example of getting the agencies belonging to a company (note you will need to change the keys and relevant IDs to match your own solution): // specify provider ID $my_provider_id = 1234; $my_timestamp = time(); // specify company ID...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
597890 I want the third column to say whether this is new or not. How? I found this in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value in B2 exists in range of A2:A100. -- Returns the index of column A in which the B2...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
// yields 30 But just to demo a regex and a one liner, here's a typical regular expression (match all characters not from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber = v_PaymentTerms.replaceAll("[^0-9]",""); // yields 30 And if working with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the number of unique text and number values in cells B2:B10 (which must not contain blank cells) (7) */ =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1)) /* Count the number of unique text and number values in cells A2:A10 , but do...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the decimal number: 0.04166667 - 1 hour of a 24 hour slot or 1/24), you then right-click and format it to time and it should match the results above. The second formula is converting person days into hours and then dividing by 24 (which should return...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB