Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 could have been any table with more than 52 rows, I'd say specify the table you will NOT be adding these rows to... SET @count:=0; SELECT '2012/2013' AS SetID, (@count:=@count+1) AS WeekNumber, @thisDate:=DATE_ADD("2012-07-09 00:00:00", INTERVAL...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 $db_prefix = (trim($db_prefix)=="") ? "":$db_prefix; $db_connect = mysqli_connect($db_host,$db_user,$db_pass); $content_count = 0; // CONNECTED! so run a SQL query as per usual if (!mysqli_connect_errno()) { $query='SELECT COUNT(*) as ArticleCount FROM...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 ** ** 12/10/2012 Jlipman 1.1 Merged into one query. ** ** Added schema to column_source. ** ** 15/10/2012 Jlipman 1.2 Added count column to final results. ** ** Added minStrLen and maxStrLen for more accurate matches. ** ** Changed order by...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 loops through every contact and deletes the duplicate lead (if a lead exists with the same email as a contact): // init v_Count = 0; v_CountDeleted = 0; // // sort criteria for our selection m_Criteria = Map(); m_Criteria.put("sort_order","asc");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay account as soon as the order or transaction is made on a Fixed Price item. How? So first of all, you'll need an access token:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 This should go without saying, but you are not permitted to hack the board. Guessing someone else's password and succeeding counts as hacking. Members who hack will instantly be permanently banned without any warnings. No Discrimination, - You may not...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 matches all of the following sequences: ac abc abbc abbbbc The expression does not match: adc Interval — Exact Count The exact-count interval operator is specified with a single digit enclosed in braces. You use this operator to search for an exact...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 you should run the respective commands to update the Installer ID in these as well. Copy over users (but with disabled accounts): CHANGE the value of @v25_admin_id to the number (in my example "42") to the admin ID of your installer ID. --...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 repeats the header on every page. The key here is the HTML attribute zcpage-headerhtml: My Company Ltd Test Street, Test County TEST1 ZIP1 +44 (0)1234 567890 sales@mycompany.com QUOTE The Quick Answer: the footer This repeats the footer on every page....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 ", ",").toList(); // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at least 10'000: // v_Counter = 0; l_Loop...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 1 Joel Lipman 2 JOE THE GREATEST DECLARE @EmployeeStr = 'JOE ' + CHAR(9) + CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE' -- yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM Employees WHERE...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 Layout is "Standard" Event Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This includes a function which counts the number of decimals. I didn't need to use this method for my client; just rounding the decimals would suffice but here is my...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Article (for ChangeLog) --- Specify URL (for Support) --- Specify URL (for Demo) --- Like/Share in Facebook --- Download count (total of all versions) --- Permanent URL for this page (must ignore SEF, eg. "?option=com_joesbugtracker&id=") ---...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first error is recorded ByteCount bigint NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows returned from queries. Conversions...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 '?p=', id) AS guid, '0' menu_order, 'post' AS 'post_type', '' post_mime_type, 0 comment_count FROM my_joomla_db.jos_content ORDER BY id Importing the joomla categories to Wordpress: (still to do: sections as parent categories?) SET...

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 we had a convoluted query which needs to join the two tables so that we get the "MapOut" value: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, false); if(!b_Exists) { // insert into Product table r_ProductCreate = insert into Product [...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *