Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 GUI, hovering the mouse over other objects will no longer cause the search button to flicker. More...? How about having the cursor change to hand when you hover the mouse over the image: /* IDC_ARROW := 32512 IDC_IBEAM := 32513 IDC_WAIT := 32514...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 we can increase the number of pages as well as the number of products per page: The GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: { productVariants(first: 10, query:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 R2 report. How? If you've googled this topic as much as I have, you'll note that everyone seems to be recommending using a cursor. I went through about 10 pages of google results without working out how to use these in SSRS and then resorted to my old...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 && TAKE_OR_PICK == 2) { Uri selectedImage = data.getData(); String[] filePathColumn = { MediaStore.Images.Media.DATA }; Cursor cursor = getContentResolver().query(selectedImage,filePathColumn, null, null, null); cursor.moveToFirst(); int columnIndex =...

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

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

23 September 2009 a search using your default search engine. Click the address bar, then press Ctrland the left arrow together. Moves your cursor to the preceding key term in the address bar Click the address bar, then press Ctrland the right arrow together. Moves your...

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 BIT DECLARE @ChosenID INT DECLARE @SqlStatement NVARCHAR(MAX) DECLARE @UpdateSqlStatement NVARCHAR(MAX) DECLARE @UpdateCursor CURSOR CREATE TABLE #Scramble ( ID INT identity(1,1), ScrambledID INT, Data VARCHAR(MAX), Chosen BIT ) -- To dynamically insert...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 !important;} Then get rid of the round circles for radio inputs / and ensured the cursor remained as a hand to indicate clickable: div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(2){display:none;} div.zc-Calendar_Day_Select...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 How? We're going to use the onBlur and onFocus attributes which do, as the name indicates, trigger events when the cursor is either in the field or not. The above field was created with the following code: Explanation type="text" - standard attribute...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 previously and what we needed to get them working. Custom DataSource Upload the report to the ReportServer. Hover the mouse cursor over it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the...

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

Mouseover Links in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 this all about? Well I want the basic hover effect: when my mouse cursor hovers over a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How?...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 WM_ACTIVATEAPP = $001C Const WM_FONTCHANGE = $001D Const WM_TIMECHANGE = $001E Const WM_CANCELMODE = $001F Const WM_SETCURSOR = $0020 Const WM_MOUSEACTIVATE = $0021 Const WM_CHILDACTIVATE = $0022 Const WM_QUEUESYNC = $0023 Const WM_GETMINMAXINFO = $0024...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 instructions above on how to execute a vbscript and then paste the below into the developer window. Ensure that your mouse cursor has focus in the first subroutine "RunAll". Here's a quick summary of what the below script does: Splits one spreadsheet to...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 Internet Explorer which is very handy, but unfortunately it doesn’t work in Firefox or Chrome as yet You can also move your cursor to the lower right corner of your screen to get a preview of your desktop, click and you will be brought to your desktop...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 eg. 0.5, this will result in the thumbnail having 50% opacity to start with when the page loads; when you hover the mouse cursor over it the thumbnail will regain 100% opacity. Target Window: Rokbox? Demo'd on my personal website because I am using a...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 ID: CREATE OR REPLACE FUNCTION fn_get_sref_from_adname (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1;...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 } ul.listafter li{ width:59px; height:52px; margin:0; padding:0; color: #000; background-color:red; border:1px solid #000; cursor:pointer; float:left; vertical-align:bottom; font-size:40px; font-weight:700; line-height:50px; text-align:center; }...

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

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

11 October 2012 SET @myCounter = 0; SET @minStrLen = LEN(@p_SearchString) - 1; SET @maxStrLen = LEN(@p_SearchString) + 1; -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• 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 Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM @myXml.nodes('/root/s') T(c); -- Create temporary table to...

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