Assuming string is required, the following 141 results were found.
-
Data" The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save" click on "Done" Now click on "Edit Function" under...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) Purpose: Queries DHL for tracking information about a shipment and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that generates an access token of the Trading API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates item/contact/sales order/package...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to preview what records it will delete. I also recommend doing a data backup beforehand. Adapt the below as needed: string standalone.fn_Products_RemoveDuplicates() { /* *******************************************************************************...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection string"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
} } Pushing the product beyond it's design Note that before anyone says I'm only try catching a doomed conversion from string to integer; I've applied this to an actual invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html
for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
Time spent on trying to find a solution was not considered to be warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors advised that...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
- CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ) // yields // 00:00:02.1543570 -- problems with adding a string to it? CStr will not work, use .ToString ="Time Taken: " & ( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
overall report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
on this new key and add a key to this one called "command" Under the "command" key, double-click the "(Default)" string in the right-pane and type the following c:\windows\system32\cmd.exe /c "ECHO > c:\temp.txt | FC /N /LB 1000 %L c:\temp.txt >...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, 1, 4))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 6, 2))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 9, 2))=1 SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
some variables to use DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@NewVal varchar(max); DECLARE @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;...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
we didn't use parentheses? Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
where you put your Data Sources, click on the button "New Data Source" Specify the details, especially the connection string (which the system account can use). Set "Connect Using" to "Credentials supplied by the user running the report". Browse to your...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the Core Joomla code for ReCaptcha: 1. Open the file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the following string in the OnDisplay function: return ' '; 3. and replace with: // Replace YOUR_KEY with your public key return ' window.onload =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF