Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 images or that you can send these in a cURL request (same thing really): string API.fn_ShopifyQuery_UploadPhoto(int p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 "description"); return desc; } Modify for date and description RssAdapter.java (getView) @Override public View getView(int position, View convertView, ViewGroup parent) { ViewHolder holder; if (convertView == null) { convertView = View.inflate(context,...

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

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

23 April 2011 as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I separated off the...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 contents of the displayed slide. Hide currently displayed slide to expose the first slide again (restores the starting position of "next slide"). The Gist Strategy This may not be a great idea, I'm just trying something out. The brief was pretty much...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 layer. In a joomla CMS template though, I wanted the "left" div to take over the whole page if there were no modules positioned in the "right" div. I specified width of left using PHP. This is the CSS though: #container { position: relative; } #content...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 AS VARCHAR(10)) + ')' END FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- Get First Column Name SET @ColName=( SELECT COLUMN_NAME FROM...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 node with ID = 1 SELECT Event_XML.query('//EMPLOYEE_NUMBER[@ID = 1]') FROM [dbo].[XML_EVENTS] -- to get employee node at position = 1 from root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[position()=1]') FROM [dbo].[XML_EVENTS] -- to get...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 be in a function that is called from the Zoho Creator page. Functions are read by Zoho and certain CSS attributes (such as position and float) will be removed automatically. The code has to be pasted directly in the Page and then the CSS attributes will...

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

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 { if (document.documentElement.scrollTop > match_lowest_y || self.pageYOffset > match_lowest_y) { $('jdo_actions').style.position = 'absolute'; $('jdo_actions').style.top = match_lowest_y + 'px'; } else { $('jdo_actions').style.position = 'fixed';...

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

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 an existing window. Opens the tab in the existing window. Press Esc while dragging a tab. Returns the tab to its orginal position. Ctrl+1 through Ctrl+8 Switches to the tab at the specified position number on the tab strip. Ctrl+9 Switches to the last...

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

Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 (the ones that appear in the ruler as little arrows). So right-click on a heading text box that works Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size and Position..." Paste the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 Repeat step 2 until all the fields in the section are snapped to the vertical guideline(s). Set the object’s size and position by right-clicking the field, selecting Object Size and Position and then setting the XY coordinates. Use the horizontal and...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 WHERE `id`='1'); INSERT INTO `my_new_database`.my_prefix_contact_details ( `name`, alias, con_position, address, suburb, state, country, postcode, telephone, fax, misc, image, email_to, default_con, published, checked_out, checked_out_time, ordering,...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 format: ; tell the script which content to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character positions) Needle1a := " My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole content Needle1b := " " ;...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• 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 try to set them to the size that they will print out in. Then re-upload them noting the SRC of the image so that you can position it as per your requirements. That should do it.... The Gist Don't load in images bigger than an A4 sheet... Additional...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 Item 1 1.1 Item 1a 1.2 Item 1b... 1.9 Item 1c 1.10 Item 1d 2. Item 2 // What I DON'T Want (happens if you use list-style-position: outside) 1. Item 1 1.1 Item 1a 1.2 Item 1b... 1.9 Item 1c 1.10 Item 1d 2. Item 2 How? I've been refining this based on...

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

Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 forum but I thought I'd put how I resolved this here. The issue is basically that you want the background to stay in its position in the browser while the rest of the elements scroll about. Go to Extensions -> Template Manager> Edit the CSS for the...

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

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote: This cannot be done by...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 this --> http://www.brandonitconsulting.co.uk/mod_metamod/ **In this example I'm using Joomla 1.5.10 and the 'menu' module position.** 1. Create two menus, mine are named 'pubmenu' and 'regmenu'. (Assuming you already have a menu - easiest thing to do...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the...

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