Assuming times is required, the following 46 results were found.
-
@NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
** ** - myValue: the distinct values ** ** - myColumn: the column this value was found in. ** ** - myCount: the number of times this value was found in this column. ** ** ** ** Link to other SQL Server collations:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
) String Length LENGTH(string) BIT_LENGTH(string) CHAR_LENGTH(string) LEN(string) DATALENGTH(string) Dates / Times Weekday Name DAYNAME(now()) DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now())...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html
sequence Specifies that the child elements must appear in a sequence. Each child element can occur from 0 to any number of times simpleContent Contains extensions or restrictions on a text-only complex type or on a simple type as content and contains no...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
developing in SITS, and you use the client, the first time(s) you do this, the task is rather daunting. Having done it a few times and run through a few, I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again....
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
XML and language file review - Date Uploaded: Tue, 18th Mar 2014 3.2- Fixed Bug: Redeclare function issue when used multiple times - Date Uploaded: Mon, 17th Mar 2014 3.1- Backwards compatible with Joomla 2.5.x - Modified for Joomla 3.x (tested on 3.1.x...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
to above functions } string generateKidSafeRetrievalCode() { // init v_Output = ""; l_BadWords = {"My","Bad","Words"}; l_TimesTried = {1,2,3,4,5}; // loop through times you will chance it for each v_TimeTried in l_TimesTried { // init b_BadWordFound =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of debugging/testing when you can't seem to access that bit of information Zoho is reluctantly letting you have (such as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
"info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities. (Zoho if...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
behave like this; specifically when there are a lot of line items as per my screenshot here: How? This has been raised a few times by multiple clients but the fix is rather quick as long as you can get to the HTML of the template: Login to ZohoCRM >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
2 parameters, the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string with this many spaces using leftpad...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
which is possibly all your data being mapped, associated, and imported... I personally had to refresh the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where it left off and ultimately...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Pose S-Shape Pose Sitting With their Back to the camera Period / Age {module title="Joel Lipman's List of MidJourney Times"} in the year «Year» 60s 90s Autumn during the Dark Ages at Dawn at Dusk in the Evening Futuristic during Golden Hour Historical...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
for each v_Day in l_DaysCorrectOrder { m_ShiftBuildUp.put(v_Day, m_ShiftRow); } // // ok let's get the opening times if(m_OrgDetails.get("custom_timing") != null) { l_CustomTimings = m_OrgDetails.get("custom_timing"); for each r_Timing in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Here we need to loop through all the available pages, so including the above plus some calculation to work out how many times to loop should retrieve every thing: // // initialize l_AllProducts = List(); v_TotalCategories = 0; v_TotalProducts = 0;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF