Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is 3306. Specifying port Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Named pipes...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 this resolved all 3 issues below!!! Encountered Issues ORA-01403 no data found & ORA-06512 something else - Fixed by specifying the query parameter properly (ex: Parameter name = p_STUDENT_ADNAME, Parameter Value = [@StudentReference] - NOTE THE SQUARE...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 Object Size and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY coordinates. Export the report to Excel and all the fields in the section appear in the same...

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

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 shown in the following picture: And I want the clouds as another layer ontop aligned to the top right: Tried and failed: Specifying the width of the div layer the same as the image and positioning the div. This causes a scrollbar at the bottom. Tried...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 like "000065.bmp". Do not include the file extension (and the dot/period) as this is set in the program options (specifying output thumbnail file type). For example: the line "www.joellipman.com | best_site_ever" (without the double-quotes) will result...

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

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves the...

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 would disappear when the page finally loaded. How? The root cause was because the template I was using was not actually specifying "white" as the contents background-color and was in fact setting a gradient as the background. Consider the following: /*...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

28 October 2013 zero or one--and only one--occurrence of the preceding character or subexpression. You can think of this operator as specifying an expression that is optional in the source text. For example, to find--'a', optionally followed by 'b', then followed by...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 match any part of the absolute path of the file to be copied, that file will be excluded from being copied. For example, specifying a string like \obj\ or .obj will exclude all files underneath the directory obj or all files with the .obj extension...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 charset attribute to posting HTML forms: accept-charset="utf-8" Conclusion: The final fix in my case was due to me not specifying some extra parameters on the htmlentities or htmlspecialchars PHP functions. My database stored the foreign characters as...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 class because it's pretty descriptive. Unfortunately setting the width/height in cm was causing havoc to my template. Specifying only a font-size, font-family, margins and page-break-after was pretty much the only change I can do to this class.

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

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 The code is a for loop which iterates through each row, assigning an entry for a new product or account, and specifying the quantity for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 the current date, then set it to the last Tuesday of next month. Why? This was a request by a client who instead of specifying the 1st of every month, or 15th of each month, to say the first Monday of the month (ignoring bank holidays) or to say the...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 r_Response = invokeurl [ url :v_DataEndpoint type :GET connection: myConnector ]; Solution: My endpoint was specifying COM instead of EU as per the client's data center: v_DataEndpoint = "https://books.zoho.eu/api/v3/contacts?organization_id=123456789";...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 my custom javascript file referring to the ZOHO.CREATOR.init() and calling Creator records. ./plugin-manifest.json: JSON specifying service as "CREATOR". Error(s): When trying npm install -g zoho-extension-toolkit: Error: EACCES: peermission denied Run...

• 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 Re-run GetNotificationPreferences Just as a double-tap, let's run my GetNotificationPreferences function above specifying the "PreferenceLevel" to "User" to see the user notifications I just created. I get the following response:...

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

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 with a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time of print, this is the only way I know: add a note...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 (if there's another way, I'd love to hear it). We don't have more than 100 product categories so we'll just to page 1 but specifying 100 per page as the default is only 10. // // API keys (these are made up so enter your own in these 2 lines below...

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

Set default parameter dates to start and end of monthhttps://www.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular...

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

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 If this is set to "avoid", then change it to "auto" Additional You may also need to remove the child tags of the table specifying the above CSS.

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