Assuming status is required, the following 74 results were found.
-
m_NewTask.put("Subject","Follow Up Non Converted Lead"); m_NewTask.put("Due_Date",v_EndTime.toDate()); m_NewTask.put("Status","Not Started"); // // configure reminder on task to run daily at the same time as creation time m_Reminder = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} } } /* {"code":"INVALID_DATA","details":{"api_name":"id","json_path":"$.tags[0].id"},"message":"invalid tag id","status":"error"} -> Error was due to trying to assign map with removed key to a new map. -> Solution was to remove the assignment and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
hash the challengeCode, verificationToken, and endpoint URL (in that exact order), and respond to eBay with an HTTP 200 OK status, including the hashed result in JSON format within the challengeResponse field. The response's Content-Type header must be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
account is 333), remove other super admins (optional) I also noted the previous admin's ID and returned their super admin status. Sorted by group_id desc and changed 8 to 2. SELECT m.`user_id`, m.`group_id`, u.`username`, u.`email` FROM...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
a date formatted field hits - number of times that weblink has been visited state - this is the J16 published/unpublished status ordering featured To switch the default ordering (ascending / descending), change the ASC to DESC on line 187: $listOrder =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Issues and Errors List Issues List Create an excel spreadsheet that all involved can modify date entered description owner status (open, in progress, closed)? solution date resolved Errors List Clear error logs Refer to list of all pages and run each...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
CMS website :D v0.6 (03/07/2011) - Option to specify name for thumbnails in a batch process. v0.5 (02/07/2011) - Make status bar text describe program events. - Documented more on the help. - GUI now starts resized if it doesn't fit in the computer...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html
spent rendering the report. Source int NOT NULL Source of the report exection (1=Live, 2=Cache, 3=Snapshot, 4=History) Status nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first error is recorded ByteCount...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel EXECUTE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the previous version (using 3rd-party components other than Microsoft SSRS) that the existence of a photo depended on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) SELECT a.id 'ID', a.username 'user_login', REPLACE(TRIM(LOWER(a.username)), ' ', '_') AS 'user_nicename',...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
WHERE StartDate BETWEEN DATEADD(day, -6, GETDATE()) AND DATEADD(day, 6, GETDATE())) AND tt.[Status] 3 AND ( wm.[WeekNumber] = (SELECT TOP 1 WeekNumber FROM [pretendDatabase].[pretendSchema].[WEEKSTRUCTURE] WHERE StartDate BETWEEN DATEADD(day, -6,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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 MyCursor DEALLOCATE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT ' union all ' + @SqlToExecute; SET @myCounter = @myCounter + 1; FETCH...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation + ', ''' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ''' + @TableToProcess + ''', COUNT(*) AS Count...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
by a particular user, “normally used” refers to a typical or common use of that class of product, regardless of the status of the particular user or of the way in which the particular user actually uses, or expects or is expected to use, the product. A...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
@UpdateCursor OUTPUT SELECT @NumberLeft = SUM(1) FROM #Scramble FETCH NEXT FROM @UpdateCursor INTO @Data WHILE @@FETCH_STATUS = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()* CONVERT(VARCHAR(MAX),@NumberLeft) ) SELECT @ChosenID = MAX(ID ) FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Connect to site from (Referers this month) Search Keyphrases (Top 10 this month) Search Keywords (Top 25 this month) HTTP Status Codes (Hits & Percent this month)
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Texas, USA (due to their traffic [when europe is active, these are not and vice-versa] and resilience [99.99% uptime] status compared to European companies). This will have an impact on some of the systems date and time operations (eg. if you get an...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF