Assuming value is required, the following 196 results were found.
-
{ // get the ID from the lookup field called "Vendor Contact" var v_VendorContactID = ZDK.Page.getField('Vendor_Contact').getValue().id; // get the record details for this contact record (note this is ZDK.Apps.CRM but my syntax highlighter lowercases...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Reporting Service (SSRS) report. I am guessing that Series1 is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data fields)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file. CHANGELOG: Version 1.0 + This is version 1.0 unless people have suggestions I don't see the need to release service...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest data value. Cause 3: Fields and objects in the same column do not have the same text alignment For example, the column heading text...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
the service. Cheque overpayment. A buyer, prospective tenant or even an employer will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
builder or business intelligence development studio, you can specify in the report designer how to format the returned value to a more user-friendly date format (such as Month name then year - eg. November 2010). I have been told that data types are a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that will be...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
do it to the first column then bring up the properties pane and scroll down to the "Fill > BackgroundColor" row and copy the value to your clipboard or notepad, etc. Then select all the remaining cells in the row and paste your expression in the "Fill >...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
$didyoumean_words_array=array(); // Note: for some systems you can do a levenshtein on two words soundex value and compare these. // Be warned that it does go off track though in terms of relevance... Sources: iamcal.com Nadeau Software
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
execution auto-redirect after are a report is run ssrs vbscript post report processing ssrs auto redirect based on a dataset value
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
%Format% return Formattedtime } The following function is to convert a given SQL date or a European date formatted value: FormatDate(val) { ; SQL format (yyyy-mm-dd HH:mm:ss) IfInString, val, - { StringReplace, val, val, -,,All StringReplace, val, val,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
I am at the moment without VBCode and other suggestions. Instead I add a newline in front of and after the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single value, which is all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
processing the overall report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
function applied to a number. You will need to be more vigilent. Variables are all cleared and redefined. To pass a value to this script you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Color Ambient Turquoise Add a \templates\\css\background\ambientturquoise.css file. Note the same filename as in the option value of the previous step. body#page { background: #f4f5f5 url(../../images/background/ambientturquoise/ambientturquoise.jpg) 0...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
as "{CR}{LF}" - my rows to skip is because of the state of my data): Crucial fix here, add 2 to the OutputColumnWidth value. It seems you need to set the data column to accommodate for the special characters the blank rows somehow feed in. In this case,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the full path and the first file including its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate" value to when you leave, compile the code into an executable, and schedule it as a windows task for when you are logged in: ; ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF