Assuming while is required, the following 92 results were found.
-
This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the ReadyState property, which should work in may scenarios: Code: ; AutoHotkey_L: pwb.Navigate( "www.AutoHotkey.com" ) While, pwb.ReadyState 4 ; While, pwb.Busy Sleep, 10 Code: ; AHK Basic: COM_Invoke( pwb, "Navigate", "www.AutoHotkey.com" ) While,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
The Mermaidhttps://www.joellipman.com/component/content/article/the-mermaid.html?catid=96&Itemid=165
did espy a fair pretty maid, With a comb and a glass in her hand, Her hand, her hand, With a comb and a glass in her hand. While the raging seas do roar, And the stormy winds do blow, And we jolly sailor boys were skipping up aloft, And the land lubbers...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
as database fields, column header text objects, and summaries or subtotals) in the column by holding down the Shift key while clicking each field, until all the fields are highlighted. Right-click any of the fields, click Size, and then select Same...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
v_NewName := StrReplace( v_NewName, a_FilterOutWords[ A_Index ], "") ; loop until there are no more double spaces while InStr( v_NewName, " ") v_NewName := StrReplace( v_NewName, " ", " ") ; trim any leading/trailing spaces and put back the extension...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Took us a while to find this and perhaps others would have a quicker way but here's the instructions on getting the records from the performance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
value. At times, it can be useful to copy and paste or temporarily format logic across multiple lines to improve readability while writing or reviewing code. Do bear in mind that once the script is saved and re-opened, the code will be reformatted back...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep --invert-match '^($|\s*#|\s*[[:alnum:]_]+=)' | sed --regexp-extended "s/\s+/ /g" | sed...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text "The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was easier to work out: Open the Report in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS ADDED TO REGEXP (eg. apostrophe) WHILE (@i 0 BEGIN -- get the delimited word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i SET @CaseValue =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
BEGIN DECLARE @StringValue VARCHAR(10) SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput) - 1, -1), LEN(@StringInput))) SET @StringInput =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
If ( VarSetCapacity(xDetails) = 0 ) ; Init static variable { i:=-1, xDetails:={}, xDetails.SetCapacity(309) While ( i++...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
does not exist and copying more than one file, assumes that destination must be a directory. /Q Does not display file names while copying. /F Displays full source and destination file names while copying. /L Displays files that would be copied. /G...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
account and then to reconcile these. This particular case covers where the Cx had a working automatic bank feed for a while but at some point simply stopped working. How? First let's go through a resolution and get the official response on what impact...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
TABLE_SCHEMA='dbo' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
an hour and I am blowing past that quickly with just 1 person (me!) on the site so they just refuse the connnection after a while. Obviously something is not right. I am searching the forums for an answer and if I don't find one I'll repost. I just...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like: $result=mysql_query($user_list_query); while($row=mysql_fetch_assoc($result)) { $this_user_id=$row['UserID']; $this_user_full=$row['Fullname'];...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB