... this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form.
How?
So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with ...
... 25-Mar-2020 21:41:07
Setting a TimeZone and extracting the date and time
v_CurrentTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss", "Europe/London");
v_CurrentDatePart = v_CurrentTime.subString(0,10);
v_CurrentTimePart ...
...
INSERT
2014-03-27
Extracting the Gender:
We're going to extract the value in between the opening and closing XML tags:
-- Using .query()
SELECT
CAST(CAST(Event_XML ...
... float:left;
}
#slide_02{
position:relative;
float:left;
}
The JS/Mootools Part
Apologies for the mess as the solution I'm working on is far more complex and I need to keep extracting ...
... #1 working for you with your query and then for every column of data that you are extracting, you will need to use the case statement to either put the value or your empty row. Here's an example of the ...
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.