Assuming result is required, the following 59 results were found.
-
about 10 minutes without the possibility to cancel (link not working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
'nvarchar(50)') FROM Event_XML.nodes('/*/*[contains(local-name(.),"SURNAME")][1]') AS r(c) -- added [1] to only get 1 result returned ) AS Node_Surname FROM [dbo].[XML_EVENTS] Search if Node or value contains string: -- exist() returns 1 or 0 if a node...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was easier to work out:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
EOT and TOT Your target database table should now be populated... » Read the below "Testing" steps if you aren't getting a result :) Testing: Manual export of XET Run the relevant screen (in our demo this is Application Clearance Decision (ACD)) Go to...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
the documentation provided, and the responses returned as successful, but the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer"....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is terminated Line:(99)"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
order to the invoice. Why? The documentation around the API does not detail how to do this. I also couldn't find any search result via Google or DuckDuckGo (can't say for Bing, I never get around to searching that). This took several hours but it is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
type :POST parameters: c_Params.toMap() connection: “peoplecf” ]; v_EmployeeCount = r_ApiResponse.get("response").get("result").get("employeeCount"); if(v_EmployeeCount >= 1) { c_Response.insert("err1":"You cannot apply leave as another employee has...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // [OPTIONAL] Reset the decision box to false input.Copy_Monday_to_the_Other_Days = false; } The Result So now when I tick this decision box, I get something like the following: Source(s): Zoho Creator/Deluge: Insert rows in Subform Quick refresher:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
11 Pro, other): £959.84 Total: £2,059.65 Not Used Case Fans 2 fans from the 3rd pack of the CoolMoon 120mm Crystal - - The Result: Monitor cable connections I need to practice what I preach: "it's a poor workman who blames his tools". Let's make do with...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
it kept showing the certificate for last year. Chatted to GoDaddy who said use incognito mode and clear cached files - same result Downloaded the ZIP file from GoDaddy for the 7th time and extracted the 3 files Opened CPanel and went to the SSL/TLS...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
} Note(s): There are 2 other payment terms which is by setting payment terms to 0 which will result in a "Due on Receipt". m_InvoiceDetails.put("payment_terms",0); m_InvoiceDetails.put("payment_terms_label","Due on Receipt"); Source(s): Zoho Books API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
complexity, I want to have 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 (aka the Quote Builder)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a table in ZohoAnalytics rather than simply writing a query and using the 'asynchronous' method to extract the query result. To create an analytics table from a query, we do the following: Login to Zoho Analytics, and choose a workspace with the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
end customer clicks on either the accept or decline button. Using ZohoFlow or other Zoho app for a webhook response, would result in the end customer suddenly downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-",...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
On Gui Resize Eventhttps://joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html
are using images, then you will get problems with the image repeating... so use moveDraw which redraws the app. This will result in flickering but it's better than if it isn't redrawing.
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
in with the page background color. Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data. This where transactions are useful. We can run the queries, then check if some...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF