... same values, so I should go through the database and change all variations to be typed the same way in the same case.
Wouldn't it be nice to search through your entire database for similar sounding ...
What?
This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity.
Why?
We have a database with data in it. For a particular ...
... and payment date to appear on the invoice.
How?
This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...
... and remind us that we need to phone this Lead.
How?
It sounds straightforward: schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... ...
... would submit the form and then redirect the user to the report view of the records.
Sounds simple but you can only set a form to redirect to one link and adding a HTML anchor link () to the page ...
... to the file explorer in the Microsoft Windows OS.
Why?
I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general.
...
...
Sound ms-settings:sound
Storage ms-settings:storagesense
Storage Sense ms-settings:storagepolicies
Time & Language
Date & Time ms-settings:dateandtime
Japan IME settings ms-settings:regionlanguage-jpnime ...
... page for each minor issue.
How?
So I'm going to try and list solutions to minor errors we run into.
Problem: Zoho OAuth Connection: ERROR_invalid_operation_type
Sounds rather straightforward, ...
... We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words.
How?
Here's just a splurge of SQL but I use this often enough:
UPDATE ...
... "dd/MM/yyyy HH:mm:ss")
-- yields 11/02/2014 11:21:32
Sounds good, where's the problem?
The problem
Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors ...
What?
Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color. ...
What?
This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user ...
... priority to articles where the search term is in the article title.
In the stages thereafter, I'm going to simply enhance the relevance factor:
Soundex: Built-in function to list matches that sound ...
... You can put a distinct on it (not forgetting the collate).
This example is expanded in a further article called "Search a database with soundex":
/* USING A CURSOR */
DECLARE @SqlToExecute nvarchar(max);
DECLARE ...
... 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. ...
... As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking.
Create your stored procedure in Oracle (and ...
... the closest solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good.
Aim / Objective
The plan will be to replace the default "" with a custom null ...
... was successful" or "No sorry you're going to have to go back to the beginning and try that again."... This isn't a solution that sounded good enough for our customers.
The Workaround we actually went ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.