What?
This is a quick note to show you how to convert a given comma delimited string into a database table:
Given: "Title,Forenames,Surname"
Return:
ID Value
------ ----------------
...
Why?
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...
... summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a ...
... start time, end time...
Report Specification
PivotTable Report
...resources in row (along the side)...
...staff in columns (along the top)...
...persondays in values (the ...
... mean "I don't know". I want the report to either return the correct value or say "No data found". My end-users would otherwise ask is the data value reliable if it's blank?
The long way of doing ...
... like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles.
I have another table holding the audit trail of content approvers ...
In standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). ...
A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. ...
I've been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause ...
The Issue
You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data.
Solution
I've seen a lot of people write CGI requests but ...
...
Preview Module Positions -> Disabled or Enabled
You will still need to suffix the frontend URL with ?tp=1
Joomla 1.5.x
This is another feature which took me a few years to notice in Joomla. ...
This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to ...
... to tidy these all up would leave the data more and more unreliable.
So Shopify want your webhooks to respond within 1 second. This is about enough time to store the record but that's it. Processing ...
... v_TotalProducts + " in " + v_TotalCategories;
//
// if categories >= 100 then should loop this to get all the categories
Code to get all products
Here we need to loop through all the availabl ...
... Report in ZohoCreator
l_CsvLines = List();
l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name;
for each c_Product in l_ApplicableProducts
{
l_CsvRow = List();
l_CsvRow.add(c_Product.Photo);
l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ...
... here an example that demonstrates a basic search on a table of data and returns one record as a result.
The use-case here is that we are enhancing a quote builder form in Zoho Creator. The JS widget ...
... so that I get the popup to enable bi-directional rather than via the tickbox.
The below code is added to a trigger whenever the ticket form is submitted either on creation or modification.
The ...
... from ZohoDesk to ZohoAnalytics using the integration. Other tables will sync but we couldn't find attachments, so our solution here is to create a data table and then to push the attachment from ZohoDesk ...
... to be unable to handle a lot of code or long URLs such as a base64 source URL for an image.
The Plan
Get company phone and website from Organization Details in ZohoCRM.
Upload and get publicly-accessible ...
... as the one used in the Search API call. Code-wise using the same criteria variable for both calls might offer some consistency.
Notes on the attribute: Criteria
You can't compare a date time value ...
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.