Assuming match is required, the following 53 results were found.
-
K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html
prefix when you installed Joomla! on your site (default is "jos_") then you'll need to change this repair table command to match the database table where your K2 articles are stored (eg. "zu1fq_k2_items").
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
you need to make it visible. These 3 steps will have your module ready: The further steps below are how to configure it to match yours or your clients brief. Style & Colors: Articles & Content: Words & Link: 3rd-Party Integration: Problems?:
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
migrate your users, passwords and all. -- For USERS, we're going to do the following: -- 1) Migrate all users except any matching the new admin in J30 -- 2) Migrate user who's ID in J15 matches the new admin ID in J30 -- 3) Recover odduser's new ID in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Direct Admin but it has some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname must not match any domain that is being used on the system. Example, if you have a domain called domain.com and you want to recieve mail on...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html
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
-
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
-
''; -- 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: *
-
'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
-
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
-
which lets me do the work of many more. I have associates who can step in when necessary but they will not necessarily match my skillset. My associates only get involved when something goes unexpectedly wrong and I do not have the extra time to...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Attributes set. /XA:[RASHCNETO] :: eXclude files with any of the given Attributes set. /XF file [file]... :: eXclude Files matching given names/paths/wildcards. /XD dirs [dirs]... :: eXclude Directories matching given names/paths. /XC :: eXclude Changed...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
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: *
-
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: *
-
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
-
photo or detail to change it. I have pre-loaded it with my own Quadcopter's details but feel free to change them to match your configuration. Tap on a photo to change it's picture. Tap on equipment photo to change its weight. (A future development will...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- 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
-
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: *
-
String to output: Zoho Deluge Validation Checking by Regular Expression: So I could do it the long way in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF