Assuming which is required, the following 337 results were found.
-
socket is used. Multiple servers Use this to connect to a server in a replicated server configuration without concern on which server to use. Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Using...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
doesn’t use the “remove device safely” blab and he got the same error. He (unless Andy is a girls name) posted to a forum which was even more useless asking him about a write-protect switch (physical). The user then said nevermind and found the answer...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
collation being case-insensitive. Furthermore, we now have the task of finding all the variations of the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
they don't get it. If you are reading this, it's likely you've paid for a commercial version of a Microsoft product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an excuse. I also found that examples...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requirements. Why? If you're developing in SITS, and you use the client, the first...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- ---------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...
- Type: Article
- Author: Joel Lipman
- Category: Products
- Language: *
-
you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run contained in the program and can be hidden from the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
into the one desktop. If you have a multiple monitor setup (ie. more than 1 monitor), then MS Windows will almost remember which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
on MS Windows 7 (32-bit) for this particular app. For this reason, we are going to use a function by Skan called Filexpro() which is copied in the below: Filexpro( sFile := "", Kind := "", P* ) { ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
connected to the internet), this program is extremely boring and doesn't do anything. But unlike many other similar programs which add to the network traffic, this program adds NOTHING to the network traffic, and therefore is a much better measure of...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This article serves as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
... Lastly, there is a function I find myself using more and more called equalsIgnoreCase() which could be used:... l_ProductDetails = Product[Product_Name.equalsIgnoreCase(v_Name)];... Other Functions of Interest contains case-sensitive search, can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and MySQL all of which have various ways of escaping the ampersand (except for MySQL which doesn't need to and in my opinion is the best SQL)....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
of what kind of records I am sending as parameters (in this case "Quotes"). As the actual parameter value, select the form which is the singular of the records that you are sending (in my example here I have a form called "Partners Quote". Within your...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
an "X" and then the name of the linked module. A module called "Opportunities_X_Products" is likely to be a linking module which has a multi-select lookup on both the deal/opportunity and products module. A multi-user lookup will tend to have something...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *