Information
Total Authors: 23
Total Articles: 49
The following code is from http://www.devx.com/tips/Tip/17608 by Khurram Iqbal. As the website suggests, some additional modifications may be necessary. I will update the code later to handle these edge cases.
create function [dbo].[initcap] (@text varchar(4000))
returns varchar(4000)
as
begin
declare @counter int,
@length int,
@char char(1),
@text...
This simple command will provide a list of all tables in a selected database for the Progress OpenEdge database system.
SELECT "_file-name" FROM pub."_file"
This is equivalent to MySQL's command:
SHOW TABLES
Also, T-SQL's syntax (SQL-92 standard for many other databases, including MySQL):
Below is the updated Reddit Uppers and Downers Enhanced. This update forces RUDE to wait for 25ms after processing for 50ms to allow the UI to update. One complaint that I've often had is that the UI gets stuck when there are a lot of comments on the page. This update should fix that issue. It also speeds up the code quite a bit by processing the objects slightly better than before.
A known bug that might occur is on some comments the script doesn't create the ups/downs span. T...
Some database software export utilities will create CSV files that have illegal characters in them. These CSVs can cause other software to produce errors when importing the null characters.
If you open one of these bad files up in Notepad++ you might notice a record like this:
NULL"123","John ","Doe ...
In database design it can be nice to have a very flexible database for logging or configuration of resources. This flexibility is obtained by normalizing your database design to the third normal form (3NF) or beyond. One situation that may come up is that a table may have key/value pairs that link to another table and you would like to produce a SQL query which aligns the keys as columns and the values below those columns. I've...
This article will explain a solution to a common problem - synchronizing two folders - using VBScript and XCopy.
The reason for developing this script was that I needed a method to synchronize a folder on my local machine to the IIS-enabled folder on a development web server. This would allow my Integrated Development Environment, SharpDevelop, to be snappy while I used its SVN features. If I ...
This is a placeholder for later documentation. The trigger used is below. You will need to install the Oracle Automation extension from the Oracle Universal Installer. More information is to come... create or replace TRIGGER UMRA_STUDENTS_INSERT AFTER INSERT ON UMRA_STUDENTS REFERENCING NEW AS newRow FOR EACH ROW DECLARE retval binary_integer := -1; conretval binary_integer := -1; execretval binary_integer := -1; umra binary_intege...
While working with Active Directory automation projects, one of the many things I run into is the need to sync multiple data sources. Usually we would perform a join using User Management Resource Administrator (UMRA). While this type of join produces 3 types of results, one being that the record is located within both data sources, it doesn't provide a method to determine which records have been modified...
Edit: I have cancelled this download due to a recent move and computer update. The old video is still online and the process is shown in link below if you would like to copy it. You can also find the link to the NASA website in the next page.
I've created a process to turn the webcam images from the JWST website into a video for your viewing pleasure. It's updated each day with the latest set of images. The images are downloaded every 10 minutes.
...
Here is my VB GUI interface to track an IP. Enjoy.
Startup Screen
Search Screen