kwatog & co.

If you encountered this error, you are not alone. I’ve encountering this on my VPS too often that I decided to use FireFTP for a while until I found out that it’s a settings issue.

Here’s what you need to do to solve this.

1. Go to Site Manager of FileZilla
2. Select the FTP connection where you are having problem
3. Click on Transfer Settings tab
4. Check Limit Number of Simultaneous Connections
5. Set Maximum Number of Connections to 1
6. Save and connect to your server

Read more…

Here’s the syntax


sed 's/SEARCH_TEXT/REPLACE_TEXT/g' FILENAME > OUTFILE
SEARCH_TEXT is the text to search in filename
REPLACE TEXT is the string to be put in place of SEARCH_TEXT
FILENAME is the file to be searched
OUTFILE is the file where the output

Sample

sed 's/ORDER/VANTIVE_ORDER/g' kwatogtest.sql > kwatogsed.log


I keep on forgetting that syntax although it’s so simple. There might other ways of doing it but as of now, it’s the only way I know. :p

In case you need to know what version of SQL Server you are currently using, you can use the queries below.

Starting at SQL Server 2000, you can use the following query.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The above query is applicable for SQL Server 2000, SQL Server 2005 and SQL Server 2008. For SQL Server 7 and SQL Server 6.5 series. The code below should be used.

SELECT @@VERSION

If you are not sure what version of SQL Server you have, use the second query. It still works as it isn’t deprecated yet. The new version is handy if you need to get the details programmatically.

When developing themes or doing anything that requires colors, it’s important that you know the hex codes of the color you want to use. They are the 6-number codes that represent a specific color which you use on your CSS.

The list below shows the codes for web safe colors. I kept this list on my usb drive and always had seach from the net numerous times as I don’t bring my usb drive with me all the time. Take note that most of the monitors and browsers can now display millions of colors and shades. Go somewhere else to get all of them hehe

By the way, I only realized now that my little blog site lacks color. Too bad I only realized this after making this post.

In case you are maintaining a pl/sql program developed by someone else and that program writes into a file, then basically that file is written to a folder/directory. And since the directories are saved in codes, you have to find the meaning (or location) of those codes. The code below will help you display the information required.

SELECT * FROM ALL_DIRECTORIES;

The query above will display all the directories accessible to the current user. They are folders in the server where you can write your output files. For some reason, I forgot about this twice already and had to scour the web to find it. The problem is, I also forgot the keywords. So, I’m writing it now.

To register new directories, you can follow the example below.

Example
create or replace directory mydir as 'c:\mydirectory';

To use, run the code below.

declare
f utl_file.file_type;
begin
f := utl_file.fopen('MYDIR', 'myfilename.txt', 'w');
utl_file.put_line(f, 'just another line text 1');
utl_file.put_line(f, 'just another line text 2');
utl_file.fclose(f);
end;