What?
A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...
What?
This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use".
-- SQL Server 2005
EXEC SP_WHO // details on who is logged ...
What?
Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the ...
What?
So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...
Previously
For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in ...
... that there appears a link that will run a stored procedure which
Updates a timestamp in an existing table
Inserts a row into an audit table
I need the report to run the stored procedure, then ...
... 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 ...
To setup your store to use SSL (Secure Socket Layer) you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" ...
What?
This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them.
Why?
We found ...
... store this after the record is created/updated (was getting error if included in record creation - if in same row).
// c_ImageRow.File_field = f_DownloadFile;
//
// let's get the local ...
...
Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have ...
... // returns 2020
You should also pad single digit week numbers if we're going to store a year week value:
v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("w");
v_ThisCurrentWeekNumberPadde ...
... 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 ...
... each index v_Increment in l_AddPages
{
l_Pages.add(v_Increment + 1);
}
v_TotalNumberOfPages = l_Pages.size();
//
// declare variables to store order details in a JSON or ZohoDeluge Map format
m_Response ...
... ) == "assistant")
{
//
// add the answer text to the response map
v_Response = m_Choice.get("message").get("content");
}
}
}
}
else
{
// store in response text
v_Respon ...
... level or stock check of all the products that are currently listed in a client's eBay store; we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory...
How? ...
... an Access Token to your client's eBay store as that's covered in my article: Zoho Creator: Push to eBay Listings.
Getting the Orders in XML format:
/*
Function: fn_eBay_GetOrders()
Purpose: ...
... add the answer text to the response map
m_Response.put("text",m_Choice.get("message").get("content"));
break;
}
}
}
}
else
{
// store in response text
m_Response.put("text"," ...
What?
So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool.
Why?
The results from the MidJourney bot are beyond unpredictable however with the correct ...
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.