... t1
PIVOT
(
MAX(t1."Member Status")
FOR t1."Campaign Name" IN ( "Campaign 1","Campaign 2","Campaign 3" )
) t2
The bigger query:
Now create another query (better to refresh the page so ...
... default as you experiment and become more familiar with the tool would be better as changes to your settings may limit your discovery of the variations and styles.
Type /settings then enter/return twice ...
... you can parse the multi-line into a nice HTML table. But on a mobile device, it's somewhat better to use the built-in interfaces provided by Zoho Creator.
What I really needed was a way to display ...
...
Correction / Additional version 2.0
Playing around with this for a client, I found an even better solution! When creating or updating a product, you can instead of giving it Image URLs, give it the ...
... and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of code albeit a brute force to loop through every active product and list their IDs.
How?
So here' ...
...
The advantage of working in a team of Zoho developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query which works ...
... and applying the method .toString("dd/MM/yyyy") is dependent on the settings. But making a date into a SQL format or from largest denominator to smallest in "yyyy-MM-dd" will usually handle the date better. ...
... = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false);
The slightly longer answer to describe this might be better explained if you consider the following snippet of code:
// ...
... and use the following code to populate the multi-lookup field
if(!isnull(r_Create.get("id")))
{
m_Link = Map();
// using record IDs cos there's nothing better
m_Link.put("Test",r_Create.get("id"));
...
... might be better, for example, for confirmation dialogs (embedded form).
Source(s):
Zoho Creator v4 - Functionality based URLs - Opening a form with a record pre-loaded.
Zoho Creator v5 - Print ...
What?
A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine ...
... but less than 2 weeks ago
How?
I know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my needs.
This PHP function accepts ...
... the information we gather
We require this information to understand your needs and provide you with a better service, and in particular for the following reasons:
Internal record keeping.
We may use the ...
... this is the NAZA-M V2
Support for 8 motors
Ability for expansion
Realised that the shell is also the frame of the copter
Padded feet... ugly but protect better than stock
Stock ...
... filming at 1280x720 30fps. The YouTube Capture app has blurred some moments and the quality is somewhat reduced. I had switched stabilization off so the video quality is better than what you see on YouTube:
xw7WKwbYCZI
...
Applies to:
Microsoft Windows 7 Enterprise
AutoHotkey (see code for AHK version)
What?
Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better ...
... /LOG option for better performance.
::
:: File Selection Options :
::
/A :: copy only files with the Archive attribute set.
/M :: copy only files with the Archive ...
What?
This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...
...
If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better.
How?
So this is the HOME tab when you open MySQL Workbench. ...
... when this is better but I'm just trying to add a link to our Sharepoint 2007 portal.
How?
Add a link with the prefix File:// and complete the rest of the path as per usual. Sharepoint will 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.