Assuming just is required, the following 277 results were found.
-
I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
...the one with the codes and resource names... Users...the one with users names... Teams...another lookup table for just the name value... The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Webdeveloper-Speakhttps://joellipman.com/articles/cms/website-development/webdeveloper-speak.html
I don't usually write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Type /help for other commands Stealth Mode To keep images private, send these as direct messages to the Midjourney Bot. Just bear in mind that any image in a prompt can be accessed if people work out the link. "Stealth" mode is only available in the...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
it's compatibility with major platforms. The following videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone:...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the following code is an...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Companies using certain password systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in my opinion is a memory aid. How to use Type a word in the input field and check the...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Additional Note Just as a note to do the reverse: upload an image given a URL to an image field (prerequisite: enable the field to allow Image as "Link" not just "Local Computer" or "Camera"): for each r_Image in m_Product.get("images") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
[image]: Update 2023 Again this example doesn't include the publish key but can be used across apps in Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of zoho.appuri, we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
data","status":"error"} trying to submit a CRM date time when it just wants the dropdown option equivalent (eg. "10 mins", "1 hrs") Just as a refresher if this was a task and not a call: v_ReminderDate = v_SystemAppointmentDateTime.subMinutes(15);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
number if(v_CustomerNumber!="") { // // the message we want to send v_Message = "Hi "+v_CustomerFirstName+"! This is just to remind you that we will be phoning you in an hour for your initial consultation with . To reschedule, just reply to this message...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
ZDK.Page.getField("Vendor_Contact_Email").setValue(v_ContactEmail); } } catch (e) { // return error (don't display it, just show it in the logs) log(e); //ZDK.Client.showMessage("Client Script error"); } // unfreeze the GUI ZDK.UI.freeze(false); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But this wouldn't work...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *