Assuming assuming is required, the following 15 results were found.
-
for this after giving up with a "Data Conversion" task. I then parse the date, month and year out using SUBSTRING: -- Assuming [This_Date]="21/03/2012" (DT_DATE)(This_Date) -- Assuming [This_Date]="20120321" (YYYYMMDD) (DT_DATE)(SUBSTRING(This_Date,6,2)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
I'm using Joomla 1.5.10 and the 'menu' module position.** 1. Create two menus, mine are named 'pubmenu' and 'regmenu'. (Assuming you already have a menu - easiest thing to do is make the new menu in menu manager for reg users. Next, go to the module mgr...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
it to const RECAPTCHA_API_SERVER = "http://www.google.com/recaptcha/api"; STEP #2: Check ReCaptcha Private Key This is assuming you have already signed up for a ReCaptcha key (Google ReCaptcha) Login to your Joomla Administration panel Extensions >...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
notes here on how I've achieved this across multiple monitors... and now multiple desktops. How? The following example is assuming you have 3 monitors and 3 desktops. I'm going to cover the basic code to: 1) get all monitors, 2) open an app on a...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
the attachments to the CRM record, however for now, check the logic of this as this is known to work on the CRM record: // assuming I have a creator form called "myForm" // that the ID of the record is the value of the variable "myRecordID" // that a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
which is the publicly accessible version that you want. Now you can use that value in your HTML. Method #2: Using Deluge Assuming that I have a form called "MyImages" and an image upload field that has the field link name "MyImage". There is an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
on line 86 Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead: m_NestedRequest = Map(); m_NestedRequest.put("auth[key]",v_AuthKey); m_NestedRequest.put("auth[secret]",v_AuthSecret);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
you named your tabs radio field) Name the workflow, I'm calling mine OnUserInput_Tabs Add New Action > Deluge Script: // assuming my sections are called "Tab_Section_1", and so on... [these can be named as you want, the names I've used here are for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
address to every Kindle owner, and that it is unique for every Kindle device. Finding your Kindle email address. That’s assuming you are not aware of yours. However, if you know your Kindle email ID, you can skip this part. Else, here is what you need...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
and then specify which of the options are selected. In this case, simply giving it the IDs should work... but it doesn't. Assuming my multi-lookup field is called "Zoho Inventory Package Slips" and I'm adding these to a Creator form called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
given a deal record ID. Finally, we'll have client script execute this function, then show/hide tabs based on the value. Assuming I have a tab called "Sales Pipeline", and "Hire Pipeline": Go to the deal record and scroll to bottom where you can see an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Wikipedia If you are having difficulty understanding a problem, try drawing a picture. If you can't find a solution, try assuming that you have a solution and seeing what you can derive from that ("working backward") If the problem is abstract, try...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF