Assuming value is required, the following 197 results were found.
-
'.')) AS "Question Number", q."Text" AS "Question", r."Text" AS "Answer", r2."Status" AS "Status", r3."Variable Value" AS "Respondent Email" FROM "Responses (Zoho Survey)" r LEFT JOIN "Surveys (Zoho Survey)" s ON r."Survey ID" = s."ID" LEFT JOIN...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
to be aware of if you have not come across it before. Why? In many Deluge scripts, assignments are often more than a single value. At times, it can be useful to copy and paste or temporarily format logic across multiple lines to improve readability...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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: *
-
Google Drive folder in your browser and note the last string in the URL. So in https://drive.google.com/drive/folders/, the value where "" sits will be your folder ID. $GAPIS = 'https://www.googleapis.com/'; function uploadFile($access_token, $file,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Authentication process and if you store the credentials in a file, then the JWT is also in the file. A JWT is a three part value delimited by a period/dot. Base64 decode the second part and this will reveal the user's name and email (along with other...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
on cached token So usually an access token will last for 60 minutes, in this example, we are going to store the token value so it is reused until it is about to expire. Firstly, we need to check how many minutes are remaining since the access token file...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand the data. I tried replacing the new...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- 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
-
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
-
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: *
-
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
-
or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings: Accounts Access...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- 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: *
-
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
-
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
-
$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