What?
A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters.
How?
Let's first define a map:
m_Payload = Map();
m_Payload.put("client_id","my-unique-client-id");
m_Payload.put("redirect_uri","https://www.joellipman.com");
m_Payload.put("response_type","code");
m_Payload.put("scope","my_api_scopes");
m_Payload.put("prompt","login");
Great! ...
What?
I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...
Intro
If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...
... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services.
The Error
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_UTILITY", line 114 ...
... number my bosses want - 7h 24m or 26640s is 1 person day)...
With date range as parameters
...ouch...
...and it was so easy up to here...
Tables of interest
StaffActivities
...
... of this article).
The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...
... specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date.
Solution
Easy for some but anything that I spend 30 minutes ...
... rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows
This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes ...
... 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query).
Problems:
Given a date, the date format ...
... for anything else than tracking stock...?
How?
So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory ...
... the method of "mega-functions", here is the code snippet for one function which will accept as parameter the eBay order reference and generate all the respective records in Zoho Inventory. We're using a ...
... to eBay:";
//info x_Params;
//
// send the request XML as a string
x_ResponseBody = invokeurl
[
url :v_Endpoint
type :POST
parameters:x_Params
headers:m_Headers
];
//info "Respons ...
...
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 ...
... eBay:";
// info x_Params;
//
// send the request XML as a string
x_ResponseBody = invokeurl
[
url :v_Endpoint
type :POST
parameters:x_Params
headers:m_Headers
];
if(v_Page==1)
{
//
/ ...
... as a string
x_ResponseBody = invokeurl
[
url :v_Endpoint
type :POST
parameters:x_Params
headers:m_Headers
];
Parsing the response into JSON or a Deluge Map
This can be appended to the ...
... on how to do this: Youtube - Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's free.
Defaulting some parameters to be added to every prompt
/prefer suffix
This ...
What?
This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit.
Why?
We're creating a custom module ...
... of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week.
How?
As mentioned, using leftpad takes 2 parameters, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.